Thanks blom0344, your suggestion got me thinking along the right lines and although I couldn't initially get the query to work with individual rows defined, after a bit of messing about it worked perfectly!
I tried to do this, there are 2 issues: 1) every row I define has the row with the row name as defined and fact data, and then a null row name with more fact data. 2) when I create the calculated row and insert into the crosstab and run the report I get the error "The context for the arithmetic...
Hello, I’m hoping to be able to get some help with calculated fields in Report Studio 8.4.
Basically I need to write some crosstab reports showing profit & loss categories (eg Income, Staff Costs, Expenditure etc) as rows, and departments as schools. I then also need to have various calculated...
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.