How to show blank records with Headers displayed for all columns on Conditional basis in OACAgents

Question

Hi,

please let me know if it is possible to send attachment with Blank report included with report headers when 'no records' retrieved rather than sending blank e-mail when delivering an email attachment through agent/ibot in OACS.

Tried conditional basis but it does not allow any attachment when condition is false

Thanks.

Viswanath-Oracle · Answer

Thanks Steve for your response, but my requirement is when there are no records, output should be something like below with all headers and no output sent as attachment through mail

Thanks,

Viswanath.

Steve F-2 · Answer

You might be able to approach it two ways.

* Have a condition wherein the analysis is not sent if there is no data. (i.e. a condition ROWCOUNT('analysis') > 0 )
* Try and add a custom message in the analysis

To create a custom message to alert users to no data in the results of an analysis:

Edit the analysis to which you want to add a custom message.

Click the "Analysis editor: Results tab."

Click the Analysis Properties toolbar button. The "Analysis Properties dialog" is displayed.

In the No Results Settings box, select Display Custom Message.

In the Header field, enter the text of the header for the custom message.

In the Message field, enter the explanatory text.

Click OK.

Other comments welcomed.