charting max date filter = bad

building reports desktopintelligence
1

First, thanks to everyone on this forum and all their great ideas that have helped a lot!!!

And now, the lastest problem –

There is an audit table which tracks record changes every time a record is saved. The table saves the field name that was change, the datetime, new value, old value.

After using the max date filter technique and the fold technique together, I get the last value (day, week, year, whatever I need) and it looks great in a list report… BUT

It doesn’t chart! The chart picks up all the data behind the fold and instead of getting a count of 20 changes for a day-- the charts says 1 1 1 1 1 1 1

Is there a work around for this?

ljkidd9 :us: (BOB member since 2004-06-15)