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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SSRS Report Parameter ...
Microsoft Dynamics AX (Archived)

SSRS Report Parameter Field Duplication Issue

(0) ShareShare
ReportReport
Posted on by Nadeem Bhatti 2,055

I am using AX 2012, and going to develop a report by class. Now I have create a query with the following table

MianAccountCategory

MainAccount

JournalLedgerTrans

filter.png

Now when I go select the parameter, its going to duplicate the field as I am going to change some parameter. Can any one have some idea how to fix it, and why its creating copies of parameter fields?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Bashir Ahmad Profile Picture
    Bashir Ahmad 5,248 on at

    If the report is bound to a query with a range and a default value is specified, the report could be filtered by a multivalued parameter. To avoid this, you have the following options:

       Mark the query range parameter as internal in the report design to prevent duplicating the filter.

       Override the single filter using a report data provider (RDP) class.

       Avoid using queries that contain a predefined query range in reports.

    Please follow the link for further detail:

    technet.microsoft.com/.../cc586123.aspx

  • Nadeem Bhatti Profile Picture
    Nadeem Bhatti 2,055 on at

    Thanks Bashir Ahmad,

    I have try to add query range, but unfortunatly I am using Dimension account to filter data and in query dimension fields are not available. Secondly its creating problem with dimension accounts only, in normal table fields its going well.

    Now I am thinking to use UI Builder and Contact class for parameter. Can you suggest any other option, for this case.

  • Srinivasan Pandiaraj Profile Picture
    Srinivasan Pandiaraj 30 on at

    Dear Nadeem,

    I am also facing the same problem. Could you please let us know, have you got any solution towards this problem. This is the issue only, when we use GeneralJournalAccountEntry table in Report dataset Query. Thanks for your help.

    Kind Regards,

    Srinivasan P

  • Nadeem Bhatti Profile Picture
    Nadeem Bhatti 2,055 on at

    Hi Srinivasan,

    No, I didn't get any solution. To avoid it, I design the parameter fields by UI Builder, If you need I can provide you the code. If it can helps you.

    Regards,

    Nadeem Bhatti

  • Srinivasan Pandiaraj Profile Picture
    Srinivasan Pandiaraj 30 on at

    Thanks Nadeem :) for your swift response. That Multiselect parameter won't help with my issue. Since, the user wishes to filter by range like (001.. 025). This option not possible with Multiselect Filter.

    Please share once you found the solution with query filter.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans