Hi
In Reports in Datasource I Have 1 column GetFilters . I want if it is ShortCut Dimension1 Code it should be shown as Branch
Thanks
*This post is locked for comments
I hope you are trying to get the caption based on what dimension you have selected in General Ledger Setup, please check the Table 85, there is a function to GetCaptionClass to return caption based on dimension code.
Table 85 is Acc Schedule Line. But on Request Page it shows Branch . Why is it so. Can't the same name be displayed in RDLC.
Becauase it uses GetCaptionClass funciton to get the caption, you can use the same to get the value and use that in RDLC.
Can u please guide me how to use in my report
What is GetFilters in your report, are you trying to find if there any filters applied on the table using GETFILTERS, if you it is only for shortcut dimension 1 code, you could check if Record.GETFILTER("Shortcut Dimension 1 Code") <> '' THEN use CaptionClass to get the caption and display the filter or
from GETFILTERS strings you could use string function to replace Shortcut Dimension 1 code with branch.
Find if that exists using STRPOS, then delete the String using DELSTR and insert the string using COPYSTR
forum.mibuso.com/.../replace-a-string-by-another
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Alexander Ermakov 2
SC666 1
