A good book on Crystal Formulas 1

[neronikita]

Does anyone know of a good book on Crystal formulas? I'm thinking that would be a valuable resource.

Thanks,

Di

 

[lbass]

See Ken Hamady's common formulas:

http://www.kenhamady.com/formula.html.

He has also written other publications that may be helpful, identified on his website.

-LB

 

[neronikita]

Thanks, I will do that. I'm still trying to learn how to get what I want out of Crystal.

 

[Madawc]

Crystal Report for Dummies is quite a good guide to Crystal in general. The one I saw was for Crystal 10: I'm not sure if they update it and it would matter. (It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.)

There are also CD-ROMs that teach Crystal, quite a good way to learn. It is quite easy to learn how to write reports that work but to be unaware of easier options.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[neronikita]

Thanks Madawc. I am using Crystal 2008. I actually downloaded that book for Kindle on my iPad, but I can't seem to find specific formula information, like ways around summing fields that cannot be summed, doing complex calculation formulas, etc.

For instance, right now I have a field called TotalCostbyUnit that calculates the following formula: sum({@totalqtycost},{DailyVehicleTracking.VehicleNo}).

TotalQtyCost is: {PartsUsed.numpartsused}*{partslist.cost}

I can sum it by unit, but I can't put a grand total in for all units because it says that TotalCostByUnit cannot be summed. It's things like this that I want to understand.... and I want to be able to know if/how I can get around it.

Thanks,

Di

 

[lbass]

Are you asking a question about how to do this? You can use a variable to sum summaries.

-LB

 

[neronikita]

Thanks lbass, for answering. I will try that. I was asking the question as well as trying to show the types of things I am looking to find resources on so I won't always have to come to you guys here.

 

[Madawc]

You can use SEARCH to find existing answers, often relevant. Also check the FAQs

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[crystalkiwibruce]

George Peck has an excellent book on Crystal Reports 2008. You might also find the articles on my blog at

http://www.crystalkiwi.com/blog.htm

and the newsletters at Chelsea Technologies (

http://www.chelseatech.co.nz/pubs.htm)

useful.


Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm