Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

strange behavior while exporting SSRS report to CSV Expand / Collapse
Author
Message
Posted Tuesday, August 13, 2013 5:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 10:32 PM
Points: 21, Visits: 167
I have a report with Parameter filter on top , design view has two tablix H1 and H2 when I run the report
I chose the parameter H1 or H2 and based on my selection report return data showing tablix H1 or tablix H2. after the report is rendered I export the report csv but regardless of what report I ran H1 or H2 it will always export H1 tablix to csv. see attached screen shot for report preview

Thanks


  Post Attachments 
ssrsissue.png (5 views, 95.67 KB)
Post #1484034
Posted Wednesday, August 14, 2013 6:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:28 AM
Points: 12,208, Visits: 9,174
A lot of functionality of SSRS is ignored when exported to CSV.
Exporting to a CSV File

How did you implement the switch between the two tablixes? The interactivity section in the mentioned article says show/hide is ignored.

Maybe you can try an implementation with subreports?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1484236
Posted Friday, August 16, 2013 4:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 10:32 PM
Points: 21, Visits: 167
I have a Parameter which has two Values H1 and H2 and then in tablix properties visibility section I have choose show and hide based on expression and set up this based on Tablix =Parameters!H1.Value = "H1"
Post #1485416
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse