Trying to get one line on report to total 1 value

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Trying to get one line on report to total 1 value

Author

Topic

kdnichols
Posting Yak Master

232 Posts

Posted - 2006-12-21 : 08:49:31

Hello,

I have the following code:


="LSU Total for " & " " & ReportItems!txtLSUGroup.Value

I am trying to get this LSU total line to pass only one argument and print only the totals for that argument from the following code:


= UCASE(Switch( Parameters!SummaryBy3.Value = "Company", Fields!Company.Value,
Parameters!SummaryBy3.Value = "Business Channel", Fields!SGDescription.Value,
Parameters!SummaryBy3.Value="Division", Fields!BranchDivision.Value,
Parameters!SummaryBy3.Value="Region", Fields!BranchRegion.Value,
Parameters!SummaryBy3.Value = "Branch", Fields!Branch.Value,
Parameters!SummaryBy3.Value = "Loan Officer", Fields!LO.Value,
Parameters!SummaryBy3.Value = "State",Fields!State.Value,
Parameters!SummaryBy3.Value = "Report Group", Fields!BranchTranType.Value,
Parameters!SummaryBy3.Value = "Campaign", Fields!Campaign.Value, 
Parameters!SummaryBy3.Value = "Source Group", Fields!SourceGroupCode.Value,
Parameters!SummaryBy3.Value = "Lead Type", Fields!LeadTypeId.Value,
Parameters!SummaryBy3.Value = "Vendor", Fields!VendorId.Value = 7, 
Parameters!SummaryBy3.Value = "Date Received", Fields!DateReceived.Value))

I want the VendorId.Value to print only that total at the end of the report however, it keeps printing a company total from the following code:


=UCASE(Switch( Parameters!SummaryBy.Value = "Report Group", Fields!ReportGroupDesc.Value,
Parameters!SummaryBy.Value = "Source Group", Fields!SGDescription.Value, Parameters!SummaryBy.Value = "Lead Type", Fields!LeadTypeD.Value, 
Parameters!SummaryBy.Value = "Vendor", Fields!VendorId.Value, 
Parameters!SummaryBy.Value = "Campaign", Fields!Campaign.Value,
Parameters!SummaryBy.Value = "Company", Fields!Company.Value, 
Parameters!SummaryBy.Value = "Business Channel", Fields!BranchTranType.Value, Parameters!SummaryBy.Value = "Division", Fields!BranchDivision.Value , Parameters!SummaryBy.Value = "Region", Fields!BranchRegion.Value, Parameters!SummaryBy.Value = "Branch", Fields!Branch.Value & " " &"-" & " " & Fields!BranchName.Value , Parameters!SummaryBy.Value = "Satellite", Fields!BranchSatNew.Value & " " & "-" &  Fields!BranchName.Value , Parameters!SummaryBy.Value = "LO", Fields!LO.Value, Parameters!SummaryBy.Value = "State", Fields!SubjectAddrState.Value, 
Parameters!SummaryBy2.Value = "Report Group", Fields!ReportGroupDesc.Value, Parameters!SummaryBy2.Value = "Source Group", Fields!SGDescription.Value, Parameters!SummaryBy2.Value = "Lead Type", Fields!LeadTypeD.Value, 
Parameters!SummaryBy2.Value = "Vendor", Fields!VendorId.Value, 
Parameters!SummaryBy2.Value = "Campaign", Fields!Campaign.Value, 
Parameters!SummaryBy2.Value = "Business Channel", Fields!BranchTranType.Value, Parameters!SummaryBy2.Value = "Division", Fields!BranchDivision.Value, 
Parameters!SummaryBy2.Value = "Region", Fields!BranchRegion.Value, 
Parameters!SummaryBy2.Value = "Branch", Fields!Branch.Value & " " &"-" & " " & Fields!BranchName.Value, 
Parameters!SummaryBy2.Value = "Satellite", Fields!BranchSatNew.Value & " " &"-" & " " & Fields!BranchName.Value, 
Parameters!SummaryBy2.Value = "LO", Fields!LO.Value, 
Parameters!SummaryBy2.Value = "State", Fields!SubjectAddrState.Value, 
Parameters!SummaryBy2.Value = "SCF", Fields!SubjectSCF.Value & " " & "-" & " " & Fields!SubjectAddrState.Value, 
Parameters!SummaryBy2.Value = "Source Code", Fields!SourceCode.Value,
Parameters!SummaryBy3.Value = "Company", Fields!Company.Value, 
Parameters!SummaryBy3.Value = "Business Channel", Fields!SGDescription.Value, Parameters!SummaryBy3.Value = "Divsion", Fields!BranchDivision.Value, 
Parameters!SummaryBy3.Value = "Region", Fields!BranchRegion.Value, 
Parameters!SummaryBy3.Value = "Branch", Fields!Branch.Value, 
Parameters!SummaryBy3.Value = "Loan Officer", Fields!LoName.Value, 
Parameters!SummaryBy3.Value = "State", Fields!State.Value, 
Parameters!SummaryBy3.Value = "Report Group", Fields!ReportGroupDesc.Value, Parameters!SummaryBy3.Value = "Campaign", Fields!Campaign.Value,
Parameters!SummaryBy3.Value = "Source Group", Fields!SGDescription.Value, Parameters!SummaryBy3.Value = "Lead Type", Fields!LeadTypeD.Value,
Parameters!SummaryBy3.Value = "Vendor", Fields!VendorId.Value,
Parameters!SummaryBy3.Value="Date Received",Fields!DateReceived.Value))

TIA for any help in advance.

Have a Merry Christmas everyone!

Kurt

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-12-21 : 20:02:17

Your expression says it is getting its value from ReportItems!txtLSUGroup.Value, so look at the expression in the txtLSUGroup textbox. If you want something else then change ReportItems!txtLSUGroup.Value to refer to the correct textbox.

kdnichols
Posting Yak Master

232 Posts

Posted - 2006-12-22 : 09:07:58

Hello snSQL,

Please see my post above you were right I did away with that and I am now using a different route.

Please see my post above.

Kurt

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources