Hello,
I have Month and Year columns with formats YY and Mt in the AHTML report output. When I try to filter any one of these columns, I get only an empty report instead of showing the filtered output. Can someone suggest me a solution for this issue?

Thanks,
Suji

This message has been edited. Last edited by: Kerry,

Hi Suji,

From our technicals: the example below should work. It makes a Mt field to filter on. This is tested in 7703 hotfix where it worked.

Please make sure you’re using a supported browser, and there are no java script errors (see bottom left of the browser, on the status line)

If all else fails, please open a case with Customer Support Services for assistance, either call 1-800-736-6130, or access online at InfoResponse.

DEFINE FILE CAR
MYDATE/HYYMDS WITH COUNTRY=
IF COUNTRY EQ 'ENGLAND'   THEN HINPUT(20,'20080101010101000001',10,MYDATE) ELSE
IF COUNTRY EQ 'FRANCE'    THEN HINPUT(20,'20080202020202000001',10,MYDATE) ELSE
IF COUNTRY EQ 'ITALY'     THEN HINPUT(20,'20080303030303000001',10,MYDATE) ELSE
IF COUNTRY EQ 'JAPAN'     THEN HINPUT(20,'20080404040404000001',10,MYDATE) ELSE
IF COUNTRY EQ 'W GERMANY' THEN HINPUT(20,'20080505050505000001',10,MYDATE) ELSE
HINPUT(20,'20080606060606100001',10,MYDATE);
YY_DATE/YY=HDATE(MYDATE, 'YYMD');
MT_DATE/Mt=HDATE(MYDATE, 'YYMD');
END

TABLE FILE CAR
PRINT YY_DATE MT_DATE
BY COUNTRY
ON TABLE PCHOLD FORMAT AHTML
ON TABLE NOTOTAL
END

Cheers,

Kerry