CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2
RET
RET

Reputation: 871

Using SSRS reportitems to create percentage

I have two textboxes, part of a larger matrix, which calculate values based on summing lookups, with filter criteria.

I want to take the figures from each of them, divide one by the other and create a percentage, which will be used in a text string elsewhere in the report.

I can get the individual figures in the header for the relevant page (not ideal, should be in the body of the report) by referencing the report items in the matrix, however when I try to use both I get an error informing me of an apparently arbitrary restriction that 'An expression in a page header or footer can refer to only one report item'.

Attempting to do the calculation with report variables by passing the reportitems and then calculating gives the even less coherent error 'The Variable(blah) value expression used for the language of 'body' refers to a report item. Variable values cannot be used in report language expressions'.

Is there an easy way to do this without adding any extra cells to my original matrix? It seems like there is not much point having variables if you then have to add hidden textboxes in order to store your values.

Upvotes: 0

Views: 348

Answers (1)

SQLDev
SQLDev

Reputation: 65

try doing all your calculations in sql itself and refer the fields in SSRS. i faced a similar issue recently and this is how i did.

Else try using VB code to do the calculations.

Upvotes: 0

Related Questions