Query on Side by Side Bar Chart Report

[amtek]

Hi

I am using Side by Side bar chart to create a report

Say there are three bars. Each bar represents LearnersLicence, Permanent Licence, Duplicate Licence etc.
Each bar should show total number of Licences(Learners, Permanent, Duplicate etc.) issued for a month in a year.
Each bar value comes from different table (eg : Total Learners Licence issued for a month from Learners Table, Total Permanent Licence Issued from Permanent Table).

Thanking you

Amit

 

[kenhamady]

Are you launching this report from a program?
What version of CR and which integration method?

You would have to get all three tables into one result set, probably by using a union query as the basis for a report. You can then group by a value representing the source table, and the subtotals will be easy to chart. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)