And when you do, edit PORPT.INI and comment out this DATAPIPE line:

'************** Object id = PO3020 ******************
' ----- Print Purchase Order Form
[POPOR01]
'type=DATAPIPE

And when you do, edit PORPT.INI and comment out this DATAPIPE line:

'************** Object id = PO3020 ******************
' ----- Print Purchase Order Form
[POPOR01]
'type=DATAPIPE

Thanks for the immediate response.

However, it still doesn't work. The report is blank. I kind of followed your previous suggestion from here.

You suggested that i use POPOR04.rpt, that means I have to reformat the whole report to match POPOR01.

I completely followed your instruction but still doesn't work. I hope I could fix this anytime soon.

Crystal Reports just so complicated for me. Some fields are checked (green) on the field explorer but I don't see them on the report design.

Anyway, thanks for your help.

Regards,

Giddy

Hi Jay

I tried like you mentioned above but I failed. Can you assist further please.

1. Using a non-data piped form, like POPOR04 as suggested by Jay, change the selection criteria to allow completed POs.

2.  Comment out that datapipe line if found in your porpt.ini (May no longer need to do this)

3.  When you go to print, check the box “Use custom form”.  That tells the program to ignore the internal selection formula and use yours instead. Otherwise, Sage is already excluding completed POs in the selection string it sends to Crystal.