• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 52 views
  • Users 0 members are here
Related

SSRS and Hidden Columns

Beth Hawryluk
$organization

Hi everyone,

Hope you all had a nice holiday!

I'm very new to writing SSRS reports and there's something I've been having trouble with for one report I'm trying to build.

Essentially, the dataset pulls a TON of information that my development dept needs for pledge payment receipting. There's like a million columns in this thing. When it's exported to .csv they need all of this data but I was thinking it would be really nice to have a much more condensed version render within Tess that looks pretty and could be used for spot checking (with click throughs and all that jazz). Right now it's really ugly and unreadable simply so I can squeeze all of the columns onto the report.

I noticed that if I made a column hidden then it wouldn't export the data to .csv. It would only export the unhidden columns. So is there another way that I can hide data when it renders within Tess but have it all export as expected to .csv?

Thanks in advance for all of your wisdom!

Parents
  • Former Member
    Former Member $organization

    Hi Beth,

    One method to do this is to create a separate, hidden table on the report that contains all the fields you want to export. You set DataElementOutput to False for the table that's visible, and then your hidden table is what actually outputs when you save to CSV.

    This was covered briefly in one of the Advanced SSRS sessions in Dallas last year. Take a look in the presentation slides starting on page 23. Also, I think that if you open one of Tessitura's out-of-the-box SSRS reports in Visual Studio you can look and see this in action. They make the hidden table very small so you have to zoom in and/or expand the cells to actually see how it's set up.

    I did this with one of my reports and it seems to work, (we're still testing.) Hope that helps!

Reply
  • Former Member
    Former Member $organization

    Hi Beth,

    One method to do this is to create a separate, hidden table on the report that contains all the fields you want to export. You set DataElementOutput to False for the table that's visible, and then your hidden table is what actually outputs when you save to CSV.

    This was covered briefly in one of the Advanced SSRS sessions in Dallas last year. Take a look in the presentation slides starting on page 23. Also, I think that if you open one of Tessitura's out-of-the-box SSRS reports in Visual Studio you can look and see this in action. They make the hidden table very small so you have to zoom in and/or expand the cells to actually see how it's set up.

    I did this with one of my reports and it seems to work, (we're still testing.) Hope that helps!

Children
  • $organization in reply to Former Member

    Thanks Matthew and Travis!

    I had just started investigating Travis' suggestions when I got pulled away to do other work (isn't that always the way). So I haven't been able to look into this quite yet but I'm loving the suggestions (and the presentation!) and I'm excited to get this figured out. It's going to be such a pretty report when it's done. :)