If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Scheduling Single Report w/Multiple Outputs

Started by SweepTheLeg, 18 Oct 2024 12:54:42 PM

Previous topic - Next topic

SweepTheLeg

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.