SQL Server Community FAQs Manual by SQL Server TechNet Forum Support Team

Author:SQL Server TechNet Forum Support Team
Language: eng
Format: epub, mobi
Publisher: Microsoft Corporation
Published: 2013-06-20T16:00:00+00:00

report parameter:name->cust, datatype->string

report body: drag a table control and only one detail cell via deleting other cells, and put the =Fields!subtotal in this cell. Adjust this report page size to fit on one cell of the main report Group2 footer. On the main report, in the cell displaying the subtotal of "CustomerType" of Group2 footer, insert a Subreport control to reference this newly created report and set this subreport parameter "cust" point to =Fields!CustomerType.value.

2. After implementing any option of the first step, the subtotal based on the "CustomerType" will be displayed in each Group2 footer. Now, how to hide these footer rows not at the end of the "CustomerType" series? Click the handle of the Group2 footer row to select the entire row, and locate its Hidden property under Visibility note in the Properties box, then type the following expression to hide the footers not at the end of each "CustomerType": =IIF(Runningvalue(Fields!CustomerType.Value,countdistinct,"Group1")=1,IIF(Count(Fields!CustomerType.Value,"Group2")=1000,true,false),false)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.