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.

Summery Functions In Crosstab Reports

3 posts in PB Infomaker Report Writer Last posting was on 1998-04-23 02:45:45.0Z
defaultuser Posted on 1998-04-14 23:18:03.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 14 Apr 1998 16:18:03 -0700
From: defaultuser@domain.com
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Summery Functions In Crosstab Reports
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 20
Message-ID: <348_3533EEAB.410EBA8F@domain.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7148
Article PK: 243179

I am trying to create a crosstab query that shows not only the value
from the crosstab, but I need to show distinct totals as well. In the
detail section, I created a column that does a crosstabsum(1). I named
it 'tot1', then I created another column that looks like the following:
(mpin / tot1) where mpin is the value calculated in the crosstab. I
formated that field to Percent. That worked great, but for the summary,
it prints a single value in all of the crosstab columns. How can I
calculate the percent for each column for the crosstab summary.

Your help is greatly appreciated. And thanks again for the help with
the UNION query, it did not work for me, but I think it was because of
restrictions placed at the mainframe level.


DawnBrownEyes[TeamPS] Posted on 1998-04-20 15:40:32.0Z
Newsgroups: sybase.public.infomaker.general
From: "DawnBrownEyes[TeamPS]" <browneyd@kochind.com>
Subject: Re: Summery Functions In Crosstab Reports
Organization: TeamPS
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Mon, 20 Apr 1998 11:40:32 -0400
Lines: 27
Message-ID: <348_01bd6c7b$564fced0$3d18d192@kii-201520>
References: <348_3533EEAB.410EBA8F@domain.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7140
Article PK: 243171

If I understand you correctly, you would like to format the percent column.

To do this you would code: string(mpin/tot1,'#.##')+'%'
--
Dawn T Brown Eyes (TeamPS)

defaultuser@domain.com wrote in article <3533EEAB.410EBA8F@domain.com>...
> I am trying to create a crosstab query that shows not only the value
> from the crosstab, but I need to show distinct totals as well. In the
> detail section, I created a column that does a crosstabsum(1). I named
> it 'tot1', then I created another column that looks like the following:
> (mpin / tot1) where mpin is the value calculated in the crosstab. I
> formated that field to Percent. That worked great, but for the summary,
> it prints a single value in all of the crosstab columns. How can I
> calculate the percent for each column for the crosstab summary.
>
> Your help is greatly appreciated. And thanks again for the help with
> the UNION query, it did not work for me, but I think it was because of
> restrictions placed at the mainframe level.
>
>


defaultuser Posted on 1998-04-23 02:45:45.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 22 Apr 1998 19:45:45 -0700
From: defaultuser@domain.com
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
To: "DawnBrownEyes[TeamPS]" <browneyd@kochind.com>
Subject: Re: Summery Functions In Crosstab Reports
X-Priority: 3 (Normal)
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 40
Message-ID: <348_353EAB59.5D8FA948@domain.com>
References: <348_3533EEAB.410EBA8F@domain.com> <348_01bd6c7b$564fced0$3d18d192@kii-201520>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7129
Article PK: 243159

I appologize for not making my self more clear.  I know how to format the field, that is not what I am trying to do.  The summary prints the same percent value across all of the crosstab value columns.  How can I calculate the percent for each crosstab value column in the summary for example, for group 1?

DawnBrownEyes[TeamPS] wrote:

If I understand you correctly, you would like to format the percent column.

To do this you would code:  string(mpin/tot1,'#.##')+'%'
--
Dawn T Brown Eyes (TeamPS)

defaultuser@domain.com wrote in article <3533EEAB.410EBA8F@domain.com>...
> I am trying to create a crosstab query that shows not only the value
> from the crosstab, but I need to show distinct totals as well.  In the
> detail section, I created a column that does a crosstabsum(1).  I named
> it 'tot1', then I created another column that looks like the following:
> (mpin / tot1) where mpin is the value calculated in the crosstab.  I
> formated that field to Percent.  That worked great, but for the summary,
> it prints a single value in all of the crosstab columns.  How can I
> calculate the percent for each column for the crosstab summary.
>
> Your help is greatly appreciated.  And thanks again for the help with
> the UNION query, it did not work for me, but I think it was because of
> restrictions placed at the mainframe level.
>
>