web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Printing Dynamics report parameter ranges on my SSRS report

(0) ShareShare
ReportReport
Posted on by

Hi All,

I have a query on how to print Report's Dynamic Parameters on your SSRS reports. 

In then below screen shot of my parameter form, I would like to print the Date "2018-05-01".."2018-06-07" when my SSRS report generates. 

params.png

How can I achieve this? I tried following blogpost http://dev.goshoom.net/en/2014/09/showing-dynamic-parameters/

Should I create tmpSysQuery variable and select the tmpSysQuery in my RDP class?

Looks like I have to create TmpSysQuery.rangesToTable method, should this be created as a totally new class?

A line tmpSysQuery = MyQueryUtils::rangesToTable(this.parmQuery()); is added in the process report class, should this be added in my process report class?

A Statement is mentioned in blog "add a new data set in our report and show query ranges in a tablix in exactly the same way" Should I create a new dataset in SSRS reports? Which RDP or Query should I attach? Since already my RDP class is attached, what should I attach for the new dataset? 

Will be helpful if someone can brief me on the process of achieving this, as I feel I am missing something in the blog. 

*This post is locked for comments

I have the same question (0)
  • Crispin John Augustine Profile Picture
    37,081 on at

    in the RDP class.processReport(), you can Access the query and all it's ranges. using this.parmQuery()

    You can extract the range values and store it in a tmpTable field. The next steps to Show in the Report design are quite straight Forward..

  • Verified answer
    Sukrut Parab Profile Picture
    71,735 Moderator on at

    Hi Sabarish K ,

    Its up to you how you want to display it on your report . Martins example shows you how to do it with TmpSysQuery table. If you just want to show 1 range you can add a field in your existing report dataset temp table and populate that field with range you want. If you want to show it as a different section in report then you can do what is shown in above blog and use two different temp datasources in your report. In process report method you should    be able to get query.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans