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.

Top n graph

3 posts in PB Infomaker Report Writer Last posting was on 1999-02-10 19:03:44.0Z
Dave tR Williams Posted on 1999-02-01 17:45:34.0Z
Newsgroups: sybase.public.infomaker.general
Date: Mon, 01 Feb 1999 09:45:34 -0800
From: Dave tR Williams <davetr@Tek.com>
Reply-To: davetr@Tek.com
X-Mailer: Mozilla 4.05 [en]C-NECCK (WinNT; I)
MIME-Version: 1.0
Subject: Top n graph
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 13
Message-ID: <348_36B5E83E.7997F64D@Tek.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6590
Article PK: 241577

In Crystal Reports there is a graph that allows the user to pick the top
n items from the report results (my apologies for mentioning the 'other
reporting' :>} program). I have a stack bar report where it is
essential to choose the top n results using the combination of the
category plus the value (Y and X axis). Is there a way to do this in
Infomaker (I am now using version 6), or must this be built using SQL?
Thanks for any help/suggestions.
Dave "tR" Williams


Terry Dykstra Posted on 1999-02-10 19:03:44.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Top n graph
Date: Wed, 10 Feb 1999 12:03:44 -0700
Lines: 20
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_Lw486eSV#GA.310@forums.powersoft.com>
References: <348_36B5E83E.7997F64D@Tek.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6570
Article PK: 241556

Not easily. Take a look at doc-id 42340, which describes how to limit
reports, graphs to top-10 results. http://support.sybase.com/fd_search.html
If you are not registered with ECM, you will be prompted to do so. It's
free.

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

Dave tR Williams wrote in message <36B5E83E.7997F64D@Tek.com>...
>In Crystal Reports there is a graph that allows the user to pick the top
>n items from the report results (my apologies for mentioning the 'other
>reporting' :>} program). I have a stack bar report where it is
>essential to choose the top n results using the combination of the
>category plus the value (Y and X axis). Is there a way to do this in
>Infomaker (I am now using version 6), or must this be built using SQL?
>Thanks for any help/suggestions.
>Dave "tR" Williams
>


Terry Dykstra Posted on 1999-02-02 23:26:20.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Top n graph
Date: Tue, 2 Feb 1999 16:26:20 -0700
Lines: 20
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_JiXYtMwT#GA.205@forums.powersoft.com>
References: <348_36B5E83E.7997F64D@Tek.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6588
Article PK: 241573

Not easily. Take a look at doc-id 42340, which describes how to limit
reports, graphs to top-10 results. http://support.sybase.com/fd_search.html
If you are not registered with ECM, you will be prompted to do so. It's
free.

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

Dave tR Williams wrote in message <36B5E83E.7997F64D@Tek.com>...
>In Crystal Reports there is a graph that allows the user to pick the top
>n items from the report results (my apologies for mentioning the 'other
>reporting' :>} program). I have a stack bar report where it is
>essential to choose the top n results using the combination of the
>category plus the value (Y and X axis). Is there a way to do this in
>Infomaker (I am now using version 6), or must this be built using SQL?
>Thanks for any help/suggestions.
>Dave "tR" Williams
>