newbie Q: Formula for specified parameter value

[tthai826]

I'm trying to basicly get query out that will search SERTRK_01 for Knumbers (boms) that don't have the serial checked out. so I think it should be true or false. also display the part number and description. When i just setup the regular value, it displays all partnumbers showing Yes and no, but i'm just looking for the No, and also only in the Knumbers not all the part numbers.

Any help?

 

[synapsevampire]

Post Crystal version, database used, example data and expected output.

Most people here don't hnow what boms or knumbes are.

You might create a record selection formula, such as:

(
{table.field} like "*K*"
)
and
(
{table.serial} = 0 // or false or .f. or whatever
)

Without specifics it's difficult to assist.

-k

 

[tthai826]

CR 8.5, database used, index, part master.

expect output is False (no s/n control sertk_01)
only scanning completed boms (k numbers)

Not sure if all that came out right, i'm still REALLY new to all of this. My apologies.

 

[synapsevampire]

Example data woulkd mean posting examples of the data, such as:

serial partnumber
1234K8674 12345
1234Z8674 12345

Expected output:

serial partnumber
1234K8674 12345

becase it's the only one with a K.

Something like that, anyway, show the fields used, what's in them, and what you want.

-k

 

[tthai826]

Example Data

S/N Control Partnumber
N K000001

Output Data

S/N Control Partnumber
N K000002

Basicly searching for partnumbers in the system that are
finish goods, bill of materials that have the sn control checked off.

 

[synapsevampire]

How could your output be something other than what's in your sample data?

Many here have answered numerous quetsion for you Raj, and still you don't post the basics, never mark anyone's post as helpful, and disregard questions asked, or provide the least possible eoofrt.

Please understand that you've a plethora of great resources here, all of whose time is generously donated to you, so please try to help out by providing technical information in your posts, there's a language barrier to begin with, so you're better served stating facts, not describing something with text.

Try:

Since now you show that S/N contains "N", try Report->Record Selection Formula->Record:

{table.sn} = "N"

-k

 

[tthai826]

alright, sorry for the misterms. I'll try and put this out as best as I can.

The data I want to extract comes from

{Part Master.SERTRK_01}
{Part Master.PRTNUM_01}
{Part Master.PMDES1_01}
{Part Master.PMDES2_01}

In SERTRK I want only the values that are "N"
in PartNumbers I only want the ones that begin with "K"

So the output would look like this.

SERTRK_01 PRTNUM_01 PMDES1_01
N K001232 example


Did I explain it correctly this time? If not my apologies.

 

[synapsevampire]

Should have went with my first post, it was close:

Report->Edit Selection Formula->Record:

(
left({Part Master.PRTNUM_01},1) = "K"
)
and
(
{Part Master.SERTRK_01} = "N"
)

-k

 

[synapsevampire]

Sorry about the rant, I meant part of that for another poster.

-k