How to fetch one row based on condition in SSRS

Question

0.00/5 (No votes)

See more:

Hi i had a requirement where i need to show the namecolumn of table EMP(has 10 rows) if col1 is greater than col 2, and have to display the names in a textbox with count of rows ,can i do that usning an expression in SSRS ,can someone please help me out thanks

Posted 6-Apr-11 6:28am

makwith9789

Updated 6-Apr-11 6:29am

v2

Add a Solution

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)

Sandeep Mewara · Accepted Answer · 2011-04-06T08:39:00

Solution 1

I guess so, Yes.

Your question/scenario is not too clear yet:
In the table data row, write an expression something like:

VB

=iif(Field!Col1.Value > Field!Col2.Value, "Some Text:" & Field!ColName.Value, "Some other value")

Posted 6-Apr-11 8:39am

Sandeep Mewara

Comments

makwith9789 6-Apr-11 15:06pm

like i have 3 column brokername,commission,fees what i need to do here is i have to take the name of broker who has max commission,and commission >fees i have to show that broker name in a textbox or in the table footer, is it possible to get it i am using a list here as i have aroud 80 rows and have t display 10 rows each page with a broker name details in the footer of all 8 pages let me know if u are not clear

Sandeep Mewara 6-Apr-11 15:23pm

It's really difficult to explain or do it here for you. I gave a sample way to do it. Try out.

You have added a new thing now: "Footer display" which would be a little complex but anything is doable as custom codes are allowed. I would suggest you to move stepwise.

P.S.: Next time, please do write full question.

Sandeep Mewara 6-Apr-11 15:24pm

And yes, for customcode thing: You can look at this article if needed:
http://www.codeproject.com/KB/reporting-services/SSRSReportLocalized.aspx