Solved

MS ReportViewer ?

Posted on 2010-08-16
5
402 Views
Last Modified: 2013-11-27
In a vb.net app, I'm using MS ReportViewer localy to run reports. I design the reports in visual studio using it's template for RDLC.
The report prints tablular data, but each data row prints ove two lines.
The second line is used to print a comment, the rest fits on the first line.
How can I have it not print the second line where the comment field is empty?
0
Comment
Question by:Jess31
5 Comments
 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 33452137
use expression in the visibility property for the second line
i hope both the lines are in detail
so you check if any data is there, then make visible true or else false

0
 

Author Comment

by:Jess31
ID: 33454413
Where would I put the expression?
0
 
LVL 16

Accepted Solution

by:
13598 earned 500 total points
ID: 33454599

Select the second row, righ-click and choose Properties (make sure you select the row and not just the field).
In the properties tab expand the Visibility property, click by the Hidden property and select Expression. When the expression window opens enter your expression, for example:
=Fields!Comment.Value=""  
Instead of Comment you need to select your comment field.
0
 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 33455460
when you open the Expression, by default the value would be 'False", replace it
with below value
=IIf(fields!Colval = "",true,false)

if Colval is blank use the above expression, if not, then convert the null value to blank value and use this expression
0
 
LVL 27

Expert Comment

by:planocz
ID: 33460898
To make it simple you can  just put this in the expression
Visiblitity - Hide Box on the row you want to hide
=Trim(Fields!Comments.Value)=""
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

896 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now