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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

cannot deploy new dataset/query on one single SSRS report, LedgerJournal Report

(0) ShareShare
ReportReport
Posted on by 1,094

Hi,

Sometimes we need to put additionals information in our report.

in my case i need to put Signers information from my Master data, Signer Table(header and Line) at my report LedgerJournalReport.

i  have create one Temporary table.

then,i tried my two methods.

1. i defined my temporary table on my Report Data Provider class and called it on Visual Studio/SSRS. but when i tried to deploy my changes, its makes an error to LedgerjournalDS(standard ledgerjournal datasets).the system suggest me to set-up the Dynamics Filter property = False if u r not used this datasets.how come?..coz i am gonna used this new datasets

2. i created new Query in AOT based on my Temporary table and called it on my report, LedgerJournal. but when i try to deploy it, its makes an error to LedgerjournalDS(standard ledgerjournal datasets).the system suggest me to set-up the Dynamics Filter property = False if u r not used this datasets. Its a same error message with my first method.

is there anyone here who got a same problem with me and found the solution how to resolved this problem?

Thanks for the helps.

Husna

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Raheel-Khan Profile Picture
    1,371 on at

    Dear Husna,

    Trust you are fine!

    Please find the below mentioned details of Dynamics filters properties.

    Dynamic Filters

    • True – The end-user of the report can add additional filters when they run the report. A single dataset parameter and report parameter are created to transport the dynamic filters that are set at runtime for the report. A dataset parameter references the report parameter and is set in the Properties window of the dataset parameter in the Report Parameter property. When the Dynamic Filters property is set to True, the default ranges are not created for the report.

      --or--

    • False – The filters are static, meaning they are defined in the report model. Dataset parameters and report parameters are created for every range defined in the AX query. The end user of the report will identify the ranges when they view the report. For information about how to define a set range for a filter on a report.

    Also visit this link that how to create Temp Table in Dynamics AX 2012:

    https://blogs.msdn.microsoft.com/axsupport/2012/08/09/temporary-tables-ax-2012/

    Warm Regards,

    Raheel

  • Husna Yusuf Profile Picture
    1,094 on at

    Hi Raheel,

    Thanks for the information.

    but still i cannot deploy my modifications on my LedgerJournal report.

    Ok... perhaps the error caused by another factors.

    i will give you another informations from the error message.

    Regards,

    Husna

  • Verified answer
    Husna Yusuf Profile Picture
    1,094 on at

    Ok,

    this problem caused by property from the element/field is missing.

    we can resetup the field/element by creating new expresion, right click on the field -> Expresion.

    but some cases we have to delete first the error fields then recreate the field we want.

    Regards,

    Husna

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans