Is there a way to suppress repeating data in tsql; I used to work in Crystal and you would just suppress the field by simply checking it off.
Now we are converting reports to BIPublisher reports using the plugin not the full blown version(which you can suppress repeating columns) and you require the use of Xpath or variables.
I believe if I could do it from the backend batch program using a sql script and then export to xml file. I don't have to make the display portion - Bipublisher contain a ton of if statements.
Attached is the report
So in the attached report the course PRAC 1216 has 2 rows but all the columns on the second row repeat and we want them to suppress.
The table behind the scene is a view with the following fields:
The 3 fields ,[ACAD_PLAN]
The report is grouped by CRSE_ATTR_VALUE, course_descr, class_section.
The question here is 1. Can you do the suppression of the columns?
Thanks, in advance Brock.