Plotting Formulas on Graph

[DanSheath]

Hi

I've have data in this format

id Date Shift Value
1 1/04/2003 Shift1 15
2 1/04/2003 Shift2 5
3 4/04/2003 Shift1 14
4 4/04/2003 Shift2 7

I'm trying to find a way of plotting the values of Shift1 and Shift2 on a Date axis line. These would form two different lines, one for each shift.

If anybody could point me in the right direction with a formula or select statement... then I would be eternally grateful.

 

[mbarron]

In your chart expert, on the data tab, click on your date field then the > button to move the field into the "on change of" box, then do the same for shift field. You need to do the date first, otherwise you'll end up with one line for each day, instead of for each shift. Then in the "show value(s)" pick your value field. Click on the shift field now in the show values box and check the "don't summarize..." box.



Mike

 

[DanSheath]

Thanks Mike

Works great, I don't have the choice not to summarize, however I don't think that will effect my results.

I'm having difficulty finding text for this kind of level of thing. Most books give a couple of examples of charts and formulas and thats about it.

Would you recommend any book/web site to learn tips and tricks for Crystal Reports 9?

Dan

 

[mbarron]

Tek-tips, by far, has been the best place I've found to learn new things. A great deal of what I know about CR, I learned here by trying to solve the problems people post. I agree with your analysis of the books. I have purchased Peck's "The Complete Reference" due to recomendations from poster here. While it's a great book, I did not use it that much.

Concrening the "don't summarize" option. I forgot to mention that you need to highlight the field once it's in the right side box. The oiption become available then.


Mike