Processing only report with preview option

mabl4367
Member Posts: 143
Hi all!
What is the best way to create a processing only report with a preview option?
I have created a report for updateing wich implies it should have it's processing only property set to "Yes". However I want the user to be able to get a preview before letting the updates be written to the database.
When the user has seen the preview and is confident that the korrect updates will be preformed he or she usualy don't need a printout.
The only thing I can come up with is to make the report processing only and add a button to the request form that when pushed launches another report that creates the preview. This is not a very elegant solution since it requiers another report object with lots of duplicated code and the sending of keystrokes to immediately make it go into preview mode.
Any ideas?
What is the best way to create a processing only report with a preview option?
I have created a report for updateing wich implies it should have it's processing only property set to "Yes". However I want the user to be able to get a preview before letting the updates be written to the database.
When the user has seen the preview and is confident that the korrect updates will be preformed he or she usualy don't need a printout.
The only thing I can come up with is to make the report processing only and add a button to the request form that when pushed launches another report that creates the preview. This is not a very elegant solution since it requiers another report object with lots of duplicated code and the sending of keystrokes to immediately make it go into preview mode.
Any ideas?
0
Comments
-
You could create a report that shows the users which changes will be made. After a confirm in the OnPostReport trigger you can call the procedures to perform the update.0
-
You can also disable printout by
IF NOT CurrReport.PREVIEW THEN CurrReport.QUIT;
But maybe it is better to use a form based on a temporary table to show the possible changes to the user and add a button on that form to agree to the changes."Money is likewise the greatest chance and the greatest scourge of mankind."0 -
A form based on a temp table would be nice but it is not supported in nav 3.70 that we are on.0
-
If that is the limitation, the currreport.preview is your golden if.
IF it is preview then show the user what will change, if it is not then calculate and process the report.
But the processingonly property has to be false.0 -
Perhaps i could use an integer data item to go through the oter data items twice and make a confirm-dialog appear after the first run.0
-
If it's not the preview the user must have hit the print button. Then I can do the updates but I will also get a printout that I don't want0
-
In such cases I use the Request From and a boolean variable.
So the user can decide to just run the report and see what would be changed or if the variable is true the changes are made and he can print what the report did.
But you have to start the report twice.
The OnPostReport Trigger is much better than this but our users prefer this way.0 -
I tried the confirm in the OnPostReport trigger. The preview is still empty when the confirm dialog pops up, so the user still don't know what changes will be made and therefore doesn't know what answer to pick in the dialog.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions