Report filtering on custom variables

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
 

Chapulin

Active Member
As far as I know if it's not a custom table so it's not easy for you to keep in another field the five characters of the cost center separated from the other characters.. it's not possible to use a data selection based on the last five character. If they were the first five characters of the field you could try something like a "between - and" (Ej: CostCenter(29538) between "29538000000" and "29538ZZZZZZ").

You can solve the problem in a non performant way by Suppressing Section Write for those records that doesn't match with the CostCenter the user defines. But you will have to get all records from the DB and analize in Event Rules if each record is good or not..
I don't like this kind of solutions but sometimes it's the only way
frown.gif
 
Top