Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Parameter is not showing in Dataset

Posted on by 38
I created a parameter for an already working report, created an EDT modified it in the Contract Class extension and  added it to the dp class extension with the necessary changes, it is showing on the dialog you can assign a date, it doesn't work, and in the dataset the parameter i created is not found.
I tried:
- sync with databse
- full build
- create a new project 
- create a new EDT add a new parameter that i don't need just for testing
all of this is not working, any help would be appreciated!
Thanks in advance!
  • Layan Jwei Profile Picture
    Layan Jwei 7,320 Super User 2024 Season 2 on at
    Parameter is not showing in Dataset
    Hi,
     
    If you open your report in visual studio and go to "Parameters" node, do you see your new parameter?
    Maybe you need to refresh your dataset
     
    This article explains how to add parameters wether they are linked to a query or linked to a contract class
     
     
    Also try restarting the reporting service
     
    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
  • Suggested answer
    CU02111518-0 Profile Picture
    CU02111518-0 4 on at
    Parameter is not showing in Dataset

    I was having the same issue when trying to create a parameter for an already working report. I created an EDT, modified it in the Contract Class extension, and added it to the data project class extension, but it still didn’t work. Here are a few steps that helped me resolve similar issues:

    1. Check the Parameter Binding: Ensure that the parameter is correctly bound to the dataset, as sometimes it may not reference properly.

    2. Data Source Configuration: Verify that the data source includes the new parameter. Double-check the dataset properties to confirm it’s properly referenced.

    3. Dialog Properties: Make sure the dialog properties for the parameter are set correctly. Visibility or required field settings can impact its appearance in the dataset.

    4. Rebuild and Deploy: After any changes, perform a clean rebuild of the project and ensure that you're deploying the latest version of the report.

    5. Check Event Handlers: If there are event handlers for the parameter, confirm they are functioning as expected.

    6. Debugging: If possible, debug the report execution to identify any errors related to the parameter.

  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 6,205 Super User 2024 Season 2 on at
    Parameter is not showing in Dataset
    Hi,
     
    Are you working on Custom report? Did you try to restore the dataset on the report? Did you deploy your report? Was it successfully deployed? Sometime when you add new parameter to already exists report an issue is happening in the rows and columns of the parameters in the report (Usually you get cell definition error) when deploying the report, to resolve the issue you should right click on the report to open it in XML and search for Cell definition, check the following link in order to fix the issue:
    https://daxonline.org/1708-the-number-of-defined-parameters-is-not-equal-to-the-number-of-cell-definitions-in-the-parameter-panel.html
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
     

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans