How to Show "NO ROWS" message When no rows in the table in RDLC

Question

0.00/5 (No votes)

See more:

Hi,

My table has following columns one is CPEType.Value.
Table row has an Expression in Visibility/Hidden =IIF(Fields!CPEType.Value = "C",False,TRUE )
so, It's showing Only rows which having CEType valu is "c".
Now,I Want to display "No Rows Found",when there's no data after above Condition.

is that in NoRows property is ok?

=iif(Count(Fields!CPEType.Value="E")= 0,"No Records" ,False)

Posted 27-Feb-11 21:53pm

Rajni from delhi

Updated 28-Feb-11 0:08am

v2

Add a Solution

Comments

Sandeep Mewara 28-Feb-11 10:42am

First of all, did you got the expression correctly, the one I suggested last time?

Rajni from delhi 28-Feb-11 22:54pm

i can't use that.i have to do this in .Rdlc desgin page.if table has data,then m showing only selected rows who's having Fields!CPEType.Value = "C" that i aplies to table row hidden property.now,i want to assign table No rows poperty in any expression,how can i do this ?

Rajni from delhi 1-Mar-11 0:05am

when m setting the property of table NoRows,it's also n't firing.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sairam.bhat · Answer 1 · 2011-02-28T00:46:00

Solution 1

please inform me which database you are using?.

if {bindingsource.count== 0)
{
messageBox("No rows");

}
you can use this if you are using ms access.

Posted 28-Feb-11 0:46am

sairam.bhat

Comments

Rajni from delhi 28-Feb-11 10:06am

Sql server is using.Can i assign String constant of "No Records Found" in the table NoRows property in any textbox Expression by Conditionally counting the No of rows of Fields!CPEType.Value = "C".

Sandeep Mewara 28-Feb-11 10:41am

Dude, OP is asking about SSRS. You are suggesting some C# code. :doh:

Please avoid answering topics that you are not aware of. It might just mis-guide OP.

sairam.bhat 1-Mar-11 1:43am

k sory yar i confused

Sandeep Mewara 1-Mar-11 1:51am

:) Ok.

Keep helping others!

Rajni from delhi 28-Feb-11 22:36pm

act.. when i wrote Report or RDLC ,IT's show me the error of revise tag.