**SLSO is a self-hosted organization**
I am creating a custom report for my coworkers and I need the report to be hidden on screen, but data to be shown on export option. I know this is possible because my predecessor had this set up on some existing custom reports, however I am struggling to make it happen on my new custom report. We are using SSRS 2014. In the report that my predecessor created, he has the Tablix body visibility property set to hidden:
And in that report for some reason the body is pink, but no fill color is set. I wonder if that coloring indicates some setting somewhere that I cannot find:
For his report, when you run it in Tess, the body is hidden but the user can export the date to CSV:
When I mimic these setting my my new report, nothing exports except a single cell with symbols in it. So I tried unhiding the Tablix body in my new report and the data exported just fine. What am I missing here? Is there a setting in the report my predecessor create that I am unaware of and therefore missing my new report?
I checked all the column visibility settings and they all say "show":
Does anyone know how to make this work?
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
More Fields Available on Export
I cannot figure out how to hide SOME fields on screen, yet have them export to CSV. Every time I try the solution I found above, the whole tablix becomes hidden.
Can anyone help?
Hi Ashley. Here you go let me know if this works for you but it should.
satishmsbiworld.blogspot.com/.../how-to-hide-column-in-export-data-from.html
This expression worked:
=IIF(Globals!RenderFormat.Name = "EXCEL", False, True)
Thank you! I had been replacing the "EXCEL" with "CSV" and that doesn't work, although it is supposed to work.
Ashley