SQLServerCentral / Discuss Content Posted by Adriaan Davel / Article Discussions / Article Discussions by Author

SSRS Parameter

vax09 — Tue, 17 Jan 2012 12:02:07 GMT

I have a parameter in SSRS in which it has multiple values in it. if I try to select all the values from the parameter then values got selected but report does not work.so what is the max size of parameter we can selected. I have atleast 200-300 of parameter values in it. please help me how.

Multi-Select Parameters for Reporting Services

Adriaan Davel — Tue, 31 Jul 2007 12:01:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/ADavel/3138.asp

Multi Value parameter does not persist in the textbox when "Select All" option in selected for the param

veen_computers — Wed, 09 Sep 2009 00:42:29 GMT

[font="Arial"]Hi, i have 1 multi value parameter 'State'. This parameter depends on the previous parameters 'Continent' and 'Country'.For Suppose we select parameters :- Continent: 'Asia' (populating this from a dataset)Country: 'India' (populating this from a dataset)State(Multi value parameter): "a, b, c" (populating this from a dataset)The State Parameter does not persist. On selection of "Select All" option a postback occurs and it clears off. The selected values are not shown in the textbox.Please help!!! its urgent[/font]

Using Multi Valued Parameter in MDX RS

sipho.nombebe — Tue, 10 Jun 2008 01:39:02 GMT

Hi,I have a report where usesr can select Multi valued Parameter and I use a join in my mdx code like this:="SELECT NON EMPTY { [Measures].[Alternate Single Manager], [Measures].[Retail Structured]} ON COLUMNS, NON EMPTY { ([Agent].[Agent Consultant].[Consultant Id].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( " & Parameters!FundFund.Value & ") ON COLUMNS FROM ( SELECT ( " & Join(Parameters!TransactionTypeTransactionTypeHierarchy.Value,",") & ") ON COLUMNS FROM [Cube])))) WHERE ( " & Join(Parameters!TransactionTypeTransactionTypeHierarchy.Value,",") & "," & Parameters!FundFund.Value & ") CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS"If the user select Multi Valued Parameter, the query returns an error : The 'Transaction Type Hierarchy' hierarchy appears more than once in the tuple.The mdx code that gets build looks like this:SELECT NON EMPTY { [Measures].[Alternate Single Manager], [Measures].[Retail Structured] } ON COLUMNS, NON EMPTY { ([Agent].[Agent Consultant].[Consultant Id].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( [Fund].[Fund].[All]) ON COLUMNS FROM ( SELECT ( [Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1732],[Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1733]) ON COLUMNS FROM [Cube]))) WHERE ( [Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1732],[Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1733]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSPlease help on thisSipho

Passing Multivalue Parameter

peer_mohamed2k — Tue, 06 Nov 2007 21:54:03 GMT

How to pass Multivalue parameter in Reporting Services.In my Report DataSet, I am using statement like this. Exec SalesReport @SalesTerritory, @ProductName, @StartDate, @EndDate Here @SalesTerritoy and @ProductName are Multivalue parameters. And I am Selecting more than one value for the paramenters from the drop down. In sql Procedure I am splitting the comma separated values and putting to temp table. Thnx in Advance.