I have ACROSS and BY fields together like in below code. I have used SEQUENCE to wrap 'CURR YTD UNITS'. But when I use the same for 'TOT CURR YTD UNITS' I am getting error. Using commas won't help either. Any idea on this is greatly apriciated.

TABLE FILE CAR
SUM
CURYTDQTY AS 'CURR, YTD ,UNITS'
PREVYTDQTY AS 'PREV, YTD ,UNITS'
ACROSS T171T_BZTXT AS ' '
TOTCURQTY AS 'TOT CURR ,YTD UNITS'
TOTPREVDTY AS 'TOT PREV ,YTD UNITS'
COMPUTE UNITDIFF/D15 = (TOTCURQTY - TOTPREVDTY); AS 'UNIT ,DIFFERENCE'
BY T179T_VTEXT AS ' '


Thanks,
Dayakar.

The column names are CURYTDQTY and TOTCURQTY. 'CURR, YTD ,UNITS' and 'TOT CURR ,YTD UNITS' are column titles. Use the column names in the style-sheet.

quote:

OTCURQTY

I have used the column names in my style sheet. For CURYTDQTY the SEQUENSE is working fine but when I am using the SEQUENSE for TOTCURQTY I am getting error.

"But when I use the same for 'TOT CURR YTD UNITS' I am getting error. Using commas won't help either." - this suggested to me that you were using the column titles in your stylesheet.

Can you post the syntax of your stylesheet?

What the error says?

Took a while to get back to this as other bugs took priority.
I tried this, but consistently receive
this error:
"Unknown error occurred.
Agent on reporting server EDASERVE may have crashed.
Please investigate reporting server log."

Here is the style sheet that I am using below.
The error is '
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
PAGESIZE='LETTER',
ORIENTATION=LANDSCAPE,
LEFTMARGIN=0.2, RIGHTMARGIN=0.2,
$
TYPE=REPORT,
COLUMN=CURQTYSSQ,
SEQUENCE=99,
$
TYPE=REPORT,
COLUMN=CURQTYSSQ,
SEQUENCE=99,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=6,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=ROWTOTAL(1),
STYLE=BOLD,
$
TYPE=DATA,
COLUMN=ROWTOTAL(2),
STYLE=BOLD,
$
TYPE=TITLE,
SIZE=7,
JUSTIFY=CENTER,
$
TYPE=REPORT,
LEFTGAP=0.02,
RIGHTGAP=0.02,
$
TYPE=TITLE,
COLUMN=ROWTOTAL(1),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=ROWTOTAL(2),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=7,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=7,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=7,
FONT='ARIAL',
STYLE=BOLD+UNDERLINE,
$
TYPE=ACROSSVALUE,
ACROSS=1,
SIZE=7,
STYLE=BOLD+UNDERLINE,
JUSTIFY=LEFT,
WRAP=0.5,
$
TYPE=ACROSSVALUE,
COLUMN=ROWTOTAL(1),
STYLE=BOLD,
WRAP=0.5,
$
TYPE=ACROSSTITLE,
STYLE=BOLD+UNDERLINE,
ACROSS=1,
JUSTIFY=LEFT,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=0.78889,
$
ENDSTYLE
END

I am sorry the above style sheet is working fine. But I am getting the mentioned error when I am adding the below code to the style sheet.

TYPE=REPORT,
COLUMN=CURQTYSSQ2,
SEQUENCE=99,
$
TYPE=REPORT,
COLUMN=PREVQTYSSQ2,
SEQUENCE=99,
$
TYPE=REPORT,
COLUMN=UNITDIFF,
SEQUENCE=99,
$

Have you tried using sequence 97, 98 and 99?

Yes, I tried. Still I am getting the same error message

Here's what I would do:

1) Remove all styling and run the program as HTML
2) If that works without a problem, add the SEQUENCE commands, keep the report as HTML
3) If that works, change the format to PDF
4) If that works, start adding the styling - one at a time, until the error occurs

Thanks Francis for your time.
It was working fine till HTML. When I convert it to PDF again it is coming in one line instead of WRAPPING.
I can not use HTML as it can not print in 1 page. I am making this to fit everything in 1 page.

Thanks,
Dayakar.