asked on

Crystal Reports help

Hi,
I have a request to generate several reports today. It's been a little while since I have used Crystal reports. I need a basic refresher on how to do the following...

First report
QOH/Location (locations table)
- location_desc
- qty
- item_code

Second Report
Location History (inv_location/locations)
- location_desc
- qty
- date_add
- add_id_user(tie back to users table)

Third Report
Destruction History (item table)
- Item Code
- Qty
- dest_start_date (Date Start)
- dest_end_date (Date End)

We are using SQL Server R2, Crystal Reports 10, and VB6

How do I get started?
If I have 1 good example of creating the 1st report I can get the rest done myself.
Please let me know if you need more info.
Thanks for the help in advance

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tesla764

ASKER

That's helpful. I have completed those those steps. How do I run the report?

Mike McCracken

WHat do you mean run the report?

Are you looking for the VB6 code?

mlmcc

tesla764

ASKER

Once I followed all the steps above. Your last step is "Run The Report"
Is there a way to run the report that has been created to see what it will look like and to see if it functions properly (getting the correct data)?
Yes we do want to run the report from VB6.

tesla764

ASKER

Are you still there?

Mike McCracken

I assume you are in the Crystal stand-alone designer.
You just preview it.

If you are creating the report in the VB IDE then you have to write the code to view the report

mlmcc