Guidance with Crystal 8.5

[RTorrance]

Hello,

I am very new to Crystal Reports and have the task of rewriting a reporting program that is currently on a FoxPro database. We are in the process of upgrading to SQL Server 2000. My problem is that I dont' know where to start with Crystal Reports. I have one table that I need to report on. The table holds information on every part that comes through the line at our plant.(serial no, part no, date, time, etc.) I need to be able to summarize how many parts were produced, repaired, scrapped, as well as give summarized information on repair and scrap reasons by part number. The end users will need to have to option to choose any number of part numbers as well as a date and time. Do I use groups, subreports, both...?
If anyone has any ideas on how to do this it would be greatly appreciated (tutorials, books..) It doesn't even have to be Crystal Reports. Any help is appreciated.
Thanks in advance
Rachael

 

[synapsevampire]

Since you didn't share anything about the table layouts, it will be difficult to give you much guidance.

When requesting technical information try including:

Software version (Crystal in this case)
Database (which you did nicely)
Example data
Expected output

To get you going, I would suggest some tutorials, reading about the product, and getting your hands dirty in the product.

In particular you might group by the part numbers and then use Running Totals to determine the quantities for each reason.

Obviously this depends on the table layout (example data), and what your requirements are (expected output).

To provide summaries, consider using a cross-tab (akin to a summary pivot table).

Here's some freebie tutorials:

AVI's:

http://www.learncrystal.net/

Basics:

http://www.crystalkeen.com/articles/crystalbasics/

And here's some other resources:

http://www.hammerman.com

http://www.kenhamady.com

http://support.businessobjects.com

Good luck.

-k

 

[RTorrance]

Thanks for the reply. I will check out the links. The version of Crystal is 8.5 (which is in the title). The layout of the table isnt' really important in answering this question I don't think. The table is huge and has many fields that will not be needed in this report. I basically have to set up parameters for part numbers, dates and times. The expected output will be something like this:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Summary of Parts Inspected:
Total Parts Produced: PartNumber1:
Total Parts Scrapped: PartNumber2:
Total Parts Repaired:
Total Parts In Rework:

Summary of Parts in Rework:
PartNumber1:
PartNumber2:

Scrap Summary: (by part number)
reason/area/quantity

Repair Summary: (by part number)
reason/area/quantity

'''''''''''''''''''''''''''''''''''''''''''''''
I hope that this is enough information.
Thanks again for the reply!