Reporting services

Hi all,
I have three data sets to populate a report. and after this I have to use these datasets in an expression but they cause these errors which says that the report item needs to be in the same scope as the dataset and that it cannot be used in an aggregate function. Can we use multiple dataset in an expression inside the a report if so how? (p.s one of the datasets is a stored proc) what this sproc does is that it give a header name for my report headers. the others r used to populate the detail row by comparing it with the sproc as well as the other dataset.

any ideas?
thanks

Forum for reporting services:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1

Thanks

Reporting Servers - Export to Multiple tabs in Excel

I need to create a Reporting Services report that contains multiple result sets. I want each result set to export to a different tab in Excel. I want to be able to name the tab. I would also like the headings in Excel to show up in the Header section of Excel, rather than in the body of the spreadsheet. Is there a way to accomplish this task.

Put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.

For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders (see http://msdn2.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx). If you want this to be the default, you can add it to the RSReportServer.config file (see http://msdn2.microsoft.com/en-us/library/ms156281.aspx).

|||Is there a way to specify the name of the Excel tab, instead of Sheet1?|||

I would like to do this also. Is there any way to name each Sheet?

|||Unfortunately no, you cannot control the sheet naming.|||

Thanks for answering Mike.

Do you know if there are any plans to add this capability?

|||

I can find no reference to this in the documentation and it appears to be ignored - presumeably this is RS 2005 only? (I'm using 2000 SP2).

Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.

Reporting Servers - Export to Multiple tabs in Excel

I need to create a Reporting Services report that contains multiple result sets. I want each result set to export to a different tab in Excel. I want to be able to name the tab. I would also like the headings in Excel to show up in the Header section of Excel, rather than in the body of the spreadsheet. Is there a way to accomplish this task.

Put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.

For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders (see http://msdn2.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx). If you want this to be the default, you can add it to the RSReportServer.config file (see http://msdn2.microsoft.com/en-us/library/ms156281.aspx).

|||Is there a way to specify the name of the Excel tab, instead of Sheet1?|||

I would like to do this also. Is there any way to name each Sheet?

|||Unfortunately no, you cannot control the sheet naming.|||

Thanks for answering Mike.

Do you know if there are any plans to add this capability?

|||

I can find no reference to this in the documentation and it appears to be ignored - presumeably this is RS 2005 only? (I'm using 2000 SP2).

Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.