Focal Point
Hyperlinks in Report Caster

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5041043052

October 05, 2007, 01:48 PM
Jose Cruz
Hyperlinks in Report Caster
I am testing Report Caster in our company and I have been able to schedule a report and send it to myself daily. The problem I'm having is that the report contains hyperlinks to 3 other reports and the links are broken. Does anyone know if it's possible to do this in Report Caster? All the subsequent reports pass data required to run all the following linked reports. For example, the first report is a Safety Stock report. This report lists parts that have fallen below a certain re-order point and it links to a P.O. report that shows if there are open orders. The PO report is linked to a Supplier data report, and finally the supplier report is linked to a A/P data report.


WebFOCUS v7.7.03
Windows 7 O/S
Oracle database
Platform Windows 2003 server 32bit
Output types are HTML, PDF, Excel 2003 Active Reports
October 05, 2007, 02:45 PM
FrankDutch
Jose

This depends where your linked reports are stored, in the MRE or in the EDA, if you put these reports in MRE the users should log in to the system.
You can also put them in the public domain.

BTW would you be so kind to update your signature...




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

October 05, 2007, 08:13 PM
Seva
I have very similar functionality working fine with ReportCaster. You have to do 2 things in code:
1. At the top of procedure put
 SET FOCEXURL=http://ServerNameHere/ibi_apps/WFServlet 

2. Link column in report to another procedure
 TYPE=DATA, COLUMN=REPLACE_THIS_WITH_COLUMN_NAME, COLOR='BLUE', FOCEXEC=ANOTHER_PROCEDURE_NAME_HERE(PARAMETER_NAME_HERE=PARAMETER_VALUE_HERE),$ 



WF 7.6.4, Win XP, SQL 2005