SSRS Report allow parameters to be null

(0) Share

Report

Posted on by skd

390

Hey Team,

I have a condition in my ssrs report that if the "Customer code" parameter id blank and ReportLevel =" Customer" then return all customer projects under the selected Business Unit and Profit center.

I have written the code for the same but when I try to leave it blank it gives me an error saying "A valid value for parameter "ProjectEstimateMain_Customer_Code" does not exist. I want to have an option to keep that parameter blank and when blank execute my code. How can I achieve this?

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Dynamics Community 101 310 on at

Like (0)

Report

Hi SKD,

Go to report design and in the parameters look for your parameter, in the properties set Nullable "True"

Regards,

Atul Yadav

dynamicscommunity101.blogspot.com

Was this reply helpful? Yes No
Verified answer

julia146 on at

Like (0)

Report

Find the report parameter, Properties - Allow Blank: True, Nullable: True.

Was this reply helpful? Yes No
skd 390 on at

Like (0)

Report

HEy Atul yadav,

Thank you!!!

Was this reply helpful? Yes No
skd 390 on at

Like (0)

Report

HEy Julia Chen,

Thank you!!!

Was this reply helpful? Yes No