If you run the query manually on the groups that fails, and then try and export it to HTML, do you get any more detail? (Under the "Options" object in the top-right-hand corner you should find the Export option.)
It seems the query only worls half the time when I try to run it.
when it doesn't work it gives me 'An unexpected error occured while creating this chart'
when it did work, i tried to export to it to html and sent it to me by email
that failed with an 'unexpected error'
I called McAfee, and they said the null error is most likely a time-out.
that we should do an 'indexing' of the database to make the query run faster.
we'll work on that and see what happens
thanks for the help