Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

How to determine Report Query

(0) ShareShare
ReportReport
Posted on by

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 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 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 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 411 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());

       }

    }

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans