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

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

I used the next-listing command but the weird thing is that the
#current-line 
variable is always the absolute coordinate and not reset to 1. 
Anyway it works just with next-listing and some other tricks. 
Thanks a lot for your help

> -----Ursprüngliche Nachricht-----
> Von: Steve Cavill [mailto:steve.cavill@infoclarity.com.au]
> Gesendet: Samstag, 18. November 2006 13:09
> An: 'This list is for discussion about the SQR database
> reportinglanguage from Hyperion Solutions.'
> Betreff: RE: AW: AW: [sqr-users] printing groupheader and 
> details in one
> horizontal band
> 
> 
> Sorry to repeat myself Marius,
> But you seem to be making this simple problem incredibly complicated.
> The next-listing command solves your problem.  Have you tried 
> it? If so what doesn't work with it.
> If you haven't tried it, why not?
> Steve.   
> 
> -----Original Message-----
> From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
> [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqru
> g.org] On Behalf Of Giepz, Marius
> Sent: Saturday, 18 November 2006 3:21 AM
> To: 'This list is for discussion about the SQR database 
> reporting languagefrom Hyperion Solutions.'
> Subject: AW: AW: AW: [sqr-users] printing groupheader and 
> details in one horizontal band
> 
> I tried it like this now, but it seems like the variable 
> #starting_point is 0 inside the subquery as it is a local variable
> 
> > -----Ursprüngliche Nachricht-----
> > Von: Dwight Schrute [mailto:schrute.dwight@hotmail.com]
> > Gesendet: Dienstag, 14. November 2006 17:26
> > An: sqr-users@sqrug.org
> > Betreff: RE: AW: AW: [sqr-users] printing groupheader and 
> details in 
> > one horizontal band
> > 
> > 
> > The variable #current-line is a reserved variable that is 
> global.  A 
> > variable is only local when the procedure is declared with 
> variables 
> > in the name, such as:
> >    begin-procedure Master_Query_BeforeProc ( #line_number ) 
> > #line_number and any variables within the procedure would be local 
> > unless they have an underscore, such as $_variable_name 
> would refer to 
> > $variable_name outside of the local scope.
> > 
> > Back to your problem, the substitution variables &head2 and
> > &head3 are only
> > being printed when the value of &val1 changes.  You're also not 
> > incrementing #starting_point for the next line so you are 
> printing on 
> > the same line you ended on ( the same line as &val2 ).
> > 
> > You could split this into two queries.  For example:
> > 
> > begin-procedure master_query
> >    begin-select
> > table.head2 &head2 ( +10, 33 )
> > table.head3 &head3 ( +10, 89 )
> > 
> >       let #starting_point = #current-line - 20
> >       do child_query
> > 
> >       from table
> >    end-select
> > end-procedure  !master_query
> > 
> > begin-procedure child_query
> >    begin-select
> > table.val1 &val1 ( #starting_point, 200 )
> > table.val2 &val2 ( +10, 200 )
> > 
> >       add 20 to #starting_point
> > 
> >       from table
> >       where head2 = &head2
> >    end-select
> > end-procedure  !child_query
> > 
> > 
> > >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: AW: [sqr-users] printing groupheader and 
> details in one 
> > >horizontal band
> > >Date: Tue, 14 Nov 2006 15:17:19 +0100
> > >
> > >would the #current_line thing also work in graphic mode?
> > >i have to position the lines and boxes pixel accurate so i
> > use this mode.
> > >
> > >the way i tried it so far seem to be wrong. i am not really
> > familiar with
> > >the
> > >namespaces of variables in sqr yet. i mean using global and local 
> > >variables.
> > >when i use on-break for the grouping, then the groupheaders
> > are printed in
> > >a
> > >subroutine
> > >i tried it like this:
> > >
> > >
> > >Begin-Procedure Master_Query
> > >   Begin-Select
> > >
> > >   table.head2     &head2
> > >   table.head3     &head3
> > >
> > >   !my grouping criterion (it shall not be printed)
> > >   table.head1 &val1 () On-Break Set=1 Level=2 Print=Never 
> > >Before=Master_Query_BeforeProc
> > >   !print the details
> > >   table.val1 &val1 (#starting_point,200)
> > >   table.val2 &val2 (+10, 200)
> > >
> > >   if #ending_point > #current-line
> > >                   move #ending_point to #starting_point
> > >           else
> > >                   move #current-line to #starting_point
> > >           end-if
> > >
> > >   From ...........
> > >
> > >   End-Select
> > >
> > >End-Procedure
> > >
> > >!print the groupheader
> > >Begin-Procedure Master_Query_BeforeProc
> > >
> > >   move #current-line to #starting_point
> > >
> > >   Print &head2 (#starting_point,33)
> > >           Print &head3 (+10,89)
> > >
> > >   move #current-line to #ending_point
> > >
> > >End-Procedure
> > >
> > >
> > >
> > >
> > >There must be some big fault in my understanding of the
> > sequence. do those
> > >point variables have to be global?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > > -----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.
> > > >
> > > > 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 )
> > > >   ...
> > > >
> > >
> > >_______________________________________________
> > >sqr-users mailing list
> > >sqr-users@sqrug.org
> > >http://www.sqrug.org/mailman/listinfo/sqr-users
> > 
> > _________________________________________________________________
> > Try the next generation of search with Windows Live Search today!  
> > http://imagine-windowslive.com/minisites/searchlaunch/?locale=
> en-us&source=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
> 
> 
> 
> _______________________________________________
> 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