May 29, 2009 at 1:55 pm
I am trying to make one drill through report work for many reports, however I need to hardcode a value in order for that to happen i.e.
Parameter Outcome
Parameter Value =1,2,3,4,5,6,11,14
Comma returns and error, OR returns no records at all... what is the appropriate way to wrie this?
Thanks!
May 29, 2009 at 2:18 pm
Can you provide the code/expression you are using? What is the data type of the parameter?
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
May 29, 2009 at 2:36 pm
Can you provide the code/expression you are using? What is the data type of the parameter?
The exact expressions I have tried are
=1,2,3,4,5
AND
=1 OR 2 OR 3 OR 5
The data type is varchar
Thsnks in Advance!
May 29, 2009 at 2:44 pm
Try wrapping the text in double-quotes.
="1,2,3,4,5"
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
May 29, 2009 at 2:58 pm
No luck... I am attaching a screenshot of exactly what I am looking at... this should return 14 rows of data, but the error message i get says
"No rows available for this combination of parameters"(sic)
maybe i am not communicating this correctly... doesn't seem like this would be so difficult but I simply have never had to do this before...
Okay - Addendum here.... tried
=23 or 18
And tried
= 23 and 18
it is returning all records for 18 or all records for 23 but not both - so clarification - this is a multi valued parameter, and befor eyou ask - yes i have double checked that i have it as a mv parameter in the report settings.....
Thanks again for your help!!!
May 29, 2009 at 4:54 pm
If the Values are hard-coded, cant they be set as the default in the drill down report?
May 30, 2009 at 8:39 am
Well, I am trying to make one report work for all of the reports that have identical data and format. I mean yes, I can hardcode the values into the dataset for the report, but then I need to create 10 reports. If I can get this field to accept a multivalue hard coded parameter, then this will work.
So, let me try asking this, does anyone have an example of how a multivalue parameter is passed within a URL? Maybe that will give me some idea of how to format this.....
Thanks in advance for your help!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply