Home Dashboard Directory Help
Search

RDL reports created for SQL Server 2008 Reporting Services are incorrectly converted to 2012 format by M. R. - Canada


Status: 

Resolved
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 768106
Opened: 10/19/2012 12:19:24 PM
Access Restriction: Public
1
Workaround(s)
view
0
User(s) can reproduce this bug

Description

I have a reporting project designed with SQL Server 2008 Business Intelligence Studio that has a few RDL reports.
I loaded this project into Visual Studio 2012 that installs together with SQL Server 2012 Enterprise. All reports were then converted into 2012 format, I got no errors. In VS 2012 everything seems to work fine.
I deployed the reports on ReportServer (native mode) and used Report Viewer 2012 ver.
11.0.2802.11 (latest as of today) to run the reports.

But... the conversion was NOT done correctly: if the report has a multi-value parameter, then choosing different multi-value combinations from the parameter drop-down box and next clicking the 'View Report' button, will NOT refresh the report! I just get a blank page.
The report refreshes however if I click the 'View Report' button for a second time.

I had to manually re-create the reports from scratch in order to get rid of this bug. It is obviously a conversion problem, please investigate.

NOTE: added on 10/22/2012 - this issue seems to happen consistently if the multi-value parameter is the very first in the Parameters list, if I move it down a position (to be the second in the Parameters list), the report works correctly!
Details
Sign in to post a comment.
Posted by Microsoft on 11/18/2013 at 4:06 PM
Thanks again for your feedback. If this does not resolve your issue, and the issue is a critical business interruption, please call Customer Support Services.

Thanks,
Matt Jones
SSRS Tiger Dev
Posted by Microsoft on 10/22/2013 at 10:49 AM
Thanks for finding this issue. Are you able to reproduce this issue with the latest runtime?

http://www.microsoft.com/en-us/download/details.aspx?id=35747

Thanks,
Matt Jones
SSRS Tiger Dev
Sign in to post a workaround.
Posted by M. R. - Canada on 10/22/2012 at 12:04 PM
Move the multi-value parameter to a lower position in the Parameters list (it only applies if you have at least two report parameters and the first one has unique values)....