Answered

SSRS report parameters duplicating

(0) Share

Report

Posted on by Community Member

Hi All,

I have developed a new SSRS report that works well but at the last minute I changed the labels that show in the dialog box for the parameters. Now I can't get rid of the old descriptions and both the new labels and old labels still appear.

I deleted the duplicates from the VS report editor Parameter area and if I look/run the report from VS the paramters only appear once but if I run it from AX I have them twice in the dialog box.

I have tried Clean the report, rebuild and deploy from within VS with no difference. I then did Tools-> Cache -> the data dictionery cache and the report server cache refresh the deploy from AX and no difference. The CIL says it is done. I then restarted the AOS and redeployed the report and still can't get rid of the original parameter duplicates.

Any ideas would be appreciated.

Thanks

Paulina

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

JII SAADUDDIN 1,832 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Paulina, Do you have exported backup of your report file? Duplicates parameters is maybe difficult to find the location especially if I'm beginner or starter on customization.

Import if you have the exported file.

Just an advice. backup first before editing anything else or use Export it if specific objects.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Paulina,

You can also restore the report in AX and deploy the report. Parameters are little bit hard to refresh sometimes. Try all the necessary step you can, if there is no result. Final step is to duplicate the contract class and delete existing the contract class, change all the contract names in respective places and deploy the report.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Paulina,

Please look into the below thread, it will solve your problem:

community.dynamics.com/.../273223

Regards

Was this reply helpful? Yes No
Gautam 3,945 on at

Like
a
(0)

Report
Copy link

Link copied!

hi Paulina,

delete report from http://localhost/Reports
refresh report server , delete cache for the your current user, reploy report .

Thanks
Gautam

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Solved my problem - you don't need to delete or restore the complete report. In Visual studio the parameters are shown on each dataset. You need to delete the paramters on each dataset - even if the parameter is not related to that dataset. Refreshing/restoring etc from AX does not change these so you need to do it in VS. Then Build / deploy and make sure you update the AOT.

Paulina

Was this reply helpful? Yes No