Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 SSRS 2008 Export to Excel RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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