question

SQLIsGood-7036 avatar image
0 Votes"
SQLIsGood-7036 asked DSPatrick answered

SSRS Preview Picks Wrong Column Items

Visual Studio 2017

Setup:

Parameter: COMPLEX

DataSource: 1

Datasets: Stored Procedure A, Stored Procedure B

Parameter picks the Apartment Complex Names from SP A, while SP B provides address info for rest of the report.

Problem: I choose the Apartment Complex Names in the PREVIEW, and next I click on View the Report button. The result is showing wrong apartment complex names,

the names that I did not choose. Any help would be appreciated.


Thanks.

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered Zoehui-MSFT commented

Hi @SQLIsGood-7036,

The issue is a little hard to narrow down.

Have you pass the value to the parameter?

Here is a blog about passing-multi-value-parameter-in-stored-procedure-ssrs-report for your reference.

Also recommend that you avoid using the sp_ prefix for naming stored procedures as this is a reserved prefix for system stored procedures.


Regards,
Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

What can I do if my transaction log is full?--- Hot issues November

How to convert Profiler trace into a SQL Server table -- Hot issues November


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

May I know how's the issue going on now?

0 Votes 0 ·
DSPatrick avatar image
0 Votes"
DSPatrick answered

I've seen that sort of behavior if the stored procs got edited after adding the datasets to report. I'd delete datasets from report, save, and then re-add them.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.