 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / December 2005Rendering different reports into a single PDF
I have 2 reports, my requirement is to render these 2 reports into a single PDF file (kindof like appending the reports). Is this possible with reporting services?? How? TIA An, Your best bet would be to create a 'master' report that contains the 2 reports you want in a single PDF as subreports in the master report.. Andy Potter You could have both reports on one report: Make 2 data sets on the one report. And in layout, you need to place 2 tables. Right click on the first table and set the "Data Set Name" to the first data set. As for the second table, set the data set to the second other data set. regards, Stas K. your solution cause the dev. to create a new report instead-of using the 2 existing reports. and then there are 3 reports to manage. but there is an advantage, the dev. can create a new layout for all the queries instead-of reusing the layout of the 2 first reports. > You could have both reports on one report: > [quoted text clipped - 7 lines] > > Stas K. Jeje, Perhaps I was unclear: DELETE the second report. Only use 1 report in which there are 2 tables using 2 differnt datasets - 2 differnt datasets NOT 2 different REPORTS. but the question is not this the question is: how to create 1 PDF from 2 reports. this mean that the dev. want to keep 2 reports, but want also to produce 1 PDF based on these 2 reports. 2 different needs. > Jeje, > > Perhaps I was unclear: > DELETE the second report. > Only use 1 report in which there are 2 tables using 2 differnt datasets > - 2 differnt datasets NOT 2 different REPORTS. Jeje, In this case I would concur with Potter's idea of making one report into a sub repor and placing it in the first report. I just gave another alternative. regards, Stas K. good point. a new parameter to ask the user if he want to display or hide this subreport will be usefull. > Jeje, > [quoted text clipped - 5 lines] > > Stas K. Thanks for the replies...but what i have right now is something similar to what Sorcerdon has mentioned. i.e. there is a report with around 10 tables and datasets for each of them. i have report parameters that decide to display the tables or not. there is a UI application which calls the Render method when the user wants to generate a report. the output is in PDF format. but report rendering takes a long time. so was thinking of an alternative. i.e. having 2 reports and rendering each report based on user parameters. but then would it be possible to append the byte arrays. i realised that its not possible to append byte arrays when they are of PDF format. any solution to this??? I think subreport would be a good option. let me try that out and see the rendering speed. Mr. AN, Another perhaps more complex, but high performance solution would be to assemble your RDL based on user selection. You could have 10 snippets of RDL, one for each table. If a user wants 4 of the 10 tables, put the RDL snippet for those 4 tables in the main RDL and submit it to the report server. This would you prevent any unnecessary querying. There are a few samples out there for generating RDL. Andy Potter |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.