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.

Group/Summary Printing Problem

2 posts in PB Infomaker Report Writer Last posting was on 1999-01-22 02:42:53.0Z
Kent G. Klingler Posted on 1999-01-20 18:12:53.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 20 Jan 1999 11:12:53 -0700
From: "Kent G. Klingler" <nospam@inel.gov>
X-Mailer: Mozilla 4.06 [en] (WinNT; U)
MIME-Version: 1.0
Subject: Group/Summary Printing Problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 14
Message-ID: <348_36A61CA5.AC05131C@inel.gov>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6610
Article PK: 241596

I have set a filter on the data so if certain fields are null they are
not reported (previewed/printed). If there are no detail rows because
of the filter the group and summary bands do not print. I still want to
print all the bands even if there is no detail for the group.
Essentially, if a salesman has no sales for the month I still want to
see a Total Sales = $0. Setting a computed field in the detail band to
"No Activity" base on rowcount(), or something similar to this, does
nothing.

Any suggestions?


Terry Dykstra (TeamPS) Posted on 1999-01-22 02:42:53.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra (TeamPS)" <dont_spam_me_tdykstra@cfol.ab.ca>
Subject: Re: Group/Summary Printing Problem
Date: Thu, 21 Jan 1999 19:42:53 -0700
Lines: 25
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_2ZY#1HbR#GA.189@forums.powersoft.com>
References: <348_36A61CA5.AC05131C@inel.gov>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6607
Article PK: 241592

I don't think this is possible. Group bands are tied in to the data in the
detail band. When you filter and take rows out of the primary buffer, there
is nothing left.
Instead of filtering out rows where there are no sales, you might want to
make all columns invisible using an expression.

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

Kent G. Klingler wrote in message <36A61CA5.AC05131C@inel.gov>...
>I have set a filter on the data so if certain fields are null they are
>not reported (previewed/printed). If there are no detail rows because
>of the filter the group and summary bands do not print. I still want to
>print all the bands even if there is no detail for the group.
>Essentially, if a salesman has no sales for the month I still want to
>see a Total Sales = $0. Setting a computed field in the detail band to
>"No Activity" base on rowcount(), or something similar to this, does
>nothing.
>
>Any suggestions?
>
>
>