Good Book on Reporting

[brendadd]

I am looking for a good book that shows how to do some advanced reports. Does anyone know of any?

I am trying to create a report using a crosstab that sums both quantities and amounts by month, however I can only crosstab one of these fields easily.

Thanks

 

[GingerR]

What's your table structure, sample data and SQL code?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[THWatson]

brendadd
I don't know whether or not this will give you exactly what you want, but here's a link that may be helpful.

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

Tom