Multiple Dataset Fileds In SSRS Expressions

Question

0.00/5 (No votes)

See more:

How to set Multiple Dataset fields in SSRS reporting Expressions

here My Scenario,

Avg Handle Time My Column Name appears 2 times in my report

Where I need to Display 10 and 20 respective,y from dataset 1 and dataset 2 on my expressions i got the value 10 by this expression

C#

=IIF(Sum(Fields!AI_Average_Handle_Time.Value)=0,0.00,Sum(Fields!AI_Average_Handle_Time.Value))

but i am not getting the value 20.
Itried my Expression to fetch the value 20 but it was failed...and i don't know about the 3rd parameter which need to pass

C#

=Lookup(Fields!AI_Average_Handle_Time.Value,Fields!AI_Average_Handle_Time.Value,Fields!Employee_ID.Value, "DataSet2")

Any one pls find a solution...

Posted 21-Jul-14 7:51am

sahmed3

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)

nayeem@codeproject · Answer 1 · 2014-07-22T22:26:00

Solution 1

both the DataSets should be in same DataSource and use lookup to Fetch values

Posted 22-Jul-14 22:26pm

nayeem@codeproject

Comments

sahmed3 23-Jul-14 12:47pm

Hi Nayeem...I tried with LookUp function...not works...Could you provide me the LookUp function according to my requirement...

nayeem@codeproject 24-Jul-14 1:15am

hiii Do 10 and 20 are Employee Id ?

nayeem@codeproject 24-Jul-14 2:03am

and even change the dataset name

sahmed3 4-Aug-14 13:38pm

Sorry Nayeem for late response...As my manager had got another priority project for client which i putted hold for this one..

10 & 20 are the datafield values from dataset

nayeem@codeproject 24-Jul-14 2:06am

if both datasets are in same datasource change dataset name if u r using different data source leave if it wont work inform me

sahmed3 4-Aug-14 14:00pm

Yes,both data set are in the same data source but my i am trying to bind the column values which are common in both datasets..Which i am unable to do it
Ex: Dataset1->Columns->AvgTalkTime,AvgHoldTime
Dataset2->Columns->AvgTalkTime(WTD),AvgHoldTime(WTD)
I am getting the same values for both the columns..which should not come like that
If i am wrong somewhere pls guide it as i am a beginner in SSRS..