Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

How to determine Report Query

Posted on by 11,871

I created a copy from a standard report , but the new report still read from the old query even I change it in the new DB class , where I have to modify this property other than DP class

  • maram fraij Profile Picture
    maram fraij 11,871 on at
    RE: How to determine Report Query

    I create a copy from the original design and use it in the controller ,the design is updated and link it with  new DP class

  • Jeson Profile Picture
    Jeson 120 on at
    RE: How to determine Report Query

    When u generated ur new report, is it really ur new design or still the old design?

    Did change also the dataset provider on ur SSRS in VS?

    better show ur controller code.

  • maram fraij Profile Picture
    maram fraij 11,871 on at
    RE: How to determine Report Query

    I create a copy from all  report classes ,design and query , I mean I change the  query in DP class and let it the new query in SRSReportQueryAttribute and the same for the controller I update the controller class and let it new controller  in SRSReportParameterAttribute

  • Jeson Profile Picture
    Jeson 120 on at
    RE: How to determine Report Query

    Just to clarify of what ur trying to achieve, u said u change it to a new DB class, what did you mean for that? are u pertaining to the report data provider? If your trying to copy and change the data or the query you should create another RDP for ur new copied report and assign it on your SSRS dataset. Dont be confuse between RDP and Query, for me they are not the same in SSRS.
    Regarding the contorller, as far as i know u cant directly determine the query or the RDP on the controller, the only way is try to determine the SSRS and look the dataset.

    Is the report PayrollPayStatementReport uses controller before generating?

  • maram fraij Profile Picture
    maram fraij 11,871 on at
    RE: How to determine Report Query

    Hi Jeson

    The report is PayrollPayStatementReport

    In the controller where the query can be determined ?

  • Jeson Profile Picture
    Jeson 120 on at
    RE: How to determine Report Query

    Can you tell us what standard report is that? because maybe the menuitem properties affect the process. Try also checking the controller class.

  • babalalex Profile Picture
    babalalex 405 on at
    RE: How to determine Report Query

    First of all you may have to find out, exact query :

    Just see if following piece of code helps you in some way

    Runnable class:

    class IntercompanyRunnableClass

    {        

       /// <summary>

       /// Runs the class with the specified arguments.

       /// </summary>

       /// <param name = "_args">The specified arguments.</param>

       public static void main(Args _args)

       {      

           Query   query;

           query   = new Query(queryStr(MySampleQuery));

           info(query.dataSourceNo(1).toString());

       }

    }

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,513 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans