Working With Zucker/Jasper/IReports

[StrongEagle]

Hello All,

Have Zucker Reports up and running. Have IReport up and running. Nice stuff.

Need to figure out how to do something. Want to read the opportunities table to build a pipeline report. Want to take the amount column and place it in a column by month so that I can forward forecast sales. So, if I have 20 opportunities stretching over the next 10 months, I want 10 columns to total. What kind of conditional expression can I use in Jasper/IReport for each column to either show the amount or a blank.

Seems like I need to pull the month out of the 'date_closed' field, compare it to the 'month' for the column in question.

Pointers much appreciated.

[ptemplin7]

Did you post this over in the Jasper/Ireports area. seems like it belongs more over there than here.

Hope you get it figured out. Sorry I can't help furhter.
Paris