Skip to main content
Post a question

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

How to see function definition of Report Writer user defined function

Like (0) ShareShare
ReportReport
Posted on 22 Jan 2024 18:04:41 by
Greetings, 
 
                        I want to see the Sql(or however result is getting produced) behind a user defined Report writer function. I have a function declared in a report for a calculated field as given below - 
 
                           RW_T_HOG_Claimed_By_Roll'( 'T_Tax_Roll_Certificate_HDR_TEMP'.'D_Roll #''T_Tax_Roll_SETUP'.'D_Taxation Year' ) 
                          
                      Due to some reason its not giving the expected output and I want to see how the result is getting calculated so i can troubleshoot it , but I am not sure how to see RW_T_HOG_Claimed_By_Roll function's definition.
                         
                         Any help will be great. Please let me know if you need further info.                       
 
                       Thanks in advance
 
Categories:
  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,004 User Group Leader on 23 Jan 2024 at 08:44:09
    How to see function definition of Report Writer user defined function
    It's not necessary that sql code run behind this function, may be the code is written in dexterity.
    You can check it by running sql profiler while printing the report so it will show sql code if there is any.
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,957 Most Valuable Professional on 23 Jan 2024 at 06:14:28
    How to see function definition of Report Writer user defined function
    I am not sure what product dictionary the RW_T_HOG_Claimed_By_Roll() report writer function is from.  It is not in the core Dynamics GP modules I have loaded.
     
    Anyhow, you can get the parameter list from the SDK (if it is included) or using GP Power Tools (on a system where it is installed).
     
    You probably can work out the parameters from the example call you have already.
     
    As for what it is doing, you would only be able to get an idea of the tables it accesses by using logging. With GP Power Tools we could enable logging for ONLY the period when that function is being executed. if the script makes a direct SQL call, we would be able to see that, otherwise we can see which tables it accesses, but not what it does with the data retrieved.
     
    The only way to see exactly what the code is doing is if you had access to the source code. Once we identify which product it is from, we can see if viewing the source is possible. Some Microsoft published dictionaries are included in a source code program and so it is possible to check the source code. If the function is in a custom dictionary or ISV product, you would need to discuss with the developer responsible.
     
    Good luck
     
    David

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,791 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans
Loading started