[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

How to select all values of a HIDDEN multivalue parameter in SSRS 2005?

I need to modify an existing report where one of many multi-value parameters will be hidden. It is used extensively in the code (stored procedures and functions) and I need the report to use all values which storage procedure for this parameter returns. I understand that I can change all many components comprising report since I need to simply abandon that parameter. My goal is to avoid making all these changes and instead have Reporting Services put all values AS IF USER SELECTED THEM ALL. If it is possible, how to request such behavior?

Thank you

0
NaumLitvin
Asked:
NaumLitvin
  • 4
2 Solutions
 
EmesCommented:
would a variable work  or make  create a function that can simulate what you need?

The more difficult option is to open the code and then move it to an editor and do a serach and replace of the parameters that are needed to change.
Then copy and paste it back into SSS.  I have done this multiple times and it works nicely,
0
 
NaumLitvinAuthor Commented:
there is a stored procedure which used to present values to users to select some or all. Let's call it asp_machineID.
this sp returns a table with selected items: two columns: value itself and description. User can see description (label) and when selection is made, values (comma delimited) would be provided as parameter for the report - that all is normal. Let's call report's stored procedure asp_rep01.  

Now I hid that parameter because my users want always to have all values, returned by asp_machineID to be used for report - they do not want to make any selections. So I need somehow convert few records asp_machineID  is producing to a string of comma delimited values to be used as parameter for asp_rep01.

any idea how to do that?

thanks
0
 
NaumLitvinAuthor Commented:
I created SQL code to "convert few records asp_machineID  is producing to a string of comma delimited values to be used as parameter for asp_rep01".

If anybody is interested I can post the code.

Thank you, Emes, for your attempt to help.
0
 
NaumLitvinAuthor Commented:
Thank you, Emes, for your attempt to help.
0
 
NaumLitvinAuthor Commented:
Thank you, Emes, for your attempt to help.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now