RE: [sqr-users] Subscription to Exceptions

["Darshil Mehta" <Darshil.Mehta@lntinfotech.com>]

I checked both. I get emails whenever do following:

On brio portal, under subscription:

- Click subscribe to 'Subscribe to output from <report name>'
- Click 'Only subscribe to exception item'
- Attach output from <report name> to email message

My object's life is 500 mins. 

Is there any code that I have write in .sqr file to get email 
notifications only whenever there is exceptions?

Thanks,
Darshil





"Steve Cavill" <steve.cavill@infoclarity.com.au>
Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
30/06/2004 05:52 PM
Please respond to "This list is for discussion about the SQR database 
reporting       language from Hyperion Solutions."

 
        To:     "This list is for discussion about the SQR database 
reportinglanguage from 
Hyperion Solutions." <sqr-users@sqrug.org>
        cc: 
        Subject:        RE: [sqr-users] Subscription to Exceptions


Do you get an email if you just subscribe to the report without 
exceptions?
Do any other subscription emails work?
You need to see which is failing, the detection of the exception, or the
sending of the email.
Steve.


-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On
Behalf Of Darshil Mehta
Sent: Wednesday, 30 June 2004 6:58 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Subscription to Exceptions


All,

I have one SQR report in which I have written following code:

  if #cnt_total > #temp
     print 'Exception: Prodline has changed' (1,1)
     open 'output.properties' as 0 for-append record=32767:vary
     write 0 from 'exception.default=on'
     write 0 from 'exception.default.text=Prodline has changes'
     close 0
  else
     print 'Exception: Prodline has NO changes ' (1,1)
     open 'output.properties' as 0 for-append record=32767:vary
     write 0 from 'exception.default=on'
     write 0 from 'exception.default.text=Prodline has NO changes'
     close 0
  end-if

When I publish this report on Brio Portal with option 'Can have
exception', I can see proper exceptions on my Brio Portal dashboard. But
when I schedule it with email notification, I do not receive any email
regarding exception.

Can anyone suggest what could be the problem? Thanks in advance.


Best regards,

Darshil Mehta


______________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

______________________________________________________________________




______________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users