I have a main report which has 2 parameters (int and bit).The report is working fine. I have another report which is related to the main report and which has the same parameters (int and bit). I am using the second report as subreport to the main report. Done with the settings like passing the parameters and giving the name of subreport by right clicking the gray subreport box and selecting the properties. Yet when I preview the main report I am not able to see the subreport. what else settings i need to do? Thanks in advance.

hi, I am creating a report in SQL Reporting Services 2005. The data is coming from a stored procedure which has multiple select statements (multiple result sets). When I bind the report with the dataset ,I am getting the data only from the first select statement (1st table), whereas I am getting the data from each select statement in the stored procedure. Is there any way to get the data while designing the reports? Thanks in advance.

I am using SQL Reporting Services to create reports. The report contains limited number of rows in the middle of the report page along with the different information on the entire page. For eg:- If there are 10 rows in the dataset, then the report should contain 5 rows on 1 report page along with other information and the remaining 5 on other page along with the same information. Can anyone help me with this? Thanks in advance.

I am displaying a report that has table control on it. I want that the table should display first 5 rows on the first page of the report , next 5 on other page and so on. Can anyone help me with this? Thanks in Advance.

I am trying to set dynamic field in the page header . If the report has multiple pages, header(with the field) occurs while viewing the report. But while exporting to PDF or Excel , header(with the field) comes on first page only. Other pages do not contain the header information. Thanks in advance