SSRS 2005 Sub report issue (newbie)
-
Hi All, I have 3 reports that run fine individually showing headers and data. The queries use no parameters just a calculated date within the query. I'm trying to place all 3 reports (They are related but do not require each other)into one document as this is the user requirement and thought that this would be easy using the sub-report feature. I've taken 1 report and tried dragging and dropping one of the other reports onto the report layout designer where it appears as a grey box with the name of the report in the centre. I've checked the visibility is set to visible and data output is set to Yes (I'm guessing here). When I preview the report the first report shows fine, i.e. the one I started with, but subsequent reports do not show at all - header or data. Googling the issue makes me think I'm doing something fundamentally wrong as I can't find a post that outlines the same issue. Any ideas? Cheers Paul
-
Hi All, I have 3 reports that run fine individually showing headers and data. The queries use no parameters just a calculated date within the query. I'm trying to place all 3 reports (They are related but do not require each other)into one document as this is the user requirement and thought that this would be easy using the sub-report feature. I've taken 1 report and tried dragging and dropping one of the other reports onto the report layout designer where it appears as a grey box with the name of the report in the centre. I've checked the visibility is set to visible and data output is set to Yes (I'm guessing here). When I preview the report the first report shows fine, i.e. the one I started with, but subsequent reports do not show at all - header or data. Googling the issue makes me think I'm doing something fundamentally wrong as I can't find a post that outlines the same issue. Any ideas? Cheers Paul
I've just found out (by accident) that sub-reports in my version of BID do not preview - Once deployed they show up fine.