You can add an additional field to be displayed by your stored procedure which does the calculation then add this field to the table as an ordinary column.
The "over partition" function should help you here.
e.g in proc:
Select state, ((Sum(age)/(Sum(age)))* 100000) over (partition by state) as...
I have a dataset in Reporting Services 2005 which has fields from two cube dimensions.The first dimension has summary data and is displayed in a table- e.g Company Number, total sales, etc.
The second dimension has info across time periods - e.g. Company Number, weekly sales, weekNumber. I want...
I'm looking at the proc, but are there any other possibilities I can look into, such as editing the report xml / code-behind etc? Or some kind of cheat like placing additional textboxes with 'A','B' or 'C' and hiding/showing if =Fields!type.Value doesn't have 'A','B' or 'C', or using new...
in Reporting Services - Is it possible to add extra rows in a Matrix containing blank data?
The row group is filled from a dataset (which is filled by stored proc). e.g the row group expression is: =Fields!type.Value
My problem is the Type can be 'A','B' or 'C' in any combination eg. some rows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.