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

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

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