Time Intervals in Chart

[Former Member]

Hi,

I have datetime field. I want to display the datetime in chart(x-axis) in intervals like 1/1/11 10am, 1/1/11 11am, 1/2/11 12pm, 1/2/11 1 pm, 1/2/11 2 pm etc.,

Can you please give solution.

[former_member222556]

Hi Rajesh,

Drag Chart>Rght Click on it>Select Chart Expert--> in Data Tab, move the date time field on the top list and amount in below list

then refresh it and view it. It will show you the chart according to DateTime.

but if you the chart at Every hours. you have to restrict your record at everyHour

you have towrite this code in Selection Expert

{VENDOR_csv.date time} like "//* *:00?M"

this will give you proper Result at every Hour

Thanks

Obaid

Edited by: obaid shaikh on Jan 25, 2011 12:16 PM

[Former Member]

I'm not clear. Is there any other solution

[former_member222556]

Hi Rajesh,

you have a Chart

Rght Click on it-->Select Chart Expert

--> then in the Data Tab, move the date time field in the top list (just Select field Using > button move it)

--> similarly "amount" in below list.

then refresh it.

It will show the chart " DateTime/amount" .

but if you want the chart(x-axis) should display only "14/12/2010 1:00PM , 14/12/2010 2:00PM" not "14/12/2010 1:30PM"

you have to write this code in Select Expert in Report Menu

{VENDOR_csv.date time} like "//* *:00?M"

'*' is one or more occurances

'?' is one occurance

this will give you proper Result at every Hour

Thanks

Obaid

Edited by: obaid shaikh on Jan 25, 2011 12:16 PM

[Former Member]

Group on the date in question and set the group to print on each hour.

[Former Member]

Hi

I tried to do in select expert but i didnt. It says "String required here". so i convert to string even though its not working.

[Former Member]

is the date in a date field or a text field?

[Former Member]

Its in date filed only(m/d/yyyy h:mm). fyi - I'm using excel as database.

[Former Member]

>

> Hi
> 
> I tried to do in select expert but i didnt. It says "String required here". so i convert to string even though its not working.

I just realised what you said: You don't group in the select expert, you do it in the report layout.

Does Crystal recognise the excel date-time field as a datetime? If it is reading it as a text field, you will need to do a formula to convert it to a datetime field. There have been several posts here explaining how to do that.

Then you can group on the formula by the hour.