Ok not sure if this is where im meant to post my problem. But currently i'm generating a report through a webpage coded using vb.net.
I create the reporitng service and set the credentials and then set the render arguments. i then call the reportingservices.render method to generate the report which all works fine. Currently the report takes in one paramater, in this case a invoice number and the report returned is an invoice. The report returned is a PDF file.
Now i'm wondering is there anyway to have the reporting service recieve multiple invoice numbers as a parameter and in return prints ALL invoices into one pdf file?
7 2837
That is not the task of reporting services. Thats ur logic. You can achieve this in crystal reports itself. Else try with Farpoint.
:)
Hey thanks for the reply, i started thinking about this and now im not sure if this will work. But the render method returns a byte array so i tried to render two reports and return it in Byte1 and Byte2 arrays. Then i declared a filestream and created a file with the length of both these arrays lengths. THen i tried to call the Write method and write the two bytes into the file. Would this work?
I've got the following code
Two byte arrays which have been rendered and then
Dim length As Integer = Data.Length + Data2.Length
Dim stream As FileStream = File.Create("report.pdf", length)
stream.Write(Data, 0, Data.Length)
stream.Write(Data2, Data.Length length)
stream.Close()
I don't think this is possible. There are several 3rd party solutions (see this link for a discussion of one that works with Crystal Reports: http://aspalliance.com/571_Merging_a...rystal_Reports) that can accomplish this task. I like your creativity, though!
Hey thanks for the reply, i started thinking about this and now im not sure if this will work. But the render method returns a byte array so i tried to render two reports and return it in Byte1 and Byte2 arrays. Then i declared a filestream and created a file with the length of both these arrays lengths. THen i tried to call the Write method and write the two bytes into the file. Would this work?
I've got the following code
Two byte arrays which have been rendered and then
Dim length As Integer = Data.Length + Data2.Length
Dim stream As FileStream = File.Create("report.pdf", length)
stream.Write(Data, 0, Data.Length)
stream.Write(Data2, Data.Length length)
stream.Close()
lol im still new to all this and i dont know whats possible.
But i cant use crystal reports as we already have all our reports written using sql reporting services. I'm sure if you have two byte arrays you can just combine it and get it to display?
Try looking into the following: http://forums.microsoft.com/MSDN/Sho...39828&SiteID=1
lol im still new to all this and i dont know whats possible.
But i cant use crystal reports as we already have all our reports written using sql reporting services. I'm sure if you have two byte arrays you can just combine it and get it to display?
Would it not be possible for you to change the parameters for report and, instead of taking a single id, accept a string. Then, your SQL query could return multiple invoices by doing a :
select
*
from
invoice_table t
where
t.id in (@parameterIDString)
instead of
select
*
from
invoice_table t
where
t.id = (@parameterID)
Not sure if that helps, but I've done that before and gotten it to work.
Hi everyone.
I rendered two reports to PDF, joined the two byte arrays into one, created a FileStream and write the byte array that contains the reports into the file. The file is created with the correct length but, when I open the PDF, it only shows the last report. Does anyone have a solution for this?
Thanks,
Aligieri
Hey thanks for the reply, i started thinking about this and now im not sure if this will work. But the render method returns a byte array so i tried to render two reports and return it in Byte1 and Byte2 arrays. Then i declared a filestream and created a file with the length of both these arrays lengths. THen i tried to call the Write method and write the two bytes into the file. Would this work?
I've got the following code
Two byte arrays which have been rendered and then
Dim length As Integer = Data.Length + Data2.Length
Dim stream As FileStream = File.Create("report.pdf", length)
stream.Write(Data, 0, Data.Length)
stream.Write(Data2, Data.Length length)
stream.Close()
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Justin |
last post by:
Hello,
I am having a weird problem installing SQL Server Reporting services
on my PC. I installed the beta version and had some initial problems
in the VS.net IDE that would not allow me to...
|
by: Teo Lachev |
last post by:
I would like to introduce you officially to my book "Reporting Services in
Action" and let you know about its availability. I wrote this book for
information workers, system administrators and...
|
by: P Jones |
last post by:
Hi,
I support an enterprise web application (IE client) built in VB6, with about
200 classes, serving about 7000 users, running on 3 clustered servers. I
need to incorporate web reporting for...
|
by: Woody Splawn |
last post by:
I am asking this question here because I asked this question in the
Reporting Services Newsgroup and did not get an answer. Does anyone know if
Reporting Services is intended to work in a...
|
by: LeAnne |
last post by:
I've got SQL Server 2000 Developer edition.
Now, where can i get the SQL Server 2000 Reporting Serives from for Win XP
Pro??
I can't seem to find a link or any page where I could download this...
|
by: rmk |
last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services
both working on my development laptop ?????
I have ASP.NET 1.1 and 2.0 installed on my laptop.
I have Visual Studio...
|
by: YellowfinTeam |
last post by:
Marketplace: Yellowfin reporting 3.1 with BIRT Integration
Yellowfin is proud to announce the release of 3.1.
The major theme of this release is enhanced integration capability. We
have...
|
by: Blasting Cap |
last post by:
I'm using VS 2005, SQL 2005 reporting services.
SQL reporting services is working, and I have it both on my local
computer, as well as on a server.
I've created a report in the SQL Business...
|
by: Todd VanDenHul |
last post by:
Hey All,
Does anyone know of any good reporting engines for .NET? We're
currently evaluating Telerik, Reporting Services and Crystal Reports.
We need to be able to have multiple input/output...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |