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.

Multi-page report problem

4 posts in PB Infomaker Report Writer Last posting was on 1997-10-02 04:19:59.0Z
Rosemary Miller Posted on 1997-06-25 19:16:31.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 25 Jun 1997 12:16:31 -0700
From: Rosemary Miller <millerr@fairfax-emh1.army.mil>
Organization: SDCW
X-Mailer: Mozilla 3.0 (Win95; U; 16bit)
MIME-Version: 1.0
Subject: Multi-page report problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 28
Message-ID: <348_33B16E8F.4DF7@fairfax-emh1.army.mil>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7513
Article PK: 244571

I have a report that basically is displaying all pertinent information
for the system. It is currently a composite report made up of 3 reports
(1 for each page). There are several memo size fields, and depending on
certain criteria, some fields do not apply at times. I slide the data
for each page to take out blanks, but sometimes have pages with almost
nothing on them. Other times, the pages are overflowing. I want to
make this one big report where everything will be able to slide up to
eliminate excessive blank space. I have worked on putting everything
from all three reports in the detail section of one report and always
get the message "Height of bands exceeds page, increase paper size".
The message is merely annoying, but the report prints right to the edge
of the footer, then repeats the last line from one page at the top of
the next page(it's breaking in a memo field). Is there a more graceful
way of doing this or is there a way I can change the margins or footers
to stop this?

Thanks in advance,
Rosemary Miller
Software Development Center - Washington


Eva Maciasz Posted on 1997-10-02 04:19:59.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 02 Oct 1997 00:19:59 -0400
From: Eva Maciasz <emacia@po-box.mcgill.ca>
Reply-To: emacia@po-box.mcgill.ca
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: Multi-page report problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 20
Message-ID: <348_343320EF.52AE@po-box.mcgill.ca>
References: <348_33B16E8F.4DF7@fairfax-emh1.army.mil>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7445
Article PK: 244501


Rosemary Miller wrote:
(...)
> the next page(it's breaking in a memo field). Is there a more graceful
> way of doing this or is there a way I can change the margins or footers
> to stop this?
>

I would suggest that for each nested report you would do the following:
1. Create the report as free form, that will allow you to set up the
fields
properties' in detailed lines as "movable" and "resizable";
(check Properties/Position dialog box);
2. Setup all fields in the detailed line (each row) to "slide all above"
3. Setup the detailed line as "autosize hight" and the default length
to 1;

That should avoid the problem with blank spaces - at least it works.
Hope this will help you.
Greetings,
Eva Maciasz,
Systems Dept.


Terry Dykstra Posted on 1997-06-27 17:37:59.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Multi-page report problem
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Fri, 27 Jun 1997 13:37:59 -0400
Lines: 42
Message-ID: <348_01bc8329$5d184260$8366e4cf@terrywork.cfol.ab.ca>
References: <348_33B16E8F.4DF7@fairfax-emh1.army.mil>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7511
Article PK: 244565

I'm not sure if this will help, but on the individual reports make the
columns that you want to autoseize very small (height only). Columns will
increase in size, but not decrease. If you want to, you can even shrink
the detail band as much as possible (but not to a height of zero).
Page & Group footers and headers do not support the autoseize feature,
unfortunately.

Terry Dykstra (TeamPS)

Rosemary Miller <millerr@fairfax-emh1.army.mil> wrote in article
<33B16E8F.4DF7@fairfax-emh1.army.mil>...
> I have a report that basically is displaying all pertinent information
> for the system. It is currently a composite report made up of 3 reports
> (1 for each page). There are several memo size fields, and depending on
> certain criteria, some fields do not apply at times. I slide the data
> for each page to take out blanks, but sometimes have pages with almost
> nothing on them. Other times, the pages are overflowing. I want to
> make this one big report where everything will be able to slide up to
> eliminate excessive blank space. I have worked on putting everything
> from all three reports in the detail section of one report and always
> get the message "Height of bands exceeds page, increase paper size".
> The message is merely annoying, but the report prints right to the edge
> of the footer, then repeats the last line from one page at the top of
> the next page(it's breaking in a memo field). Is there a more graceful
> way of doing this or is there a way I can change the margins or footers
> to stop this?
>
> Thanks in advance,
> Rosemary Miller
> Software Development Center - Washington
>


Kathy Mouser Posted on 1997-06-25 21:35:55.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 25 Jun 1997 16:35:55 -0500
From: Kathy Mouser <kathy@aol.com>
Reply-To: kathy@aol.com
Organization: ERMI Environmental Laboratories
X-Mailer: Mozilla 3.01Gold (Win95; I)
MIME-Version: 1.0
Subject: Re: Multi-page report problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 51
Message-ID: <348_33B18F3B.3888@aol.com>
References: <348_33B16E8F.4DF7@fairfax-emh1.army.mil>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7512
Article PK: 244568


Rosemary Miller wrote:
>
> I have a report that basically is displaying all pertinent information
> for the system. It is currently a composite report made up of 3 reports
> (1 for each page). There are several memo size fields, and depending on
> certain criteria, some fields do not apply at times. I slide the data
> for each page to take out blanks, but sometimes have pages with almost
> nothing on them. Other times, the pages are overflowing. I want to
> make this one big report where everything will be able to slide up to
> eliminate excessive blank space. I have worked on putting everything
> from all three reports in the detail section of one report and always
> get the message "Height of bands exceeds page, increase paper size".
> The message is merely annoying, but the report prints right to the edge
> of the footer, then repeats the last line from one page at the top of
> the next page(it's breaking in a memo field). Is there a more graceful
> way of doing this or is there a way I can change the margins or footers
> to stop this?
>
> Thanks in advance,
> Rosemary Miller
> Software Development Center - Washington

No solutions for you, but I am having a similar problem. I have reports
that are composite reports, containing fields of info in the group
header band, other reports nested throughout, most of them in the detail
band, and then in the trailer band for the group, I have some text
fields and computed fields. Depending on the info retrieved when I run
the report, the trailer band stuff just doesn't show up!! One of the
items in the trailer band is a computed field with a retrieval argument
that prompts for information at the time the report is run, and even
though you enter that info, it doesn't appear in the report. Parts of
the trailer band show up, but I'd say better than 90% of the time, the
detail band info is omitted.

Any thoughts??

Thanks in advance!
Kathy Mouser
ERMI Environmental Laboratories