sub reporting | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sub reporting


Hello, We need to create a report which has many sub reports as follows 1) Get the customer and the bill date as a parameter
2) report 1 should be cover letter
3) report2 details from table1 for that customer starting from a new page with format 1 (can span across several pages)
4) report3 details from table2 for that customer starting from a new page with format 2 (can span across several pages)
5) report4 details from table3 for that customer starting from a new page with format 3(can span across several pages) Could you please guide me on the efficient way to achieve this.
Thanks
Shivi

http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx orhttp://download.microsoft.com/downl…5a-0aed1c18a31e/reporting_services_design.doc on design best practices andhttp://msevents.microsoft.com/cui/eventdetail.aspx?eventID=1032283045&Culture=en-US too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
in subreport control there is parameter option from which you can match parameters that you want to pass. Depending on you requirment, you may have to have several sub reports so that you can pass nessary values of them —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

Thanks for your replies. I have done this by creating multiple tables in a single RDL and each table gets the data from different tables. For each table I have coded the VISIBILITY property with the expression =iif(Parameters!Showtable1.Value ="Y",false,true)
so when the user passes Y to showtable1 parameter then the table is populated and shown in the report or this report alone will be skipped
But the issue is I need a page break at the end of the each table as each table is a report. I have set the pagebreakatend property to TRUE but Iit is not working. Is there a way to manually insert a page break plEASE HELP
missed to mention one point.. when I removed the expression =iif(Parameters!Showtable1.Value ="Y",false,true) from table VISIBILITY property then page break is working.. But I need this expression and pagebreak together..
Thanks,
Shivi

]]>