Can this be done?

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.
DBcan u show a sketch of how you want your report to be..
check if document map serves your purpose'
"DaveB" <dbraseth@.comcast.net> wrote in message
news:e573af22.0409161853.30e2d6ba@.posting.google.com...
>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.
> DB|||hi Dave,
i have the same problem. please let me know if you find a solution.
Thanks, Mirela
"DaveB" wrote:
> 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.
> DB
>|||"avnrao" <avn@.newsgroups.com> wrote in message news:<uq2KJhHnEHA.3324@.TK2MSFTNGP15.phx.gbl>...
> can u show a sketch of how you want your report to be..
> check if document map serves your purpose'
>
> "DaveB" <dbraseth@.comcast.net> wrote in message
> news:e573af22.0409161853.30e2d6ba@.posting.google.com...
> >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.
> >
> > DB
Good idea - but I'm not sure how to sketch it in text. Ideas?|||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
"DaveB" <dbraseth@.comcast.net> wrote in message
news:e573af22.0409170553.329ce3ea@.posting.google.com...
> "avnrao" <avn@.newsgroups.com> wrote in message
news:<uq2KJhHnEHA.3324@.TK2MSFTNGP15.phx.gbl>...
> > can u show a sketch of how you want your report to be..
> > check if document map serves your purpose'
> >
> >
> > "DaveB" <dbraseth@.comcast.net> wrote in message
> > news:e573af22.0409161853.30e2d6ba@.posting.google.com...
> > >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.
> > >
> > > DB
> Good idea - but I'm not sure how to sketch it in text. Ideas?|||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
"Mirela" wrote:
> hi Dave,
> i have the same problem. please let me know if you find a solution.
> Thanks, Mirela
> "DaveB" wrote:
> > 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.
> >
> > DB
> >