Using Crystal Reports 7, I've been

[lous]

Using Crystal Reports 7, I've been asked to write a report that checks to see whether or not more than one internal ID has been assigned to any one stock item by our system.

For example, if an item is received twice at different times, there will be two different internal IDs for it and they need to be combined into one manually later.

The report needs to list the items that have more than one internal ID assigned to them and hide everything else for a range of locations (which I understand how to set up already).

I have tried using the count function to find out how many IDs were assigned to a stock item, but it's not working properly.

This will be a very basic report, nothing fancy, I just can't get the logic to work. I'm very new to Crystal Reports and would appreciate any help you could provide. I hope its really easy for you and that I'll learn something from this.

Thanks!

 

[synapsevampire]

Try grouping on the internal ID and suppressing everything but the group footer.

YTou can add in counts by right clicking a field in the details section (but keep details suppressed) and select insert summary->make your appropriate choices.

If this doesn't resolve, post sample data and expected output, the explanation of business rules helps, but it's clearer when you allow people to see what you're working with.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[lous]

Thanks for the help, it works perfectly!