web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

SSRS Contract class optional parameter

(0) ShareShare
ReportReport
Posted on by 2,055

Hi,

I have develop a report with custom parameters. Which I need to optional, but system make it required. If the value for parameter is not given. Then its generating the error like "Parameter Project missing a value" etc.

How I can make it optional, so if the user can't enter the project, it should generate the report for all projects. Please help me to keep it optional.

Regards.

Nadeem Bhatti

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Dan Emreus Profile Picture
    1,162 on at

    I pressume this is a SSRS report.

    In Visual Studio expand the Parameters node set values "Allow Blank" and "Nullable" to True for your optional parameters. Than deploy your report again.

    /Dan

  • Nadeem Bhatti Profile Picture
    2,055 on at

    Hi DAN,

    Yes this is SSRS report as I have mention in title. But I do not find property with the name "Allow Blank". I attaching the screen shot. I am using VS 2010.

    I can see the following properties with any of the field type.

  • Suggested answer
    Dan Emreus Profile Picture
    1,162 on at

    You should not look under the datasource and parameters. Look at the Parameters presented after the Data Methods.

    /Dan

  • Nadeem Bhatti Profile Picture
    2,055 on at

    Hi Dan,

    I find the properties and set the values, but unfortunately still not working and its asking for parameter. Mean it again gives error that parameter value is missing.

    Regards

    Nadeem Bhatti

  • Suggested answer
    Dan Emreus Profile Picture
    1,162 on at

    Have you refreshed the data set in VS because I cannot see your new project parameter in the attached picture.

    /Dan

  • Suggested answer
    Dan Emreus Profile Picture
    1,162 on at
  • Suggested answer
    Kumar Gaurav @ MS Profile Picture
    on at

    In the Design mode from VS you can make a parameter optional, by default it is mandatory for every new parameter added

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans