Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
summing value based on group ssrs
i think I need something like this... =iif(First(Fields!group.Value, "DataSet1") like Fields!group.Value, Sum(Fields!JAN.Value, "DataSet1"),0) but this returns no value...- k1ngTMO
- Post #2
- Forum: Microsoft SQL Server: Reporting Services
-
summing value based on group ssrs
I have two datasets where I pull date from for this report...dataset1 has sales by month and trans dataset has trans spend. I want to include sales in the location groupings but only sales for that location....right now it seems to sum up all the sales even though I put it inside the location...- k1ngTMO
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Reporting Services
