all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

Can this be done?


Can this be done? dbraseth NO[at]SPAM comcast.net
9/16/2004 7:53:57 PM
sql server reporting services:
I have to generate a 2-part report like this:

part 1: A summary (just a table) with each row being a row in the
dataset. This could be 500 or so rows.

part 2: A detail where each page is equal to a row in the dataset
(same dataset).

The trick part is this. The summary MUST be on letter-size paper.
The detail part MUST be on legal size paper. They MUST be in the same
print job - not 2 separate reports (maybe a subreport?)

I assume I must have a report (summary) which contains a subreport
(detail) and then render it as a PDF.

Any ideas/infoi/suggestions GREATLY appreciated.

RE: Can this be done? Mirela
9/17/2004 1:09:02 AM
hi Dave,

i have the same problem. please let me know if you find a solution.
Thanks, Mirela

[quoted text, click to view]
Re: Can this be done? dbraseth NO[at]SPAM comcast.net
9/17/2004 6:53:44 AM
[quoted text, click to view]

Re: Can this be done? Bruce Loehle-Conger
9/17/2004 9:13:06 AM
I don't think that you can change page size from page to page but I am not
100% sure. You could do a quick check, create a subreport and make it legal
and put it on a report that is letter size. I think this is the key issue.
Otherwise, what you are going to have to do is do a lot of it your self with
a front end that you integrate with Report Services using web services
integration.

Bruce L-C

[quoted text, click to view]

Re: Can this be done? avnrao
9/17/2004 11:06:21 AM
can u show a sketch of how you want your report to be..
check if document map serves your purpose??


[quoted text, click to view]

RE: Can this be done? DaveB
9/23/2004 1:37:17 PM
OK - here's the compromise...
2 reports.
each is rendered to a blank form and turned into an inline pdf.
the user (at this point) must print them in order

When using the subreport approach, it looked like the sub inherited the
margins of the main (maybe I'm doing it wrong) - so that was not useful for
me.

HTH

[quoted text, click to view]
AddThis Social Bookmark Button