Parameters in SSRS reports

(0) Share

Report

Posted on by D365 beginner

636

Hi Guys,

I have created a report with RDP & Contract classes with ItemGroupId as a parameter. when I run the report in visual studio the parameter which is Itemgroup is not a drop down list but if I type the item group manually in the field, the report works fine. Can someone give me a sample simple report or the setup to be done to have it as a drop down list in case of Itemgroupid.

Thanks in Advance

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI Ax beginner ,

If the look up is not coming because of relation then you can use UI builder lass and add customized look up to dialog field. Take a look at below link for examples.

community.dynamics.com/.../using-ui-builder-class-to-develop-ssrs-reports-in-microsoft-dynamics-ax-2012

Was this reply helpful? Yes No
D365 beginner 636 on at

Like (0)

Report
Copy link

Link copied!

Hi Sukrut,

Thanks for FYI,

I created UI Builder class for this report but still the lookup doesn't work.. Is there any chance this to happen in Visual studio only ? unfortunately there is no report sever configured in my Test environment to test it. I have checked some standard reports in VS and its same.

Was this reply helpful? Yes No
Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

There won't be any lookup in visual studio. Please check it on UI

Was this reply helpful? Yes No
Suggested answer

Amir Kaftari 210 on at

Like (0)

Report
Copy link

Link copied!

Hi Alex.

I think you must use ItemGroup as a parameter in Contract Calss for show drop down list.

Was this reply helpful? Yes No
Moeen Ahmed Sultan 1,402 on at

Like (0)

Report
Copy link

Link copied!

Hi, Can you share the parameter method of contract class?

Regards,

Moeen Ahmed

Was this reply helpful? Yes No