June 2, 2009 at 7:21 pm
I am new to reporting services. I need to have the option of 'ALL' in single-use parameter on my report. I've tried the union select 'ALL' but when I select 'ALL' from the drop down parameter, it does not return any records.
Also, would need to set 'ALL' as the default.
needs this really quick ! .... thanks for any suggestions.
bobbi
June 3, 2009 at 2:29 am
Hi.. 🙂
Regards,
As you have mentioned..you are able to get 'All' option in your Parameter dropdown.
Please let me knw, did you bind that 'All' to main query as;
Example:
Select * From ABC Where (ID = @ID) OR (@ID = 'All')..
Please include this in your main dataset query and this should reolve this issue.
Thanks alot,
Niraj 🙂
June 3, 2009 at 6:47 am
I created a dataset within RS for the parameter query and
used your where clause. In report parameters, for Available values, selected from query and selected the dataset for the parameter, defaultvalue none, allow blanks.
Also have a stored procedure where I am pulling the data from in sql2005 and entered the same where clause.
I am getting error of [rsInvalidReportParameterDependency]
The report parameter ‘VendorName’ has a DefaultValue or a ValidValue that depends on the report parameter “VendorName”. Forward dependencies are not valid.
When i run the parameter dataset, the where clause works fine. When i test it with report parameters, I am getting the above message.
Checked my sp and where clause is VendorName and @VendorName is the variable set.
bobbi.
June 4, 2009 at 7:02 am
This error msg sounds like one Ive seen before. SSRS sometimes is not the best at telling
you what's really wrong and in the right order.
But I digress...
If you have 2 parms, Parm A and Parm B...and Parm B depends on info from Parm A then in the
Parameters dialog setup Parm A must be listed first on the left pane.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply