Share
ReportWe have VBA customization on RMStatementOnBlankPaper report, as we are planning to replace VBA, what are tools we could use to replace VBA?
thanks
Categories:
You’re offline. This is a read only version of the page.
5
We have VBA customization on RMStatementOnBlankPaper report, as we are planning to replace VBA, what are tools we could use to replace VBA?
thanks
Thanks for your help,
I have modified the report in report writer, and deployed it. and had some VBA code on it to get some detail data from invoice table.
I am trying to replace the VBA code, wondering what are tool to use, what is your development environment setup? I tried Dynamic SDK, but couldn't find where to access the report and add code to it
Thanks, have a nice day
As you mentioned you have modified the report in Dynamics.dic, I hope you have created it's chunk file to deploy on GP. In Dexterity development environment you need to add code for report by creating functions. What exactly your code is doing?? maybe you don't need to add code or just by creating some table relationship you can fetch data for your report.
Thanks for your help, Almas
I have the report modified in the report writer, and deployed the dynamics.dic. I have some vba code to get some data for the report. I would like to replace the vba code, would you mind to let me know what would be options? as you said, how can I write my logic in sanscript?
Thanks in advance
William,
It would be a little difficult for anyone without previous dexterity experience.
You must know how to copy Dynamics.dic and open it in Dexterity and find the report in dictionary.
if there are cosmetic changes then do it.
As you mentioned you have vba code, then you have to write same logic in sanscript.
then create chunk to deploy report changes( similar as package)
Add in GP and mark alternate report to access the modified report.
Thanks, Almas
could you advise how to use dexterity code?
thanks
Best option is to have report writer+ dexterity code to replace VBA.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (