[SSRS] Report Parameter Forgets Multi Value Option on Main Data Set modification and Refresh by alphaprolix

Active

Type:	Bug
ID:	777034
Opened:	1/21/2013 2:03:40 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

We are developing SSRS reports using development tools for Dynamics AX 2012, we have several parameters in report, it is noticed that when we change our main dataset's Stored Proc from database (external datasource\storedprocedure) which causes dataset's parameter changes, then we refresh dataset in visual studio, SOME of report parameters resets their Multivalue option to False, while they were set to true. Reference:

http://stackoverflow.com/questions/14434575/strange-behavior-of-ssrs-report-parameters

Details (expand)

English

SQL Server 2008 R2 SP1

Reporting Services

Windows 7 Enterprise (SP1)

US English

Create a report model from ax dev tools (.dynamicsproj), add some datasets with setting:

data Source = external:
data Source type = stored Procedure
dynamic filters = false
query = db proc name

create some report parameters and assign values from datasets, set multi value to ture(save before setting multi value to true or try to Preview at least once before setting this option), then change proc parameters in db, then refresh the dataset in studio, you will find multi value revert back to false.