Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSRS export to CSV Hidden rows still appear

Posted on 2014-02-07
2
Medium Priority
?
673 Views
Last Modified: 2014-02-07
Within the row visibility I hide rows based on the following expresion:
=IIF(Round(Sum(Fields!prod_balance.Value*Fields!unit_conv.Value),3)=0.000,True,False)

Open in new window


In the export to CSV those rows are not hidden. How do I hide/suppress those rows in the CSV?
0
Comment
Question by:ButtonDownBobby
2 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 1000 total points
ID: 39842102
>How do I hide/suppress those rows in the CSV?
Last I remember this is not possible.  The csv will contain all data, regardless of whether the .rdl hides it in Preview Mode or not.
0
 

Author Comment

by:ButtonDownBobby
ID: 39842139
I guess we have to change to SQL Statement in the Dataset to remove them then...
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question