Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Crystal Reports help

Posted on 2014-04-14
6
Medium Priority
?
779 Views
Last Modified: 2014-04-14
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
0
Comment
Question by:tesla764
  • 3
  • 3
6 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39999382
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
 

Author Comment

by:tesla764
ID: 39999390
That's helpful. I have completed those those steps. How do I run the report?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39999415
WHat do you mean run the report?

Are you looking for the VB6 code?

mlmcc
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:tesla764
ID: 39999433
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
 

Author Comment

by:tesla764
ID: 39999515
Are you still there?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39999786
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

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

916 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