Crystal Reports 10 Chart Question

[Arora007]

Hi All,

I have a report based off of a sql server 2000 table with 7 columns. The first column being datetime and the rest of the columns are data columns. The report is sorted by datetime in ascending order.

I have created a line chart based on this report which shows in the report header as the first page and the report columns show as the second page.

The problem is even though the report is sorted on datetime in ascending order, the chart is not. E.g. 05/05/2006 shows prior to 05/01/2006, 05/15/2006 shows prior to 05/10/2006 and so on. That is chart is somehow not linked to the sorted datetime column on the report.

I read some place to solve this use a cross tab and insert a chart based on the cross tab. I have tried it, the datetime on the x-axis is sorted but I can only show one column at a time.

Questions:
1. How to show more than one column in the chart when the chart is based off of cross tab?

2. When I am not using cross tab, how can I sort the order of datetime as ascending in the line chart??

Any help will be appreciated. Thanks.

Ricky

 

[lbass]

In the chart expert, if you use the advanced layout, you can highlight the datetime field in the "on change of" area and then click on "Order" and set the date to sort in ascending order.

-LB

 

[Arora007]

Wow!!, That worked. Thanks LB.