First and foremost, thanks in advance for any recommendations and solutions.
Using COGNOS Analytics v11.2.4
Background, have a report with 3 pages, those being:
Summary
Items
Orders
Desire to schedule this report to email a list of recipients as:
Summary-This would be HTML in the email body
Items & Orders-These pages would be 2 separate sheets within Excel.
This executes without issue when rendering all 3 pages to Excel, however when attempting the desired output above, the email only contains hyperlinks.
Attempted to follow steps found here in an older post: https://www.cognoise.com/index.php?topic=34153.0
Within Page Properties:
Summary- Created boolean variable 'Render for HTML'
ReportOutput () = 'HTML'Set render variable to Render for HTML
Items and Orders Pages-Created boolean variable 'Render for Excel'
ReportOutput () = 'SpreadsheetML'Set render variable to Render for Excel
Created schedule with both HTML and Excel toggled on, along with send report by email. Confirmed message body is indeed clean, no spaces or empty characters found.
Report is delivered, however no Excel attachment or HTML in the body. Anyone have any suggestion or cannot identify what I may have missed. Appreciate any feedback.