I created a report in SSRS that the customer exports to Excel. But once exported to excel there are extra rows added that are hidden. This causes problems when we try to print the report. Any ideas?
Please look into "globals!renderformat.name" to see if you could hide the hidden column from being sent to excel. Also please let me know the hidden column name?
There is no hidden columns in my report nor is there any hidden rows... I took a look at the "globals!renderformat.name" it stays EXCEL regardless of exporting it from CRM or the visual
studio IDE.. It is like EXCEL radomly just create the empty hidden rows.
I have row groups on my main report and a column group on my subreport. But they are necessary for my report to display data correctly... For some reason my images don't want to upload