I need to get rido of some of the records through the Stored Procedure before they even hit the report. They are in the top of the list and at the very bottom. I need to remove 000000 and the INV , R13 , ZRW. Anything that starts with a 4 can stay. All others need to go.
Is there a simple way to only show those values that start with a "4" on the field.
The records come from two different databases. One field Prod_cat and another comes from Prd_gltype and they are dumped into a temp table and then reported on in Crystal Reports. I do not know if that matters.