RE: [sqr-users] Subscription to Exceptions

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

Now I'm confused.  Below you say you are getting the email, but earlier you
said you are not getting the email.  Do you mean you are getting the email
whether there is an exception or not, and that you DO NOT want to get a
message UNLESS there is an exception?  In which case your setup below looks
correct.
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: Monday, 5 July 2004 10:26 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Cc: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.;
sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
Subject: RE: [sqr-users] Subscription to Exceptions


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



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