Solved

Crystal Reports help

Posted on 2014-04-14
6
764 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
change database name 2 36
How to modify the SQL query in Crystal 2016 1 28
SELECT query on two levels (detail and summary) 13 57
MySql Recovery 2 28
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

860 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