Hey guys,
So I'm dealing with an issue I hope you can help with, basically my issue is that I have a Query Subject called Event.
Event has 0..1 with Log Pages which is 1..1 with Event, so Event holds a series of Log Pages that describe that event.
Each Log Page is a discrepancy and comes with a Description of what occured.
I am having an issue in Report Studio where if I drag the Event: Event Number and then drag Log Pages, each Discrepancy has ALL of the Descriptions attached making the report waaaay big and way wrong.
I should get:
Event - LogPage1 - Description for LogPage1
Event - LogPage2 - Description for LogPage2
Event - LogPage3 - Description for LogPage3
.
.
.
Event - LogPageN - Description for LogPageN
BUT I'm getting:
Event - LogPage1 - Description for LogPage1
Event - LogPage1 - Description for LogPage2
Event - LogPage1 - Description for LogPage3
.
.
.
Event - LogPageN - Description for LogPage1
.
.
.
Event - LogPageN- Description for LogPageN
I would have posted in 'Framework Manager' but I'm not sure it fits there because if I remove the Description (which is an nvarchar(255)) I get everything else for the Log Page fine (date, type, etc.)
I'm wondering why it's not liking the text, I have had this occure for 'text blob' and 'nvarchar' datatypes so I'm not sure how I should go about fixing this,
Anything would help at this point, thank you!
Hello cognoshelp01,
Can you please check what is the property "Auto group and summarize" set for your query. It should be set to YES,
Also, if you could extract the SQL from the query and post it here, will be helpful.
-Cognos810
the problem was that "auto group and summarize" was set to 'yes' I changed it to no and I'm guessing that caused unnecessary joining. thank you!