Formula in Crystal 8.5 1

[cis12232004]

I have a report created in Crystal 8.5 and to be used with (in) Solomon 5.0. The report should list all P/Os with inventory items that are still outstanding. While I am able to generate results of only the inventory items with the outstanding items. The warehouse manager wants a report by open P/Os, that is, it would include inventory items with both outstanding and filled orders within that P/O. I went through Select Expert to generate the data set but my select statement is currently only displaying the outstaning items and not including the inventory items that are filled. Any suggestions on how I can write a query to give me the results I seek?

 

[synapsevampire]

Are you writing a query or using the Crystal GUI?

You'll either need a Solomon expert to respond, or post relevent information about the database.

Also post what you have in the record selection formula.

If you're only getting those rows with outstanding items, then of course you'll need to turn that off in the record selection formula.

-k

 

[cis12232004]

The query in the select expert is currently tied to the quantity open formula and is set to not equal to 0. When I tried to put in other criteria, such as the inventory ID or P/O number, I still only generate results that displays the open items only.

 

[Turkbear]

You are asking it to only show those with Quantity Open > 0,so thats all you will get.

If you want to add other criteria, use OR to give CR a choice as to what records to include..

Quantity Open > 0
OR
Inventory ID = 2345
OR
P/O number = '21'

will return all open , all where ID = 2345 and all where P/O = 21







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

The select expert isn't a query, it's a means for you to add filtering criteria, which hopefully will end up in the real query passed to the database. The query generated is under the Database->Show SQL Query.

Since you don't want to post what you tried nor answer questions, I'll leave this for another.

It's a shame, it seems like a simple fix.

-k

 

[lbass]

Remove the record selection criteria related to the open items, and instead create a formula {@open}:

if {table.qtyopen} > 0 then 1

Insert a group on {table.PO#}, if you don't have one, and then go to report->edit selection criteria->GROUP and enter:

sum({@open},{tabe.PO#}) > 0

This should return POs with open items, but also show those no longer open. Once you have used group selection, you may need to use running totals to do calculations across groups, since non-group selected records would contribute to inserted summaries.

-LB

 

[cis12232004]

I don't know why synapsevampire would think I didn't want to share any information. What was asked of me I submitted. LBass I will try your suggestion and let you know if any problems. Thanks for your help.

 

[synapsevampire]

Not submitted:

"Are you writing a query or using the Crystal GUI?"
Crystal can use modified queries in the database->show sql query, you resonded with what you're putting in the filtering criteria, it's still unclear what your datasource is.

"Also post what you have in the record selection formula."
Didn't do this, instead you tried to describe it using text.

I try to help lots of poeple out here, but when people won't respond then I tend to give up and try to help those that are providing techincal information, it's nothing personal, I just have limited time available.

-k

 

[cis12232004]

LBass it worked like a charm first time. Thanks a mil.

 

[cis12232004]

I have a quick question. I created a report in Crystal 8.5 using an existing Solomon 5.5 report as a template. When I created a did a sort that would pull out all items for a particular warehouse into a new report. My question is, when I set-up the new report on Solomon, will it still retain that sort criteria?