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
tesla764Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
These instructions are from CR2008.  I believe they are close to what you will see in CR10 but there may be differences

Open Crystal
Click Report Wizard
Choose you database connection method
Navigate to the database
Navigate to the table list
Select the required tables
Click  finish
Open the FIELD EXPLORER
Drag each field in turn onto the report
Run the report

You probably will need to do some formatting but the report should be essentially done

mlmcc
0
 
tesla764Author Commented:
That's helpful. I have completed those those steps. How do I run the report?
0
 
mlmccCommented:
WHat do you mean run the report?

Are you looking for the VB6 code?

mlmcc
0
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.

 
tesla764Author Commented:
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.
0
 
tesla764Author Commented:
Are you still there?
0
 
mlmccCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.