Hi all,
I have the following code in a file.
The problem is that the command
BY JOURNALTYPEDESC NOPRINT
cause a cgi time out.
Without this line the file works great.
Here is the code:
TABLE FILE dwh_journals
PRINT
L_LINE_DESCRIPTION AS '????? ????'
COMPUTE POSTED_DATE/DMYY=HDATE(H_POSTED_DATE,'YYMD');AS '????? ?????'
-*COMPUTE EFFECTIVE_DATE/DMYY=HDATE(L_EFFECTIVE_DATE,'YYMD'); AS '????? ???????'
L_EFFECTIVE_DATE AS '????? ???????'
L_ACCOUNTED_DR/D20- AS '???? ????'
L_ACCOUNTED_CR/D20- AS '???? ?????'
COMPUTE TOT_ACCOUNTED/D20-=L_ACCOUNTED_DR-L_ACCOUNTED_CR;AS '??"?'
COMPUTE JOURNALTYPE/A10= IF JOURNALTYPEID EQ 'A' THEN 'BITZUA'
ELSE IF JOURNALTYPEID EQ 'B' THEN 'TAKZIV'
ELSE 'SHIRIUN';NOPRINT
COMPUTE JOURNALDESC/A60='<A id=' | JOURNALTYPEID |' NAME="'||JOURNALTYPE ||'">' ||JOURNALTYPEDESC|| '</a>'; NOPRINT
COMPUTE TOP/A150='<a HREF="#TOP" TARGET="_self"><font class=TitleDataFont><BR>' |
'<B>???? ?????? ?????</B></a></font>';NOPRINT
COMPUTE HR/A4='<HR>';NOPRINT
BY JOURNALTYPEDESC NOPRINT --here is the problem
BY JOURNALDESC NOPRINT
SUBHEAD
"<JOURNALDESC"
WHERE YearId EQ '2005'
AND ERP_CODE EQ 'USD'
AND CompanyId EQ '01'
AND SactivityId EQ '303179371'
ON JOURNALDESC SUBFOOT
"<TOP"
"<HR"
-*ON JOURNALTYPEDESC SUB-TOTALS AS '??"?'
ON TABLE NOTOTAL
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,FONT='ARIAL',SIZE=9, $
TYPE=TITLE, BACKCOLOR=RGB(40 1 152), STYLE=BOLD,
COLOR=RGB(255 255 255), JUSTIFY=RIGHT , $
TYPE=HEADING, BACKCOLOR=RGB(65 115 173), COLOR=WHITE,
STYLE=BOLD,$
TYPE=DATA, JUSTIFY=RIGHT, $
TYPE=DATA, COLUMN=L_LINE_DESCRIPTION,COLOR=NAVY, $
ENDSTYLE
END
I'm using SQL Server 2k, wf client 4.36
and WF SERVER 5.16 ON WIN 2000.
aNY HELP IS APPRECIATED,
oz
I have the following code in a file.
The problem is that the command
BY JOURNALTYPEDESC NOPRINT
cause a cgi time out.
Without this line the file works great.
Here is the code:
TABLE FILE dwh_journals
L_LINE_DESCRIPTION AS '????? ????'
COMPUTE POSTED_DATE/DMYY=HDATE(H_POSTED_DATE,'YYMD');AS '????? ?????'
-*COMPUTE EFFECTIVE_DATE/DMYY=HDATE(L_EFFECTIVE_DATE,'YYMD'); AS '????? ???????'
L_EFFECTIVE_DATE AS '????? ???????'
L_ACCOUNTED_DR/D20- AS '???? ????'
L_ACCOUNTED_CR/D20- AS '???? ?????'
COMPUTE TOT_ACCOUNTED/D20-=L_ACCOUNTED_DR-L_ACCOUNTED_CR;AS '??"?'
COMPUTE JOURNALTYPE/A10= IF JOURNALTYPEID EQ 'A' THEN 'BITZUA'
ELSE IF JOURNALTYPEID EQ 'B' THEN 'TAKZIV'
ELSE 'SHIRIUN';NOPRINT
COMPUTE JOURNALDESC/A60='<A id=' | JOURNALTYPEID |' NAME="'||JOURNALTYPE ||'">' ||JOURNALTYPEDESC|| '</a>'; NOPRINT
COMPUTE TOP/A150='<a HREF="#TOP" TARGET="_self"><font class=TitleDataFont><BR>' |
'<B>???? ?????? ?????</B></a></font>';NOPRINT
COMPUTE HR/A4='<HR>';NOPRINT
BY JOURNALTYPEDESC NOPRINT --here is the problem
BY JOURNALDESC NOPRINT
SUBHEAD
"<JOURNALDESC"
WHERE YearId EQ '2005'
AND ERP_CODE EQ 'USD'
AND CompanyId EQ '01'
AND SactivityId EQ '303179371'
ON JOURNALDESC SUBFOOT
"<TOP"
"<HR"
-*ON JOURNALTYPEDESC SUB-TOTALS AS '??"?'
ON TABLE NOTOTAL
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,FONT='ARIAL',SIZE=9, $
TYPE=TITLE, BACKCOLOR=RGB(40 1 152), STYLE=BOLD,
COLOR=RGB(255 255 255), JUSTIFY=RIGHT , $
TYPE=HEADING, BACKCOLOR=RGB(65 115 173), COLOR=WHITE,
STYLE=BOLD,$
TYPE=DATA, JUSTIFY=RIGHT, $
TYPE=DATA, COLUMN=L_LINE_DESCRIPTION,COLOR=NAVY, $
ENDSTYLE
END
I'm using SQL Server 2k, wf client 4.36
and WF SERVER 5.16 ON WIN 2000.
aNY HELP IS APPRECIATED,
oz