How to get the Label Field from a parameter

Question

How to get the Label Field from a parameter

EITCL

SSCrazy

Points: 2301
More actions
September 23, 2010 at 10:44 am

#238763

Hello,
I have a report parameter defined like this:
Available Values: "Get values from a query" using a dataset called "ClientList". This dataset contains the query "SELECT ClientId, ClientName FROM tClient".
The parameter's Value field is set to "ClientId" and the Label Field is set to ClientName.
This allows me to see a list of client names, and I can use the @ClientId parameter in my report.
But I also need the ClientName of the selected client to display on the report. How do I obtain this?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

I am not sure I understand your question. What do you want to see on the report, and where on the report do you want to see it?

EITCL SSCrazy Points: 2301 More actions · Answer 2

One the user has selected a client, the @Client parameter is populated with the value of ClientID from the query. I can then use the @Client parameter variable in the query for the report's Dataset to retrieve data for just that client.

What I want to do is display the ClientName in the report header. But the parameter only seems to make the ClientId available.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 3

Add another parameter, make it hidden, and associate the company name with it. Then add that parameter to the header as you did with the client id.

EITCL SSCrazy Points: 2301 More actions · Answer 4

That could work. How do I do the "associate the company name with it" bit?

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 5

Give your parameter a default value based on the query that gives the company name.

Niraj-627298 Hall of Fame Points: 3641 More actions · Answer 6

Hi,

I tried this with a scenario...(Hope..I am not missing anything here..but do let me know..if my understanding is not correct :)...)

-- Created a dataset1 (for parameter) with query 'select empid, empname from employee'

-- Created a MAIN dataset2 (for report) with query 'select empname, empaddress, sal where empid = @empid'

-- Now, used dataset1 to fetch values for parameter...with ''Available values'' set to 'Get values from query'..with Value Field as 'empId' and Label field as 'empName'.

-- Now, to display the selected parameter's label field on the report header, I need to use simple expression -- 'Parameters!empId.Label'.

-- It displays the correct empname as per the selected empid.

I think, this should help.. 🙂

Thanks,

Niraj

EITCL SSCrazy Points: 2301 More actions · Answer 7

EITCL

SSCrazy

Points: 2301

October 5, 2010 at 10:14 am

#1231873

Yes, that'll do it. Thanks!