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 -
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.
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.