CR XI - evolution formula

[campia]

Hi,

I'd like to create a report where I can see the evolution of the total of tickets per month in a bar chart.

56 65 54
jan fev mars ...

Any idea?

Thanks

André

 

[dgillz]

Perform a summary count on the database field. Summarize by the date field and you will be prompted how often to summarize and then chose 'monthly'.

Then insert a bar chart.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[campia]

I do not have the sum option. My db fields have all the "text" type.

André

 

[IdoMillet]

Use a formula to first convert them into a number.

cDbl() or ToNumber() would do the trick.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[campia]

so if I put ToText(CDbl ({CTSTICKET.TICREATED}),"MM MMMM")
i have an error saying me:"The string is non-numeric"

I also tried the ToNumber and it's the same...

André

 

[dgillz]

Please show sample data and desired results.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?