I've got a report that is a crosstab.
It has five lines that are a total. They work fine and display exactly as expected across the report for three years.
Under each of those five lines is a line that displays a percentage change from the previous year to the next. Three of those lines display correctly and exactly as they should, yet the last two (bottom two) lines of percentage change do not. I've checked everything, comparing them with the three percentage change lines that work and display properly. I've looked in properties, checked my logic, gone back to the query view...yet I cannot make these two bottom lines display.
Have ANY OF YOU seen this before? Thanks in advance...
R.J. Head
I guess nobody other than you has seen your report. Please share as much as details of the reports spec. to get help in a forum
The report looks as follows:
(http://i58.tinypic.com/8wcarc.jpg)
The rows that are not percentages display fine. The top three percentage rows display information fine.
The rows labeled % Change Military and % Change Graduate School do not display when I click the blue sideways triangle to test run the crosstab report from report studio. I have tried EVERYTHING to display those two rows. They are designed exactly like the three percentage rows above them (which display well), yet these bottom two do not display at all when the report is tested.
Thank you.
R.J. Head
Could possibly be something related to the aggregate settings?
Quote from: rjhead on 16 Jul 2014 03:41:43 PM
The report looks as follows:
(http://i58.tinypic.com/8wcarc.jpg)
The rows that are not percentages display fine. The top three percentage rows display information fine.
The rows labeled % Change Military and % Change Graduate School do not display when I click the blue sideways triangle to test run the crosstab report from report studio. I have tried EVERYTHING to display those two rows. They are designed exactly like the three percentage rows above them (which display well), yet these bottom two do not display at all when the report is tested.
Thank you.
R.J. Head
Hi,
Is the package you are using a dimensional or a relational package? Can you share with us how the percentage rows are defined? Are they query calculations? If so, what expressions are used? If not, how are they working? Seeing the layout is fine, but unless we know how you have defined the workings of the report it's rather difficult to suggest what might be wrong.
Best regards,
MF.