Solved

# Crystal report for previous entry

Posted on 2011-10-17
234 Views
I am trying to right a report from an existing one that tells me whether an ordered has been previously placed with a particular partno.

So the main report will then only display parts that have never been ordered before(first time orders).

Any suggestions will be greatly appreciated.

0
Question by:schraudog

LVL 100

Expert Comment

Is this just for display or are there summaries that need to be calculated?

I assume you are concerned with a particular customer has ordered before
One way
Group the report by customer
Group by the part ID or number

In the GROUP SELECT EXPERT
REPORT --> SELECT EPERT --> GROUP SELECTION
Count({PartNumberField}) = 1

mlmcc
0

Author Comment

I have Crystal reports 11.0 and can not find where to put:

In the GROUP SELECT EXPERT
REPORT --> SELECT EPERT --> GROUP SELECTION
Count({PartNumberField}) = 1

0

Author Comment

I am actually trying to find out if a particular part has ever been ordered. So if never been ordered I want to see it on the report.
0

Author Comment

The report will only have first time orders.
0

LVL 100

Expert Comment

Do you mean by any customer or is that by a given customer?

Do you want to see

Customer 1
Part 1
Part 3

Customer 2
Part 2
Part 3

ETC

or
Part 3

mlmcc
0

Author Comment

No. I want to see.

OrderNo, PartNo (If first time ordered) "Never ordered" else "Order History).
0

LVL 100

Expert Comment

Again is this by customer? A given order?

Is this what you want to see

Customer1
Order5
Part1     -  Never Ordered Before by Customer1
Part2     -  Ordered in Order4, Order3
Part5     -  Ordered in Order2, Order1
Part8     -  Never ordered before by customer 1

Customer2
Order8
Part3     -  Never Ordered Before by Customer2
Part5     -  Ordered in Order6, Order3
Part9     -  Never Ordered Before by Customer2
Part18   -  Ordered in Order2, Order5

The result you want and the table information you have will drive how the report is built and which tables are used and how they are linked together.

mlmcc

0

Author Comment

No, its not by customer. Its by Part. I just want a report that shows whether or not that part has ever been ordered.

0

LVL 100

Expert Comment

Then why did you state in your last comment about using an order number?

If you just want to list parts that have never been ordered
Link on the part number field
Set it as LEFT OUTER JOIN
Insert a group on the PartNumber
Suppress the detail section
Suppress the group footer
In the Section Expert
CLick the FORMULA BUTTON to the right of SUPPRESS
Not IsNull({OrderDetails.OrderDate})

That should show you all the parts that have never been ordered.

mlmcc
0

Author Comment

Getting closer, the reports seem to be hiding orders with history. So if the part is in an order that is currently active, it is coming up on the report. I want to make sure that the parts displayed have no history.
0

LVL 100

Expert Comment

Do you have 2 detail tables?

mlmcc
0

Author Comment

No just one order history table.
0

Author Comment

Is there a way to suppress a part from a main report if the subreport is blank?
0

LVL 100

Expert Comment

What subreport?

mlmcc
0

Author Comment

I am trying a different method. Created a subreport that will suppress if no previous order history. However, I would also like to suppress parts that have no previous order history (subreport).
0

LVL 100

Expert Comment

What was wrong with my method?

mlmcc
0

Author Comment

I was thrown a curveball. I was asked to use an existing document that has orders with certain parts shipped on a monthly basis. From this report, the user wants to know if this is the first time "a part" has been ordered. Hence my subreport.
0

LVL 100

Expert Comment

Try the method in the subreport

mlmcc
0

Author Comment

No working for me. Any other suggestions.
0

LVL 100

Expert Comment

mlmcc
0

Author Comment

I would rather not. Is there a way to exclude data from a main report if the subreport is blank or null?

I have the first report that has calculations, etc. So, if the partno has no prior order history the subreport will be blank. I would like to exclude that part number from the main report along with its numbers which add to the calculations.

Any suggestions?
0

LVL 100

Expert Comment

>>Is there a way to suppress a part from a main report if the subreport is blank?
You can suppress records based on the subreport however if you are using summaries the values will still be included in the report.

>>I have the first report that has calculations, etc. So, if the partno has no prior order history the subreport will be blank. I would like to exclude that part number from the main report along with its numbers which add to the calculations.

I am now confused.  You originally wanted to see if a part has never been ordered (subreport will be blank).  Now it seems you want to exclude those records from the report.

mlmcc
0

Accepted Solution

mlmcc,

I am all set. I had to take a different approach and use SQL to set the crystal report up. I appreciate all your help.
0

Author Closing Comment

I was able to figure out the problem.
0

## Featured Post

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Coâ€¦
How to increase the row limit in Jasper Server.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display lâ€¦
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filledâ€¦