how to show description and deccription

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » how to show description and deccription_id

how to show description and deccription_id

Rate Topic

Display Mode

Topic Options

Author

Message

Arjun123

Posted Wednesday, February 06, 2013 2:31 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:20 AM
Points: 19, Visits: 175

Hi,

I have two columns Id,id_desc
i am creating a report using procedure,in SP i am calling id only
while i creating a report in SSRS,i want show description only
based on description the id send to SP and get the result

Regards
Arjun

Post #1416336

anthony.green

Posted Wednesday, February 06, 2013 2:44 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

create a parameter, assign the available values section the query, assign the right columns to the right drop downs, then use the parameter in the stored proc.

So two datasets, one which gets all ID's and descriptions, one which uses the proc and passes in the parameter.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1416345

« Prev Topic | Next Topic »

Permissions