Multiple Report Rendering in Reporting Services

[SemperFiDownUnda]

Hi all,
I'm trying to create some reports that the users are creating by lots of cutting and pasting but I'm having a few problems getting them to render correctly.

I've got a report that normally was done in Excel and I have it doing almost what I want but the Excel Renderer keeps rendering the sub reports on different sheets.

What I want is the main report to run then the 2 other reports to appear just below the last lines of the main report on the same work sheet.

No matter what I try export to Excel either does not render the sub report, giving me an error that the subreport can not be rendered in a cell matrix or table (something like that) or it renders on a seperate sheet.

Now rendering the same report to PDF puts the subreports at the end like I want but the user doesn't want 2 columns that have a block of text to show all the text, ie grow the height of the row, which Excel does fine, only showing the first line of text, but PDF expands the row.

Any help you can provide will be greatly appreciated.

Thanks in advance
Wayne

Hope I've been helpful,
Wayne Francis

If you want to get the best response to a question, please check out FAQ222-2244 first

 

[SemperFiDownUnda]

Ok I've solved this problem. Solution below.

Manually building the reports from scratch I figured it out.

Here is what you do.

1) Define multiple datasets. One for each report you want.
2) Create multiple "table" items on your Layout.
From here you can drag and drop fields from your different datasets into the table cells, add grouping levels etc.

One thing I found a bit weird was creating the report title. I used a text box and just used the function
FIRST(Fields!FieldName,"DatasetName") to put values from a query into the system.

Now it could be me or it could be a bug but the first few times I tried this it complained about the dataset. I got it working eventually. Now I have a report that is really 3 reports that display in 1 Excel Worksheet.

Very nice

Thanks for anyone that was investigating. If anyone has tips on this please feel free.

Regards,
Wayne


Hope I've been helpful,
Wayne Francis

If you want to get the best response to a question, please check out FAQ222-2244 first