How we can use optional parameter in ssrs report?

(0) Share

Report

Posted on by Ak Negi

320

Hi , i am creating an ssrs report in which i am using multiple parameters and my need is if i am selecting nothing in a parameter the reports should run..but it's gives error .. error is The "ParameterName" parameter is missing value

*This post is locked for comments

All responses (4)

Answers (0)

Ak Negi 320 on at

Like (0)

Report

RE: How we can use optional parameter in ssrs report?

we have tried all these links still did not get any solution
Suggested answer

Abdul Wahab 12,070 Super User 2024 Season 1 on at

Like (0)

Report

RE: How we can use optional parameter in ssrs report?

Hi Arun,

Below might help you:

us.hitachi-solutions.com/.../optional-parameters-in-a-microsoft-dynamics-crm-fetch-report

social.microsoft.com/.../fetch-xml-report-how-to-use-optional-parameters

www.mssqltips.com/.../sql-server-reporting-services-reports-with-optional-query-parameters

docs.microsoft.com/.../report-parameters-report-builder-and-report-designer

If you need any anything more do let me know.

Thanks

Regards,

AW
Ak Negi 320 on at

Like (0)

Report

RE: How we can use optional parameter in ssrs report?

Can you please let me know for fetch based ssrs report.I have tried with following conditions in fetch:

<filter type="and">

<filter type="or">

<condition attribute="accountid" operator="eq" value="@Account" />

<condition attribute="accountid" operator="not-null" />

</filter>

</filter>

where "@Account" is name of parameter.
Abdul Wahab 12,070 Super User 2024 Season 1 on at

Like (0)

Report

RE: How we can use optional parameter in ssrs report?

Hi Aron,

I think below link might help you:

https://www.mssqltips.com/sqlservertip/3453/sql-server-reporting-services-reports-with-optional-query-parameters/

If you need any anything more do let me know.

Thanks

Regards,

AW