AnsweredAssumed Answered

ANYONE CAN HELP ME~

Question asked by ERIKCHAN on Feb 23, 2009
Latest reply on Feb 25, 2009 by comment_1

Title

ANYONE CAN HELP ME~

Post

I want to make a report to show in TABLEA FIELDA=RICK

HOW MANY RECORD FIELDB = In Progress

HOW MANY RECORD FIELDB = Begin

HOW MANY RECORD FIELDB = Finished

The report look like that

RICK

IN PROGRSS : XXX (TABLEA::FIELD_R1)

BEGIN : XXX (TABLEA::FIELD_R2)

FINISHED : XXX (TABLEA::FIELD_R3)

Below is my script...

Enter Find Mode []

Set Field [TABLEA::FIELDA; "RICK"]

Set Field [TABLEA::FIELDB; "In Progress"]

Perform Find []

insert Calculated Result [Select; TABLEA::FIELD_R1; Get ( FoundCount )]

New Record / Request

Enter Find Mode []

Set Field [TABLEA::FIELDA; "RICK"]

Set Field [TABLEA::FIELDB; "Begin"]

Perform Find []

insert Calculated Result [Select; TABLEA::FIELD_R2; Get ( FoundCount )]

New Record / Request

Enter Find Mode []

Set Field [TABLEA::FIELDA; "RICK"]

Set Field [TABLEA::FIELDB; "Finished"]

Perform Find []

insert Calculated Result [Select; TABLEA::FIELD_R3; Get ( FoundCount )]

Go to Layout ["Report" (TABLEA)]

 

Unlucky, The result cannot show correctly. Can anyone tell me how can I do?

I think my script have problems. But I don't know how can I do? Please Help~

Outcomes