RE: [sqr-users] Heading question

["Jim Womeldorf" <jwomeldo@fastenal.com>]

Dave,
Are you using any local procedures?  If you are, remember that you have
to reference global variables from within local procedures by inserting
an underscore as the second character.  ( $_variable in Karun's example)
Jim
 

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org] On Behalf Of
Karunakaran Perumbrayoor
Sent: Wednesday, July 26, 2006 8:35 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Heading question

Hi Dave,

        I think, the variable is not getting set properly.

Initialize a variable to 'D' to indicate detail records are getting
printed. Once all the detail records get printed, re-initialize the
variable back to 'S' to indicate summary records needed to be printed.
Before that use 'new-page' to print the summary in a new page. This
could also be a reason for the code not working as per your
expectations.

In the Begin-Heading Section.

If $variable = 'D'

Print 'Detail'

Else

Print 'Summary'

End-If

Or otherwise use Multiple Reports (I guess both these reports can use
the same layout which will be 'DEFAULT').

In the Begin-Heading Section, Use FOR-REPORTS to link to the report
(Summary or Detail). This should work for sure!!!

Have a Great Day!!!

Regards..
Karun

-----Original Message-----
From: Savage, David M [mailto:dmsavage@StateStreet.com]
Sent: Tuesday, July 25, 2006 7:53 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: [sqr-users] Heading question

I have a question regarding headings. I have a summary and detail report
(both same report) and need to print a different set of lines of the
heading depending on particular circumstances. (Whether or not the
summary is already done.)

I tried to init a variable to a value and perform the following within
the heading section 

        'IF variable = 0 do print s.lines Else print d.lines'. It is not
working

Any help would be appreciated

Thanks
Dave

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





************************************************************************
***************************************************
This e-mail communication and any attachments may be privileged and
confidential to Hexaware and are intended only for the use of the
recipients named above. If you are not the intended recipient, please do
not review, disclose, disseminate, distribute or copy this e-mail and
attachments. If you have received this email in error, please delete the
same alongwith all attachments thereto and notify us immediately at
mailadmin@hexaware.com .
************************************************************************
***************************************************
 


_______________________________________________
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