Need Help With a Formula

[MISFred]

Hello,

I'm a novice with Crystal Reports 8.5 but fighting to learn more everyday. Here's my situation

I have a simple report that lists part_id's, PO #, QTY's etc. I want to make a formula so that everytime in the report it will add a '*' to a column to give a heads-up to a Sales Admin that a current part is in an Inspection area.

I created a new formula called INSP, here is my code
if {PART_LOCATION.LOCATION_ID} = 'INSP' then '*'

So basically it will show a '*' in the column if the part is in inspection, else it will not.

Now the kicker, when I click in the selection expert and click "Show Formulas" I see PART_LOCATION.LOCATION_ID = "INSP" My question is why? This should be tied to the @INSP variable. And when I remove this from the report outputs different data.

Maybe I'm not understanding something here.

Thanks in advance.
- Fred

 

[synapsevampire]

The select expert has nothing to do with your formula if you're simply trying to identify certain parts.

The select expert formula you mention would return ONLY rows where that condition exists, which probably isn't correct or why would you need to distinguish them with a *?

Just place the @insp formula on your report.

-k