?
Solved

Crystal Reprots Formula help

Posted on 2011-10-12
5
Medium Priority
?
262 Views
Last Modified: 2012-05-12
I have a report were I want to show a warning when an order is fulfilled from 2 or more warehouses

The order looks like this

WHSE     ITEM
00           1000
00           5000
01           4000

The above order is fulfilled from two warehouses. Now I need to count from how many warehouses the order is fulfilled and if > 1 I want to show the warning.

I have already tried grouping and counting the records and can't make it work.

Can someone help me?
0
Comment
Question by:Gerhardpet
  • 3
  • 2
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 36958882
I assume you have a group on the order number.  Try a formula like

If DIstinctCOunt({WarehouseField},{OrderNumberFiled}) > 1 then
    "WARNING MESSAGE"
Else
    ""

mlmcc
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 36958965
In the report I do not print the header of the order so I do not group on order number. I do group on items.

Will that work with your formula. I'm not in the office to try but will later on.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 36959033
It will work if an Item is shipped from 2 warehouses.

Are you printing 1 order at a time?  If so then just drop the group field

If DIstinctCOunt({WarehouseField}) > 1 then
    "WARNING MESSAGE"
Else
    ""

mlmcc
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 36959042
Yes 1 order at the time. I will try your formula.
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 36959489
mlmcc,
Your suggesting works great! Thank you!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question