Solved

SSRS export to CSV Hidden rows still appear

Posted on 2014-02-07
2
551 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 65

Accepted Solution

by:
Jim Horn earned 500 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL date incremented 11 31
Return 0 on SQL count 24 30
Sql server get data from a usp to use in a usp 5 16
SQL Query assistance 16 27
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

809 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