Microsoft Dynamics AX (Archived)

Report name output as dynamic

(0) Share

Report

Posted on by Community Member

i am new to Dynamics AX 2012 , i need the report output name should have include parameter and report with timestampe.

its possible ,

thanks

kumar

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

Can you please rephrase your questions? It is very difficult to understand what you want. Maybe provide a design example as well?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hi Vilmos,

can you guide me how can i achieve my above query

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

when we try to save the report in excel / pdf format - the output name should have report+timestampe +any parameter used for selecting the query while generating the report.

for eg: parameter are item code , start date and end date , file name should show as "abc1 item detail as on 01022017 "

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Kumar Rao,

You are using DP class for your report or only using Query?

Which design your using for your report?

Thanks

Suresh

Was this reply helpful? Yes No
Martin Dráb 239,035 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Create a text box and set the expression as you need. SSRS will even offer you both parameters and common functions in GUI.

Parameters:

Functions:

Was this reply helpful? Yes No
Martin Dráb 239,035 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Ah, sorry, I've got what you mean. You want to set the file name from code, based on some variables. When you talk about parameters, do you mean values from data contracts?

My blog post Printing reports from code in AX2012 shows how set the file name from code, now you just have to construct the name you want.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

If you want to rename the file as per the information in your data contract, you have to hook in somehow to change the PrintJobSettings of the report controller after the SSRS dialog has been closed. Most likely you could try this by overriding dialogPostRun(), to construct your filename and dump it in the printjobsettings there.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

we are use DP class

Was this reply helpful? Yes No