|Even if we were able to offer help with a macro for OpenOffice, I doubt we could offer "ready code" with the limited information provided in your post.|
"Create Calc reports on fly" doesn't give us a lot to work with.
That said, we can usually offer help with macros for Excel, but I don't know of anyone that frequents this forum who has OpenOffice macros expertise. Perhaps someone will respond, but I would be happily surprised if that happened.
May I suggest that you flesh out your requirements with some details and post your question in an OpenOffice forum. The more detail you provide in your inital post, the fewer back-and-forth requirement gathering posts you'll have to endure.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.