Finance | Project Operations, Human Resources, ...

Parameter is not showing in Dataset

(1) Share

Report

Posted on by AB-24101041-0

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!

All responses (3)

Answers (0)

Layan Jwei 7,349 Super User 2024 Season 2 on at

Like (1)

Report

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

https://ax.docentric.com/add-a-new-parameter-to-ssrs-reports-in-dynamics-365-for-finance-and-operations/

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 4 on at

Like (0)

Report
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:

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

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

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.

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.

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

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

Waed Ayyad 6,408 Super User 2024 Season 2 on at

Like (0)

Report

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

https://fernitudela.dev/2023/01/22/d365fo-ssrs-report-parameters-cell-definitions-error/

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue