RE: [sqr-users] printing groupheader and details in one horizontalband

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

Yes, exactly.
E.g.
Begin-header
Print $head (1)
Print $head2(2) 
End-header

Begin-detail
Print $det1 (1)  - this is the same as line (1) above
Print $det2 (2)  
Print $det3 (3)
End-detail

Or 
Begin-header
Print $head (1)
Print $head2(2) 
End-header

Begin-detail
Position (1)  ! Go back to line 1 of header
Print $det1 (,)  - this is the same as line (1) above
Print $det2 (+1) - use relative lines if number of lines is variable 
Print $det3 (+1)
End-detail

Do header
Do detail
Next-listing skiplines =1.  Move down the page 1 line and reset the line number 
of the current (blank) line to 1


Call your header either from page-header or page-footer.
That way it prints once per page, after everything else.


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 Giepz, Marius
Sent: Friday, 10 November 2006 9:20 PM
To: 'This list is for discussion about the SQR database reporting languagefrom 
Hyperion Solutions.'
Subject: AW: [sqr-users] printing groupheader and details in one horizontal band

yeah, i quit the Production-Reportingstudio after the first week i got in touch 
with sqr (two months ago).

do you mean that i should print the header and then move back some lines up 
with the cursor to print the details? 

another offtopic question: i want to print some grids and boxes as sort of a 
"page background". would it bet best do call this
drawing procedure from the header block (what i am doing now)?

-----Ursprüngliche Nachricht-----
Von: Steve Cavill [mailto:steve.cavill@infoclarity.com.au]
Gesendet: Freitag, 10. November 2006 03:00
An: 'This list is for discussion about the SQR database reportinglanguage from 
Hyperion Solutions.'
Betreff: RE: [sqr-users] printing groupheader and details in one horizontal band


Look at the using relative print positions, and next-listing.
You can't do this with SQR developer (the GUI), you have to write the code.
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 Giepz, Marius
Sent: Friday, 10 November 2006 2:32 AM
To: 'This list is for discussion about the SQR database reporting languagefrom 
Hyperion Solutions.'
Subject: [sqr-users] printing groupheader and details in one horizontal band

Hello!

I would like to print fields of a groupheader and the corresponding details in 
a band-style row. 
Something like this:

Header1_field1          detail1
Header1_field2          detail2
Header1_field3          detail3
                                detail4

Header2_field1          detail1
Header2_field2          detail2
Header2_field3  


Header3_field1          detail1
Header3_field2          detail2
Header3_field3          detail3
                                detail4
                                detail5


would this be possible with sqr? I am so far only able to print them one below 
the other.
what would be the best approach then?

thanks in advance!

best regards

Marius


++++++++++++++++++++++++++++++++++++++++++++
Marius Giepz
topsystem Systemhaus GmbH
Europark A2
Adenauer Strasse 20
52146 Würselen
Germany
Phone : +49 2405 4670-0
email : mg@topsystem.de
++++++++++++++++++++++++++++++++++++++++++++ 

_______________________________________________
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