I have a running total (RunningValue) in one of the column, in my report. I want another running total of that existing running total. This is not allowed in SQL Reporting Services (Aggregate inside an aggregate function is not allowed).
How do I do that? Is it possible to use Visual Basic...using Code function? I'm not familiar with VB syntaxes. Would someone please help me with this... how to pass values to VB code... do the calculation... and display the answer in another column in the report.
Is there any other way of doing it (without using VB)?
Maybe this post will help you where I have suggested a solution using VB code with example code. Instead of sum that I have used in the code, use the multiplication operator.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1335024&SiteID=1
Shyam
No comments:
Post a Comment