January 9, 2012 at 1:05 pm
pl;'ol';/l
January 9, 2012 at 2:05 pm
I must be missing something. Passing parameters from SSRS to SQL procedures is usually very, very simple. You define them in the query.
As for multi-value parameters, I like using table-value-parameters for those, if you're on SQL 2008. No need to parse out a string in the proc if you do that.
So I must be misreading something, because what I'm reading seems to say that you can't figure out how to pass a parameter from a report to a stored procedure.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 9, 2012 at 2:41 pm
Ok here is a very simple question. I have a multi select parameter, where I'm setting the Label = (company + '-' + companyid)
so a concatenated Label, I have created in the same query a Value of companyid field.
How can I make the Value parameter hidden and pass the array(?) to my stored procedure?
Is that clear enough?
January 9, 2012 at 2:46 pm
do you think the words "concatenate" or "multi select" are too hard for people to understand?
January 9, 2012 at 2:50 pm
or maybe I need to define how sql databases use a "query" to get data, or maybe define what a stored procedure is?
just how simple do my statements need to be to get some help? Do I need to go back to how computers were built or how they work?
January 9, 2012 at 2:58 pm
oh and while we are at it, what is a "table-value-parameter" because that is a new term, that I don't see in any setting in ssrs
January 10, 2012 at 7:25 am
DeanORenO (1/9/2012)
do you think the words "concatenate" or "multi select" are too hard for people to understand?
I was going to try to help you, but if you're just going to be insulting, I'll take my time elsewhere.
Best of luck to you.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 10, 2012 at 7:43 am
p[
'kl[pl
January 12, 2012 at 7:45 am
DeanORenO (1/9/2012)
pl;'ol';/l
Wow, I looked at this because I thought I might be able to help, but I can't because you apparently edited the post into nonsense. Plus you insulted someone who tried to help you. Still I'll try to help.
Your second question really isn't clear. The Value property of a parameter is never displayed to the user in reporting services. Here are some articles that might help you understand multi-value parameters:
http://msdn.microsoft.com/en-us/library/aa337396.aspx
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/ssrs_multi_value_parameters
http://msdn.microsoft.com/en-us/library/aa337292.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply