Select Expert - Expression Question

[Former Member]

I know the answer is right there. Im just missing it. So I need a set of outside eyes.

Im building a report for Stock reporting inventory levels. so far everything on the report works. Ive got it so it only report inventory levels that are below predetermined on hand quantities. But it does that for part that I make AND parts that I buy. I want to have 2 different reports - 1 for make and 1 for buy.

the thing I can figure out is how I can build the statement to compare words. I hit select expert then hit the new button. I select the field: {IM1_InventoryMasterfile.ProcureTypeBuyMakeSub} = what? What do I put on the other side of equals for it to know?

Whenever I put this in the select exeprt and get a drop down menu I can select "equal to" then Im prompted to sign into my company which I do then the next drop down box appears but its empty.

Sorry for the newb question. Thanks in advance for looking at this.

[Former Member · Accepted solution]

> I want to have 2 different reports - 1 for make and 1 for buy.

>

> the thing I can figure out is how I can build the statement to compare words. I hit select expert then hit the new button. I select the field: {IM1_InventoryMasterfile.ProcureTypeBuyMakeSub} = what? What do I put on the other side of equals for it to know?

What is it that tells you if is is a part you make or a part you buy? If it is a word in the text of the above field then you can use like rather than equal, something like

like "* make *" would give you evey record with the word make with spaces on either side in it

And like "* buy *" would give you everything with the word buy ith spaces on either side in it

"* make" will give you everything ending with make and a space in front of it.

The * is the wild card search character.

[Former Member · Accepted solution]

So

and and

and

{IM1_InventoryMasterfile.ProcureTypeBuyMakeSub} like "buy"

?

[Former Member · Accepted solution]

Don't forget the astricks.

Like "*buy*"

. The astricks allow you to search for data containing the word buy

Edited by: DebiHerbert on Jan 31, 2011 3:55 PM

[Former Member · Accepted solution]

Slapped that string in - now my report is blank. So Im guessing I need to figure out what to compar the string since its obviously not a word. Im using Crystal with MAS and when I set up a part number, one of the things it ask me is "Procurement Type" and the drop down box has 3 types - Buy, Make, Subcontract. Im not sure if these types correlate to a word or a number in the code though. Wonder if I can look at this somehow?

[former_member11696 · Accepted solution]

Hello,

MAS is a Sage product which is an OEM partner of ours. You may want to ask Sage for more info on those fields and what there values means. And they will know the database you are reporting off of and help you with your report design.

Or just drop the fields into your report and see what they return. right clicking on the field wil allow you to browse the data.

Thank you

Don

[Former Member · Accepted solution]

As Don said, you need to look at the data and find the indicators for bought vs manufactured, or talk to the owner/designer of the database.

Edited by: DebiHerbert on Feb 1, 2011 10:25 AM

[Former Member · Accepted solution]

if you are using a like statement in your record selection it doesnt work like crystal you need

where like ''&buy&''

[Former Member]

im sure the ON HAND gets subtracted from MAKE and BUY?

1- are the MAKE and BUY in the same tables?

2- is there an indicator on what triggers MAKE and BUY? ( a flag of somesort, NULL FIELD???)

i would use one report.

insert a section below what is MAKE-

have another section for BUY

place the MAKE INFORMATION in the MAKE GROUP and the same for BUY in the BUY GROUP

then create a parameter to use to retrieve the information. - let me know and well continue.

[Former Member]

I figured it out. It was right there. The parameter is -

{IM1_InventoryMasterfile.ProcureTypeBuyMakeSub} = "B"

Buy = B

Make = M

I knew it was right there. Too bad it took me so long.