Placing of a column to extreme end

December 14, 2007, 06:37 AM

Deepa497

Hi,

In the following code of a report I need to place the TEMP in the end in the output:

TABLE FILE PD_UTILITY_CONSUMPTION
SUM
TEMP AS 'Store Count*'
BY T1 NOPRINT AS ''
BY MO NOPRINT
BY YR NOPRINT
BY STPROV
SUM
MOUSE AS 'MTD'
MOYTDUSEQ AS 'YTD '
BY T1 NOPRINT AS ''
BY MO NOPRINT
BY YR NOPRINT
BY STPROV
ACROSS Util_Type
.......

Becoz of ACROSS Util_Type I am not able to to place TEMP in the end.

Please suggest!!!

Thanks
Deep

December 14, 2007, 07:33 AM

GamP

My suggestion:

TABLE FILE PD_UTILITY_CONSUMPTION
SUM TEMP NOPRINT
BY T1 NOPRINT AS ''
BY MO NOPRINT
BY YR NOPRINT
BY STPROV
SUM
MOUSE AS 'MTD'
MOYTDUSEQ AS 'YTD '
BY T1 NOPRINT AS ''
BY MO NOPRINT
BY YR NOPRINT
BY STPROV
ACROSS Util_Type 
COMPUTE FIELD=TEMP; AS 'Store Count*'

Be sure to give FIELD the same format as TEMP has.
Hope this helps.....

December 14, 2007, 07:34 AM

FrankDutch

Can you try to rebuild your request upon the CAR or MOVIE data you get with the software.
It's more easy for us to nderstand what yu want.

In this case what is TEMP? is it the total?

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

December 15, 2007, 01:30 AM

Deepa497

Hi,

Thanks for the help.
It helped me. TEMP is a field where we are counting the values.

Thanks
Deep

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988