Query on Chart type Report

[amtek]

Hi,

I am having two tables : DrivingLicence and LearnersLicence with DLNo and LLNo as primary keys. I want to generate Count(DLNo) and Count(LLNo) for the particular month selected and show the same in a Side by Side Bar Chart Report (One bar for Count(DLNo) and another for Count(LLNo)).
I am using VB6 and CR 7.0.

Thanking You,

Amit

 

[kenhamady]

You can do this in V7, but you have to use a "Detail" chart.

This requires an "On Change of" field and 2 "Show Values" fields.

The trick in V7 is that the "On Change of" field has to be the same for all records. You can use any constant. Since your records are for one month you could use a formula like:

Month(YourDatefield) and it would work as an "On Change of" field.

Then you give it your two grand total formulas as the "Show Values" fields.

Let me know how this works. Ken Hamady

http://www.kenhamady.com/

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

 

[amtek]

Hi

I tried out with the solution given by you. But it retrieves records for all the months available in the table. I want it for a particular month which is selected in VB application.

Thanx a lot,

Amit

 

[kenhamady]

All I told you was how to construct the chart. The formula is a field used by the chart. I assumed, wrongly, that the report was already returning one month's records.

The chart will use all of the records in the report each time. You have to limit the records in the report by passing a record selection formula to the report from your app.

Do you have a record selection formula to tell the report which month to select?
What integration method are you using?

Ken Hamady

http://www.kenhamady.com/

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