Microsoft Dynamics AX (Archived)

Automatic fill Journal batch number in SSRS Report

(0) Share

Report

Posted on by XSpy

209

I have a made a Query Type SSRS Report of a customized Journal Voucher.

I have no problem with the output and i already deployed it in AX.

But when I run the Report, I have to fill-up the Parameter (Journal batch number),

I would like to ask if there is a way to automatically fill-up the Journal batch number, upon clicking a General Journal Record. (because the sample Journal Voucher in AX is working that way).

Please help me, Thanks.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

André Arnaud de Cal... 301,030 Super User 2025 Season 2 on at

Like (0)

Report

Hi XSpy,

This is possible by adding some coding. You can have a look at the sample journal voucher you are referring to. If you need additional help, please specify if you need to have this value in a dialog field or as query range.

Was this reply helpful? Yes No
XSpy 209 on at

Like (0)

Report

Hi André,

Apparently, i am using a Query Dataset, not a RDP,

if there is a way, please help me,

I also used a Query Range, but I only manage to make a Dropdown Field (of the Parameter)

as I said earlier, I need a Parameter that auto-fill the Selected Data (Journal Voucher) in my Report, so there will be no need to Input or Select in the Report's Parameters.

Please help me, Thanks.

Was this reply helpful? Yes No
Verified answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

Hi XSpy,

As far I know this is not possible using Query as a datasource, you can easily do this through a contract class using RDP as your report datasource.

Was this reply helpful? Yes No
XSpy 209 on at

Like (0)

Report

I have made a RDP class now and its working.

Can you help me in making my parameter automatically filled?

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

you need to create a controller class which will take parameters and will open report against passed voucher number

for your inspiration, here you go

abdulghani121.blogspot.com/.../controller-class-for-current-record.html

community.dynamics.com/.../using-controller-class-in-developing-ssrs-reports-in-microsoft-dynamics-ax-2012

Was this reply helpful? Yes No