I'm working on a dynamic reporting system that users can use to custom build reports. They have tables, fields, etc to choose from, then they enter their criteria and it pops out a report.
But I have two questions on this:
1.) How do I get a SQL statement from a form to return a datasheet view? I figure the easiest thing to do is just have it spit it out in the datasheet view.
2.) What is the best way to go about dynamically making reports? I have a few ideas, but i'm not sure which I want to use. Any suggestions on this?
Thanks in advance everyone!