tallam
Active Member
I have designed a columnar report,which had activity center on levelbreak header and in detailsection i have order number-cost center(This cost center value is an sub string-last five characters of omcu,and 'donot' exist in database)-and order type.and my report displays as follows
Activity center-A
--------------------------
DOCO - COSTCENTER - ordertype
10 - 20398 - A
20 20398 - A
30 - 20398 - B
40 - 11243 - A
50 - 11243 - A
now the client need to filter on cost center i.e
Activity center-A COSTCENTER-20398
--------------------------
DOCO - COSTCENTER - ordertype
10 - 20398 - A
20 20398 - A
Activity center-A COSTCENTER-11243
--------------------------
DOCO - COSTCENTER - ordertype
40 - 11243 - A
50 - 11243 - A
can we do filtering on cost center which is a substring output of omcu
Tallam
Activity center-A
--------------------------
DOCO - COSTCENTER - ordertype
10 - 20398 - A
20 20398 - A
30 - 20398 - B
40 - 11243 - A
50 - 11243 - A
now the client need to filter on cost center i.e
Activity center-A COSTCENTER-20398
--------------------------
DOCO - COSTCENTER - ordertype
10 - 20398 - A
20 20398 - A
Activity center-A COSTCENTER-11243
--------------------------
DOCO - COSTCENTER - ordertype
40 - 11243 - A
50 - 11243 - A
can we do filtering on cost center which is a substring output of omcu
Tallam