Solved

MS ReportViewer ?

Posted on 2010-08-16
5
415 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
 
LVL 1

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

726 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