How to Create the Multivalued parameter for only one specific condition?

I have report where i should create a report which is multivalued parametr report,but here my condition is i want to see only one county name  in my output that is Ex: Asia Specific (CountryName),I dnt want to see the other Country names,

So how should we create for this condition can you pleas help me out for this..

July 21st, 2015 10:47am

Can you explain  your requirement with a sample dataset .
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2015 11:19am

Hi,

Do you want to create two parameter, First for the region and then second should show countries according to that Region value?

please explain more details about your requirement step by step.

July 21st, 2015 1:28pm

I have single parameter selection where i have multi valued paramter selection ,There i need to see only one value that is Asia pasific for the selection while i preview the report at run time.

Ex: IND,USA,UK etc.... for multivlaued selection in the report paramter

Here i use multivalues slection but while prevewing the report i can only one value in the India,How it is possible.(For the multivalued paramter selection)

Thank you!

Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2015 2:49am

I have single parameter selection where i have multi valued paramter selection ,There i need to see only one value that is Asia pasific for the selection while i preview the report at run time.

Ex: IND,USA,UK etc.... for multivlaued selection in the report paramter

Here i use multivalues slection but while prevewing the report i can only one value in the India,How it is possible.(For the multivalued paramter selection)

Thank you!

I'm not sure exactly what you're looking for. It would seem you're asking why you only have a single value listed in the parameter when previewing. Is it possible that when you preview you use a different data source connection, so you are connecting to test instead of prod and therefore getting different data?

Here are a few examples of multivalued parameters:

http://www.sqlchick.com/entries/2012/2/25/displaying-single-multi-valued-report-parameter-selections-i.html

http://markvsql.com/2013/08/ssrs-cascading-multi-value-parameters/

https://www.mssqltips.com/sqlservertip/2866/sql-server-reporting-services-using-multivalue-parameters/

https://technet.microsoft.com/en-us/library/aa337396(v=sql.105).aspx

July 22nd, 2015 3:22am

Do you mean setting default value as single value inside multi valued parameter? If yes just set an expression to return only the required value in a dataset and then map it to parameter in default values tab in the parameter properties
Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2015 3:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics