When viewing a report within Jiwa, the ability to drill to source documents from a field is possible through the use of a plugin and the modification of the report field formatting.
Step-by-step guide
- Import the plugin attached - Drill from reports
- Exit Jiwa and log back in
- Modify the required fields in your report(s) to include a specially formatted hyperlink
- Import the reports into Jiwa
How to modify the report field.
Using the Crystal Reports Designer, right click on a field to open the context menu and select Format Field...
The Format Editor will open - select the Hyperlink tab, and then check the A Website on the Internet radio button for the Hyperlink Type, and then press the Formula button next to the Website Address: field.
The Formula Editor will now open, enter in a formula to return a text value in for format {SY_Forms.ClassName}:{RecID}.
You can use any value from the ClassName field of the SY_Forms table for the first part of the hyperlink - for example, a hard-coded value to always drill to a sales order:
Plugin
Related articles