Trying to pull into a TextBox on a report a Total Sum of pages for an organization, single database but multiple Datasets in a report. This iif statement will run but sums all pages into one total for all Months need it to just get the Month in the statement
for example 10th month and instead it is getting Month 1, 2, 3 etc. I have tried to add in DataSet2 after the xMonthCreated Value as this is contained in both datasets but it gives another error.
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
GeneSecure
0 Points
2 Posts
Getting the wrong Summed values on a MultipleDataset
Nov 14, 2012 08:08 PM|LINK
Trying to pull into a TextBox on a report a Total Sum of pages for an organization, single database but multiple Datasets in a report. This iif statement will run but sums all pages into one total for all Months need it to just get the Month in the statement for example 10th month and instead it is getting Month 1, 2, 3 etc. I have tried to add in DataSet2 after the xMonthCreated Value as this is contained in both datasets but it gives another error.
=IIf(Fields!XMONTHCREATED.Value=10,Sum(Fields!TOTALPAGESIN.Value, "DataSet2"),Nothing)
Any help would be appreciated, fairly new to using SSRS R3 2008. Thanks in advance.
Inserting the value into just a flat table cell.
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: Getting the wrong Summed values on a MultipleDataset
Nov 19, 2012 04:51 AM|LINK
try below code:
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS