Greetings,

I have a report which opens in Excel with drilldowns to report 2, which also open in Excel. This part is fine, but I have another level of drilldown from report 2 to report 3, also in Excel, which does not open. Hovering over a link in report 2 shows that the link is not set up as https:, but file:///C. Not sure what I need to do to get these links to use https:.

I am using Office 2007 and the reports open in Excel and not within the browser.

Any ideas?

Thank you.

This message has been edited. Last edited by: Kerry,

What does the portion of the STYLESHEET code in report 2 that declares the link to report 3 look like? (Please don't post the whole fex.)

TYPE=DATA, COLOR=BLUE, COLUMN=B1, STYLE=-UNDERLINE+BOLD,\
FOCEXEC=balsdetl(FY=B1 CFIND=B2 ACCD='&ACCT'), target=_blank, $

Also, if I change report 2 to open in pdf, then report 3 will open in Excel.

Try using the below

-SET &FOCEXURL = &URL_PROTOCOL || '://' || &SERVER_NAME || ':' || &SERVER_PORT ;
-SET &FOCEXURL = &FOCEXURL || &SCRIPT_NAME || '?IBIF_webapp=/ibi_apps' | '&';
-SET &FOCEXURL = &FOCEXURL | 'IBIC_server=EDASERVE' | '&';
-SET &FOCEXURL = &FOCEXURL | 'IBIWF_msgviewer=OFF' | '&';
-SET &FOCEXURL = &FOCEXURL | 'IBIMR_drill=X,' ||&IBIMR_domain | '&';
SET FOCEXURL = '&FOCEXURL'
-TYPE &FOCEXURL ;

Place the above code in each of your FEX file , the best way would be to create a utility and use that file using -INCLUDE and all your reporting FEX files. If those variables are not read automatically then I think you need to set those variable in the custom setting s section in Managed Reporting Console (search in the forums and you should find the related).

Thanks Rao, that did the trick.