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!
Just some ideas.
I have not tried this, but it should work (i think). Set the column to hidden. Then set the "DataElementOuput" property to "Yes" in the properties pane. If that doesn't work...you could just add a preview like parameter that turns on and off visibility. You can have your cleaned up view for spot checking and your expanded view for exporting. Or try playing around with your groupings and setup some expand or collapse for rows and columns.
Travis