Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Footers in a Grid Report

6 posts in PB Infomaker Report Writer Last posting was on 1999-05-12 19:06:00.0Z
Marc Leribaux Posted on 1999-05-10 13:53:48.0Z
Newsgroups: sybase.public.infomaker.general
Date: Mon, 10 May 1999 15:53:48 +0200
From: Marc Leribaux <Marc.leribaux@capgeminigroup.com>
Reply-To: Marc.Leribaux@capgeminigroup.com
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Footers in a Grid Report
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 12
Message-ID: <348_3736E4EC.CC787AC@capgeminigroup.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6360
Article PK: 241350

I'm using Infomaker 6.5 and I've already searched for hours on the
following problem:

When defining a grid-report, I encountered the problem that the text in
the footers is limited to column-width of the grid. Is there any way to
solve this problem? I've already tried to put the text on 'foreground'
or 'background' (like I did for the headers of the report), but this
doesn't work.

If anyone could help me, I would be very grateful


Terry Dykstra Posted on 1999-05-10 16:04:15.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Footers in a Grid Report
Date: Mon, 10 May 1999 10:04:15 -0600
Lines: 26
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_jUvQ94vm#GA.317@forums.sybase.com>
References: <348_3736E4EC.CC787AC@capgeminigroup.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6356
Article PK: 241342

That's definitely an akward one. The problem is that by putting the object
in the foreground, so it's no longer part of the band, you've fixed the
position of the object. But if you know the height of your report (by
setting it to portrait/landscape for a specific papersize), you can set the
Y position of the object, for instance set it to 10.5 for 11 inch paper. If
you scroll down the screen, you will see the object has moved down, outside
the 'regular' working area. Make sure you increase the size of the footer,
so it will end up in the space of the footer once you run the report.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Marc Leribaux wrote in message <3736E4EC.CC787AC@capgeminigroup.com>...
>I'm using Infomaker 6.5 and I've already searched for hours on the
>following problem:
>
>When defining a grid-report, I encountered the problem that the text in
>the footers is limited to column-width of the grid. Is there any way to
>solve this problem? I've already tried to put the text on 'foreground'
>or 'background' (like I did for the headers of the report), but this
>doesn't work.
>
>If anyone could help me, I would be very grateful
>


Marc Leribaux Posted on 1999-05-11 15:08:37.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 11 May 1999 17:08:37 +0200
From: Marc Leribaux <Marc.Leribaux@capgeminigroup.com>
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Footers in a Grid Report
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 55
Message-ID: <348_373847F5.4B14AE1@capgeminigroup.com>
References: <348_3736E4EC.CC787AC@capgeminigroup.com> <348_jUvQ94vm#GA.317@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6353
Article PK: 241338

Thanks for the quick response. I've tried it at it works ! Nevertheless our
problem isn't entirely solved. We use infomaker to develop the reports, but
afterwards they are 'lauched' by an application in powerbuilder. This
application gives us the opportunity to display the report in such a way that
while scrolling trough the report the headers and footers stayed fixed on the
screen. I've noticed that the solution, you proposed, has as consequence that
those objects aren't visible. Nevertheless when you print the report, the object
are at the right place.

Another (not related) problem is that when we print a grid-report, the
allignment of the columns and the different headers doesn't correspond to the
allignment we've fixed while designing the report. this allignment is correct in
display-mode, but not in print-mode;
Do you have an explanation for this problem?

thanks,

Marc Leribaux

Terry Dykstra wrote:

> That's definitely an akward one. The problem is that by putting the object
> in the foreground, so it's no longer part of the band, you've fixed the
> position of the object. But if you know the height of your report (by
> setting it to portrait/landscape for a specific papersize), you can set the
> Y position of the object, for instance set it to 10.5 for 11 inch paper. If
> you scroll down the screen, you will see the object has moved down, outside
> the 'regular' working area. Make sure you increase the size of the footer,
> so it will end up in the space of the footer once you run the report.
>
> --
> Terry Dykstra (TeamPS)
> Canadian Forest Oil Ltd.
> Marc Leribaux wrote in message <3736E4EC.CC787AC@capgeminigroup.com>...
> >I'm using Infomaker 6.5 and I've already searched for hours on the
> >following problem:
> >
> >When defining a grid-report, I encountered the problem that the text in
> >the footers is limited to column-width of the grid. Is there any way to
> >solve this problem? I've already tried to put the text on 'foreground'
> >or 'background' (like I did for the headers of the report), but this
> >doesn't work.
> >
> >If anyone could help me, I would be very grateful
> >


Terry Dykstra Posted on 1999-05-11 19:10:12.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Footers in a Grid Report
Date: Tue, 11 May 1999 13:10:12 -0600
Lines: 73
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_3ZIdfF#m#GA.317@forums.sybase.com>
References: <348_3736E4EC.CC787AC@capgeminigroup.com> <348_jUvQ94vm#GA.317@forums.sybase.com> <348_373847F5.4B14AE1@capgeminigroup.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6352
Article PK: 241337

The problem is that the objects are no longer in the band, so they don't
scroll in sync. In your PB script you'll have to dynamically change the
location of the object (set the Y position). That will be pretty ugly code
(dw_1.Object.mycomputedfield.Y = 'the y position' )

Your second problem is most likely due to the fact you are not using True
Type fonts. TT fonts do a better job of matching screen resolution with
printer resolution.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Marc Leribaux wrote in message <373847F5.4B14AE1@capgeminigroup.com>...
>Thanks for the quick response. I've tried it at it works ! Nevertheless our
>problem isn't entirely solved. We use infomaker to develop the reports, but
>afterwards they are 'lauched' by an application in powerbuilder. This
>application gives us the opportunity to display the report in such a way
that
>while scrolling trough the report the headers and footers stayed fixed on
the
>screen. I've noticed that the solution, you proposed, has as consequence
that
>those objects aren't visible. Nevertheless when you print the report, the
object
>are at the right place.
>
>Another (not related) problem is that when we print a grid-report, the
>allignment of the columns and the different headers doesn't correspond to
the
>allignment we've fixed while designing the report. this allignment is
correct in
>display-mode, but not in print-mode;
>Do you have an explanation for this problem?
>
>thanks,
>
>Marc Leribaux
>
>
>Terry Dykstra wrote:
>
>> That's definitely an akward one. The problem is that by putting the
object
>> in the foreground, so it's no longer part of the band, you've fixed the
>> position of the object. But if you know the height of your report (by
>> setting it to portrait/landscape for a specific papersize), you can set
the
>> Y position of the object, for instance set it to 10.5 for 11 inch paper.
If
>> you scroll down the screen, you will see the object has moved down,
outside
>> the 'regular' working area. Make sure you increase the size of the
footer,
>> so it will end up in the space of the footer once you run the report.
>>
>> --
>> Terry Dykstra (TeamPS)
>> Canadian Forest Oil Ltd.
>> Marc Leribaux wrote in message <3736E4EC.CC787AC@capgeminigroup.com>...
>> >I'm using Infomaker 6.5 and I've already searched for hours on the
>> >following problem:
>> >
>> >When defining a grid-report, I encountered the problem that the text in
>> >the footers is limited to column-width of the grid. Is there any way to
>> >solve this problem? I've already tried to put the text on 'foreground'
>> >or 'background' (like I did for the headers of the report), but this
>> >doesn't work.
>> >
>> >If anyone could help me, I would be very grateful
>> >
>


Marc Leribaux Posted on 1999-05-12 13:02:43.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 12 May 1999 15:02:43 +0200
From: Marc Leribaux <marc.leribaux@capgeminigroup.com>
X-Mailer: Mozilla 3.04Gold (Win95; I)
MIME-Version: 1.0
Subject: Re: Footers in a Grid Report
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 87
Message-ID: <348_37397BF3.5BFA@capgeminigroup.com>
References: <348_3736E4EC.CC787AC@capgeminigroup.com> <348_jUvQ94vm#GA.317@forums.sybase.com> <348_373847F5.4B14AE1@capgeminigroup.com> <348_3ZIdfF#m#GA.317@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6347
Article PK: 241333

Thanks for the suggestion regarding the objects in the footer. I'll will
check that. The problem I see at this moment is that we don't always use
the same paper format. Depending on the report we launch it is landscape
of portrait. This is offcourse transparant to the pb-application.

Concerning the problem of the alignment while printing, I've checked if
we use True Font and in fact we do. So this is not a solution to our
problem.

Terry Dykstra wrote:
>
> The problem is that the objects are no longer in the band, so they don't
> scroll in sync. In your PB script you'll have to dynamically change the
> location of the object (set the Y position). That will be pretty ugly code
> (dw_1.Object.mycomputedfield.Y = 'the y position' )
>
> Your second problem is most likely due to the fact you are not using True
> Type fonts. TT fonts do a better job of matching screen resolution with
> printer resolution.
>
> --
> Terry Dykstra (TeamPS)
> Canadian Forest Oil Ltd.
> Marc Leribaux wrote in message <373847F5.4B14AE1@capgeminigroup.com>...
> >Thanks for the quick response. I've tried it at it works ! Nevertheless our
> >problem isn't entirely solved. We use infomaker to develop the reports, but
> >afterwards they are 'lauched' by an application in powerbuilder. This
> >application gives us the opportunity to display the report in such a way
> that
> >while scrolling trough the report the headers and footers stayed fixed on
> the
> >screen. I've noticed that the solution, you proposed, has as consequence
> that
> >those objects aren't visible. Nevertheless when you print the report, the
> object
> >are at the right place.
> >
> >Another (not related) problem is that when we print a grid-report, the
> >allignment of the columns and the different headers doesn't correspond to
> the
> >allignment we've fixed while designing the report. this allignment is
> correct in
> >display-mode, but not in print-mode;
> >Do you have an explanation for this problem?
> >
> >thanks,
> >
> >Marc Leribaux
> >
> >
> >Terry Dykstra wrote:
> >
> >> That's definitely an akward one. The problem is that by putting the
> object
> >> in the foreground, so it's no longer part of the band, you've fixed the
> >> position of the object. But if you know the height of your report (by
> >> setting it to portrait/landscape for a specific papersize), you can set
> the
> >> Y position of the object, for instance set it to 10.5 for 11 inch paper.
> If
> >> you scroll down the screen, you will see the object has moved down,
> outside
> >> the 'regular' working area. Make sure you increase the size of the
> footer,
> >> so it will end up in the space of the footer once you run the report.
> >>
> >> --
> >> Terry Dykstra (TeamPS)
> >> Canadian Forest Oil Ltd.
> >> Marc Leribaux wrote in message <3736E4EC.CC787AC@capgeminigroup.com>...
> >> >I'm using Infomaker 6.5 and I've already searched for hours on the
> >> >following problem:
> >> >
> >> >When defining a grid-report, I encountered the problem that the text in
> >> >the footers is limited to column-width of the grid. Is there any way to
> >> >solve this problem? I've already tried to put the text on 'foreground'
> >> >or 'background' (like I did for the headers of the report), but this
> >> >doesn't work.
> >> >
> >> >If anyone could help me, I would be very grateful
> >> >
> >


Terry Dykstra Posted on 1999-05-12 19:06:00.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Footers in a Grid Report
Date: Wed, 12 May 1999 13:06:00 -0600
Lines: 113
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_iwhcvnKn#GA.204@forums.sybase.com>
References: <348_3736E4EC.CC787AC@capgeminigroup.com> <348_jUvQ94vm#GA.317@forums.sybase.com> <348_373847F5.4B14AE1@capgeminigroup.com> <348_3ZIdfF#m#GA.317@forums.sybase.com> <348_37397BF3.5BFA@capgeminigroup.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6341
Article PK: 241326

Different printer drivers cause different results. That's unfortunately
something outside of PB/IM control. The report will try to emulate as best
as possible the screen and the printer fonts. So changing to a different
printer driver sometimes solves these problems.

In your PB application you can determine what paper orientation you are
using and what papersize:
ls_orient = dw_1.Object.DataWindow.Print.Orientation
ls_papersize = dw_1.Object.DataWindow.Print.Paper.Size

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Marc Leribaux wrote in message <37397BF3.5BFA@capgeminigroup.com>...
>Thanks for the suggestion regarding the objects in the footer. I'll will
>check that. The problem I see at this moment is that we don't always use
>the same paper format. Depending on the report we launch it is landscape
>of portrait. This is offcourse transparant to the pb-application.
>
>Concerning the problem of the alignment while printing, I've checked if
>we use True Font and in fact we do. So this is not a solution to our
>problem.
>
>
>
>Terry Dykstra wrote:
>>
>> The problem is that the objects are no longer in the band, so they don't
>> scroll in sync. In your PB script you'll have to dynamically change the
>> location of the object (set the Y position). That will be pretty ugly
code
>> (dw_1.Object.mycomputedfield.Y = 'the y position' )
>>
>> Your second problem is most likely due to the fact you are not using True
>> Type fonts. TT fonts do a better job of matching screen resolution with
>> printer resolution.
>>
>> --
>> Terry Dykstra (TeamPS)
>> Canadian Forest Oil Ltd.
>> Marc Leribaux wrote in message <373847F5.4B14AE1@capgeminigroup.com>...
>> >Thanks for the quick response. I've tried it at it works ! Nevertheless
our
>> >problem isn't entirely solved. We use infomaker to develop the reports,
but
>> >afterwards they are 'lauched' by an application in powerbuilder. This
>> >application gives us the opportunity to display the report in such a way
>> that
>> >while scrolling trough the report the headers and footers stayed fixed
on
>> the
>> >screen. I've noticed that the solution, you proposed, has as consequence
>> that
>> >those objects aren't visible. Nevertheless when you print the report,
the
>> object
>> >are at the right place.
>> >
>> >Another (not related) problem is that when we print a grid-report, the
>> >allignment of the columns and the different headers doesn't correspond
to
>> the
>> >allignment we've fixed while designing the report. this allignment is
>> correct in
>> >display-mode, but not in print-mode;
>> >Do you have an explanation for this problem?
>> >
>> >thanks,
>> >
>> >Marc Leribaux
>> >
>> >
>> >Terry Dykstra wrote:
>> >
>> >> That's definitely an akward one. The problem is that by putting the
>> object
>> >> in the foreground, so it's no longer part of the band, you've fixed
the
>> >> position of the object. But if you know the height of your report (by
>> >> setting it to portrait/landscape for a specific papersize), you can
set
>> the
>> >> Y position of the object, for instance set it to 10.5 for 11 inch
paper.
>> If
>> >> you scroll down the screen, you will see the object has moved down,
>> outside
>> >> the 'regular' working area. Make sure you increase the size of the
>> footer,
>> >> so it will end up in the space of the footer once you run the report.
>> >>
>> >> --
>> >> Terry Dykstra (TeamPS)
>> >> Canadian Forest Oil Ltd.
>> >> Marc Leribaux wrote in message
<3736E4EC.CC787AC@capgeminigroup.com>...
>> >> >I'm using Infomaker 6.5 and I've already searched for hours on the
>> >> >following problem:
>> >> >
>> >> >When defining a grid-report, I encountered the problem that the text
in
>> >> >the footers is limited to column-width of the grid. Is there any way
to
>> >> >solve this problem? I've already tried to put the text on
'foreground'
>> >> >or 'background' (like I did for the headers of the report), but this
>> >> >doesn't work.
>> >> >
>> >> >If anyone could help me, I would be very grateful
>> >> >
>> >