[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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