Charting nightmare

[AMS100]

Can’t get my head round a report I need. We have a helpdesk database with the following table.fields
CALLS.DATELOGGED (as it suggests the date the call was logged)
CALLS.DATECLOSED (date the call was closed)
CALLS.OPEN (whether or not the call is still open T = open F = closed)

For every 1 month period I need to display how many calls were opened and how may were closed. Then I need a chart to show this info in the form of two lines :
First line displaying the 'calls opened' count
Second line showing the 'calls closed' count.
The Y-axis being Calls count and the X-axis being time.
I can do all the calculations but cannot create the correct chart. what I'm really after is were to group and what data is needed in the 'Data' tab of the chart expert.If anyone could suggest any ideas on how to achieve this it would be very much appreciated.

 

[AMjadm]

Hello

I have distributed my Delphi Application with Crystal VCL to a new machine.

Whenever i try to print (call Crystal reports) the following error occurs :

Error: 534 Error Detected by Database DLL. Execute <eStartPrintJob>

I have copied Following file :
Crpe32.dll to Windows
All other DLL files to Windows\Crystal

I am connecting to Paradox Tables.

I can print to that printer from that computer.

What can be the reason it is not working?

Any help greatly appreciated.

Amjad Mahmood

 

[chris777]

AMS100,

In your chart expert, after you select Line Chart type, then on the Data Tab select 'Advanced.' In the 'Available fields' window' pick your date field for your On Change of Window' (if you check the Order button, it should default to 'for every month'), then select your two counts for your 'Show Value(s)' window. That should give you two lines for your counts, with group values for every month in your report. Chris
DFW Crystal User Group

http://www.dfwcug.com