Multi Select Parameters in SSRS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Multi Select Parameters in SSRS - SQL School...

Multi Select Parameters in SSRS - SQL School Video

Rate Topic

Display Mode

Topic Options

Author

Message

Brian Knight

Posted Monday, October 20, 2008 10:12 PM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

Comments posted to this topic are about the item Multi Select Parameters in SSRS - SQL School Video

Brian Knight
Free SQL Server Training Webinars

Post #588926

Anipaul

Posted Tuesday, October 21, 2008 1:37 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 1:35 AM
Points: 4,789, Visits: 1,336

Bah :)

Post #588984

Joe Pattison

Posted Tuesday, October 21, 2008 6:19 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, December 08, 2009 9:03 AM
Points: 336, Visits: 42

Brian,

Thanks these are a great help! Cool

Post #589092

Old SQL Newbie

Posted Tuesday, October 21, 2008 8:21 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, September 16, 2010 9:31 AM
Points: 62, Visits: 184

This was a nice presentation, however, I may not be alone in being locked into stored procedures as a data source. The consultant who assisted us in setting up the data warehouse was adamant that good practice was to never write a query directly in SSRS. When passing a multi-valued parameter string to a SP, one additional step is necessary to parse the query string. I am sure there are a number of satisfactory ways to handle this. I use a function call from the SP to parse the parm string to a table.

Post #589168

mishaluba

Posted Tuesday, October 21, 2008 12:04 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:54 PM
Points: 525, Visits: 617

Biran,

Thank you for sharing these videos with us. I have been really enjoying them. Sometimes it's hard to find the time to read a long article, but with a video I can see exactly how much time I will need and you manage to cram a lot of useful information in these few minutes. Keep up the good work! (btw, I own a few of your books too :) )

Post #589361

Thato

Posted Thursday, March 12, 2009 3:01 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:25 AM
Points: 162, Visits: 128

While the video might be useful, I agree that it's good practice and much cleaner to use stored procedures. If you can show me how to do multi select parameters with stored procedures, I'd be really impressed. I've been battling with this for a while now.

Post #674011

« Prev Topic | Next Topic »

Permissions