Solved

Crystal Reports help

Posted on 2014-04-14
6
769 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

How to increase the row limit in Jasper Server.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

752 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