Consultor Eletrônico

Status: Unverified

GOAL:

How modify a report built with the webspeed wizard to include a dynamic filter?

GOAL:

How to add a validation in a report web object ?

FACT(s) (Environment):

WebSpeed 3.x

FIX:

Report web object uses a dynamic query to retrive data from database.
Since the CAN-FIND function is not allowed in Dynamic queries, the query itself must be build to include the validation by adding new buffers and where clauses.
Example: want to add validation for customer number from order table.
Initially query is built as:
setBuffers('Order').
setQueryWhere('FOR EACH Order NO-LOCK By ordernum INDEXED-REPOSITION').
Adding the validation for custNum field, the query becames:
setBuffers('Order,Customer').
setQueryWhere('FOR EACH Order NO-LOCK, EACH customer WHERE customer.custNum = order.custNum By ordernum INDEXED-REPOSITION').