locked
CRM 2011 SSRS 2008 Export to Excel RRS feed

  • Question

  • Hi

    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?

    Tuesday, September 2, 2014 3:27 PM

All replies

  • Hello,

     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?

    Regards,

    Jithesh

    Wednesday, September 3, 2014 2:35 AM
  • 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.
    Wednesday, September 3, 2014 6:57 AM
  • Can you please post a picture of this hidden row?

    Row and column groups can create hidden rows, please check that also.

    Regards,

    Jithesh

    Wednesday, September 3, 2014 7:13 AM
  • 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
    Wednesday, September 3, 2014 7:30 AM