When viewing a report within Jiwa, the ability to drill to source documents forms 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:
| Info | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Page Properties | ||
|---|---|---|
| ||
|
...