[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Printing Dynamic variable in Header Brio SQR 8.1
- Subject: RE: [sqr-users] Printing Dynamic variable in Header Brio SQR 8.1
- From: "Hood Louise (app1lxh)" <app1lxh@ups.com>
- Date: Wed, 2 Jun 2004 09:26:37 -0400
- Delivery-date: Wed, 02 Jun 2004 08:30:10 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Scott,
1. Are you sure that your heading routine is even being executed?
Suggestion:
begin-heading 5
#debuga string $dttmstamp ' begin-heading' by '' into $dispstr
#debuga display $dispstr
(heading content)
#debuga string $dttmstamp ' end-heading' by '' into $dispstr
#debuga display $dispstr
end-heading
2. Are you sure that the size of your heading (5) is big enough; are you
sure that it's expressed in lines and not points?
Suggestion: Change heading to larger number (i.e., begin-heading 70)
3. Have you tried getting a static value to print?
Suggestion: substitute for print $dn (,10):
print 'This is my heading' (1,10)
to see if anything changes. Also, note you would be designating a specific
line of the heading for printing this statement.
HTH,
Louise
-----Original Message-----
From: Scott.Howser@Certegy.Com [mailto:Scott.Howser@Certegy.Com]
Sent: Wednesday, June 02, 2004 9:04 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Printing Dynamic variable in Header Brio SQR 8.1
Yesterday I submitted some sample code to print dynamically in the heading
section. Some people took the code I had literally but, it was meerely an
example to show the problem at hand. Does anyone know how to print
dynamically in a heading if evreything else in the program works fine. Below
is some more sample code it is to simply show the problem in its simplest
form.
This is the skeleton of the problem.
We cannot get this to work-----
!------------------------------------------------------------------
begin-heading 5
print 'heading: ' (,1)
let $dn=datenow()
print $dn (,10)
print $headingfield (,25)
end-heading
begin-procedure get_data
begin-select
category &f1 (+1,1) on-break procedure=changefield
let $headingfield=&f1
element (,25)
from dm_flat_element
end-select
end-procedure
begin-procedure changefield
new-page
end-procedure
begin-program
do get_data
end-program
!----------------------------------------------------------------------
Thanks,
Scott Howser
----------------------------------------------------------------------------
--
This message contains information from Certegy, Inc which may be
confidential and privileged. If you are not an intended recipient, please
refrain from any disclosure, copying, distribution or use of this
information and note that such actions are prohibited. If you have received
this transmission in error, please notify by e:mail postmaster@certegy.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