RE: AW: [sqr-users] printing groupheader and details in onehorizontal band

["Dwight Schrute" <schrute.dwight@hotmail.com>]

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.

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.

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".

>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@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

_________________________________________________________________
Add a Yahoo! contact to Windows Live Messenger for a chance to win a free 
trip! 
http://www.imagine-windowslive.com/minisites/yahoo/default.aspx?locale=en-us&hmtagline


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