SBX - Search With Button

SBX - Forum Post Title

SSRS Report does not show the parameters on uploading the .rdl file.

Microsoft Dynamics CRM Forum

Shweta Shukla asked a question on 13 Aug 2018 2:08 AM

Question Status

Suggested Answer

Hello everyone!

I have created an SSRS report in which I am seeking 2 parameters from the user; viz. CRM_FilteredFromDate and CRM_FilteredToDate.

 

First of all, the report ran perfectly fine on the Visual Studio (SSRS tool). However, on uploading the same .rdl file on CRM (online) instance, it threw an error saying "The expected parameter has not been supplied for the report."

The error shows up even before prompting for the "From Date" and "To Date".


I tried setting default values for both the parameters but the parameters have gone invisible on doing so. I cannot see the parameters the way I could see on my SSRS tool. (Please refer the screenshot shown below):

Any help would be appreciated.

Reply
Rawish Kumar responded on 13 Aug 2018 2:58 AM
My Badges
Suggested Answer

Hi Shweta,

Similar issue : community.dynamics.com/.../290579

Lets do below checks:

1.hope you are sys admin when running the report

2. if you have two data source make sure you keep CRM data source as the first one.

3. Check if all other reports are working fine.

Reply
Shweta Shukla responded on 13 Aug 2018 3:55 AM

Hi Rawish!

1. Yes, I am the system admin,

2. There is just 1 data source in my case,

3. Other reports are working fine.

Reply
Rawish Kumar responded on 13 Aug 2018 2:58 AM
My Badges
Suggested Answer

Hi Shweta,

Similar issue : community.dynamics.com/.../290579

Lets do below checks:

1.hope you are sys admin when running the report

2. if you have two data source make sure you keep CRM data source as the first one.

3. Check if all other reports are working fine.

Reply

SBX - Two Col Forum

SBX - Migrated JS