You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Excel output with Multiple sheets with hyperlink for cross-sheet reference BI Publisher Report

in Reporting and Analytics for ERP 1 comment

Summary:

Hi ,

I have a specific query regarding the feasibility of a dynamic feature:

Is it possible to enable a function in BIP's RTF/Excel template where, upon clicking on a Supplier name, the relevant Purchase Order (PO) details are displayed in another Excel tab within the downloaded file? There is requirement of to create an Excel file with two tabs - one dedicated to master data and the other solely for detailed information. Please find attached screenshot for your reference.


My objective is to ensure that all required operations, particularly the navigation between Supplier names and their corresponding PO details, occur seamlessly within the downloaded Excel file itself.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!