Solved

Crystal Reports help

Posted on 2014-04-14
6
754 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 100

Accepted Solution

by:
mlmcc earned 500 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 100

Expert Comment

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

Are you looking for the VB6 code?

mlmcc
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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 100

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now