AW: AW: [sqr-users] printing groupheader and details in one horizontal band

["Giepz, Marius" <MG@topsystem.de>]

> -----Ursprüngliche Nachricht-----
> Von: Dwight Schrute [mailto:schrute.dwight@hotmail.com]
> Gesendet: Freitag, 10. November 2006 17:20
> An: sqr-users@sqrug.org
> Betreff: RE: AW: [sqr-users] printing groupheader and details in one
> horizontal band
> 
> 
> Allegedly, Hyperion is attempting to upgrade the Reporting 
> Studio to be more 
> powerful.  Until that happens (likely never), you can use 
> Ultra-Edit with 
> the wordfile from Ray Ontko's site 
> (http://www.ontko.com/sqr/sqr_wordfile.txt).  It will help immensely.

I allready have that. really helps a lot

> Suggestion #1 - For printing your header, you can store the 
> value in the 
> reserved variable "#current-line" and use that as a 
> coordinate.  Such as:
> 
>   move #current-line to #starting_point ! line number to 
> start printing
>   print 'header1_field1' ( #starting_point, 1 )
>   print 'header1_field2' ( +1, 1 )
>   print 'header1_field3' ( +1, 1 )
>   move #current-line to #ending_point ! line number at end of printing
> 
>   print 'detail1' ( #starting_point, 10 ) ! return to 
> starting line number
>   print 'detail2' ( +1, 10 )
>   print 'detail3' ( +1, 10 )
>   print 'detail4' ( +1, 10)
> 
>   ! determine which line number is larger to start printing after that
>   if #ending_point > #current-line
>     move #ending_point to #starting_point
>   else
>     move #current-line to #starting_point
>   end-if
> 
>   add 2 to #starting_point ! add an additional line in between
> 
>   print 'header2_field1' ( #starting_point, 1 )
>   ...
> 
> You can make it more dynamic with loops and such but you get 
> the concept.  
> Remember, in SQR that a header (and footer) can end up being 
> larger than the 
> declared space "begin-heading 10" and if it is larger, it will begin 
> printing into the body of the report.  However, the body can 
> never print 
> into the header or footer.

i will try that. thanks

> Suggestion #2 - For your page background, I do not know which 
> version of SQR 
> you are using but you could use the "declare-procedure" 
> statement with 
> "before-report" or "before-page".

good idea. i allready use that for printing subtotals from a page on the
next page

> >From: "Giepz, Marius" <MG@topsystem.de>
> >Reply-To: "This list is for discussion about the SQR database 
> >reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> >To: "'This list is for discussion about the SQR database reporting 
> >languagefrom Hyperion Solutions.'" <sqr-users@sqrug.org>
> >Subject: AW: [sqr-users] printing groupheader and details in 
> one horizontal 
> >band
> >Date: Fri, 10 Nov 2006 11:19:42 +0100
> >
> >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@sqr
> ug.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
> 
> _________________________________________________________________
> Add a Yahoo! contact to Windows Live Messenger for a chance 
> to win a free 
> trip! 
> http://www.imagine-windowslive.com/minisites/yahoo/default.asp
> x?locale=en-us&hmtagline
> 
> 
> _______________________________________________
> 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