akizze01

Anyone else have suggestions? I find it hard to believe that this is a difficult task. It would be like finding the max date in a column in excel and then performing an if function on every row checking to see if it equals the max date cell. Seems pretty simple. Thanks!

Hi Ernst, Thanks for the suggestion but that doesn't work either as it requires string variables. I did convert both of them to strings and ended up with the same results. I am thinking this has something about timing - when the variable is evaluated/set.

I am afraid I am overthinking this but I am having issues using a variable in my pie chart "increment expression". All I want is this: $F{dataAsOfDate}==$V{maxDate} but it doesn't work. Instead it still pulls in all the records as if this filter is not in place. The only thing I can think of is that it is evaluating the variable on every row. There are a total of 12 dates in the datasource and I am only wanting the pie chart to use data for the most recent date. I am only using the summary band with a pie chart and one other column/line combo chart. The pie chart has a reset type of "Report" and an increment type of "None". Version: Jaspersoft Studio Professional 6.1 Datasource: CSV file maxDate variable: Calculation is "Highest" of the dataAsOfDate values. Increment type is "Report" and a Reset type of "None" Thanks in advance!