Combining Reports

I'm trying to create a report that is actually 4 reports. Each has it's own page headers and Footers.

I can't use sub reports because I need the headers and footers to show for each indivual report.

My output is going to be PDF, and I know how to write code that i could use to combine the PDFs but I really want to do this in the report. I don't want to have to use some outside process to get my wanted output, If I can get away with it. Any help is appreciated!! Thanks.

There is no way to combine the reports into one PDF without an outside process.|||

Brad,

Your response not only lacks details but leaves me with the impression that combination reports will never be supported in Reporting Services. I have been developing reports for more years than I like to admit and I can say with hesitation that building a report that consolidates the output from several reports is by no means an uncommon practice. If Reporting Services wants to be an "enterprise" solution supporting common practices is going to have to become a priority.

Mark73

Combining Reports

I'm trying to create a report that is actually 4 reports. Each has it's own page headers and Footers.

I can't use sub reports because I need the headers and footers to show for each indivual report.

My output is going to be PDF, and I know how to write code that i could use to combine the PDFs but I really want to do this in the report. I don't want to have to use some outside process to get my wanted output, If I can get away with it. Any help is appreciated!! Thanks.

There is no way to combine the reports into one PDF without an outside process.|||

Brad,

Your response not only lacks details but leaves me with the impression that combination reports will never be supported in Reporting Services. I have been developing reports for more years than I like to admit and I can say with hesitation that building a report that consolidates the output from several reports is by no means an uncommon practice. If Reporting Services wants to be an "enterprise" solution supporting common practices is going to have to become a priority.

Mark73

sqlsql

Column headers for Matrix

I am developing a matrix report in SRS. In columns group there are several values. When report runs they apper in any order based on the first record in row group. I want colums to apeear in specific order all the time. For example the column sequence in one out put is Follwup 1, Initial , Followup 2. I want to column header to be in order of Initial, Folloup 1, Followup 2.

Can someone help?

You'll need to add another column like Sort or Rank and populate that accordingly. Then sort the output based on that column. If you have several columns that are dynamic that would be best.

pseudo-code for the sort column in your SQL would be:
Case
When "Followup 1" Then 1
When "Initial" Then 2
When "Followup 2" Then 3
End as MyCustomRank

You can also use an expression in the matrix sort...same concept. The pseduo-code for that would be

=IIF(Fields!YOURFIELD.Value = "Followup 1", 1, IIF(Fields!YOURField.Value = "Initial", 2..... and so on

|||

Thank You very much

It worked!

Column headers for Matrix

I am developing a matrix report in SRS. In columns group there are several values. When report runs they apper in any order based on the first record in row group. I want colums to apeear in specific order all the time. For example the column sequence in one out put is Follwup 1, Initial , Followup 2. I want to column header to be in order of Initial, Folloup 1, Followup 2.

Can someone help?

You'll need to add another column like Sort or Rank and populate that accordingly. Then sort the output based on that column. If you have several columns that are dynamic that would be best.

pseudo-code for the sort column in your SQL would be:
Case
When "Followup 1" Then 1
When "Initial" Then 2
When "Followup 2" Then 3
End as MyCustomRank

You can also use an expression in the matrix sort...same concept. The pseduo-code for that would be

=IIF(Fields!YOURFIELD.Value = "Followup 1", 1, IIF(Fields!YOURField.Value = "Initial", 2..... and so on

|||

Thank You very much

It worked!

Column Headers at the top of the page....?

I have a report looking something like this:

Field 1 Field 3 Field 5

RandomInfo1 RandomInfo1 RandomInfo1

RandomInfo2 RandomInfo2 RandomInfo2

Field 2 Field 4 Field 6

RandomInfo1 RandomInfo1 RandomInfo1

RandomInfo2 RandomInfo2 RandomInfo2

It extends along a fair number of pages, and I'm currently using the "# of columns = 3" in the Report properties --> Layout section in order to make it span over 3 columns instead of the usual 1. I'm using a table in which the random info fields are the repeating values, and the Field 1,2,3,4,etc are included in the list control, but not part of the physical table itself.

My question stems from a couple of chunks of data which basically extend over the course of 1.5 pages (yep. There's enough to fill about 4.5 columns worth.)

I currently have

Field 1 RandomInfo50 RandomInfo100

RandomInfo1 RandomInfo51 RandomInfo101

Randominfo2 RandomInfo52 RandomInfo102

etc.... etc.... etc....

--NewPage-

RandomInfo150 Field 2

Randominfo151 NewRandomInfo1

RandomInfo152 NewRandomInfo2

etc...

What I'm looking to do is have "Field 1" appear at the top of each column whenever a larger chunk of data forces itself into multiple columns, or even multiple columns on multiple pages. I have this nasty feeling it's something silly and blatantly obvious I'm missing...

Any thoughts?

Is "repeat header rows on each page" checked in the properties for the matrix/table?|||

Wow.

I swear I tried that in earlier attempts... It caused a strange... bleh. No matter!

Cheers Greg!

Column Headers at the top of the page....?

I have a report looking something like this:

Field 1 Field 3 Field 5

RandomInfo1 RandomInfo1 RandomInfo1

RandomInfo2 RandomInfo2 RandomInfo2

Field 2 Field 4 Field 6

RandomInfo1 RandomInfo1 RandomInfo1

RandomInfo2 RandomInfo2 RandomInfo2

It extends along a fair number of pages, and I'm currently using the "# of columns = 3" in the Report properties --> Layout section in order to make it span over 3 columns instead of the usual 1. I'm using a table in which the random info fields are the repeating values, and the Field 1,2,3,4,etc are included in the list control, but not part of the physical table itself.

My question stems from a couple of chunks of data which basically extend over the course of 1.5 pages (yep. There's enough to fill about 4.5 columns worth.)

I currently have

Field 1 RandomInfo50 RandomInfo100

RandomInfo1 RandomInfo51 RandomInfo101

Randominfo2 RandomInfo52 RandomInfo102

etc.... etc.... etc....

--NewPage-

RandomInfo150 Field 2

Randominfo151 NewRandomInfo1

RandomInfo152 NewRandomInfo2

etc...

What I'm looking to do is have "Field 1" appear at the top of each column whenever a larger chunk of data forces itself into multiple columns, or even multiple columns on multiple pages. I have this nasty feeling it's something silly and blatantly obvious I'm missing...

Any thoughts?

Is "repeat header rows on each page" checked in the properties for the matrix/table?|||

Wow.

I swear I tried that in earlier attempts... It caused a strange... bleh. No matter!

Cheers Greg!

Column Headers

Is there a way in a report to ensure Columns headers stay in place when
scrolling through data?This is available in Reporting Services 2005 (e.g. you can try it in the SQL
Server 2005 CTP April).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Davie Wilson" <dxw@.mms.co.uk> wrote in message
news:%23yNrg3UXFHA.2740@.TK2MSFTNGP14.phx.gbl...
> Is there a way in a report to ensure Columns headers stay in place when
> scrolling through data?
>|||take it there is no work around at present?
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OlGewtXXFHA.1240@.TK2MSFTNGP14.phx.gbl...
> This is available in Reporting Services 2005 (e.g. you can try it in the
SQL
> Server 2005 CTP April).
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Davie Wilson" <dxw@.mms.co.uk> wrote in message
> news:%23yNrg3UXFHA.2740@.TK2MSFTNGP14.phx.gbl...
> > Is there a way in a report to ensure Columns headers stay in place when
> > scrolling through data?
> >
> >
>|||Correct, it is not available in RS 2000.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Davie" <dxw@.mms.co.uk> wrote in message
news:OY5Fn4dXFHA.796@.TK2MSFTNGP09.phx.gbl...
> take it there is no work around at present?
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:OlGewtXXFHA.1240@.TK2MSFTNGP14.phx.gbl...
>> This is available in Reporting Services 2005 (e.g. you can try it in the
> SQL
>> Server 2005 CTP April).
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Davie Wilson" <dxw@.mms.co.uk> wrote in message
>> news:%23yNrg3UXFHA.2740@.TK2MSFTNGP14.phx.gbl...
>> > Is there a way in a report to ensure Columns headers stay in place when
>> > scrolling through data?
>> >
>> >
>>
>