I have been challanged today with creating dynamic reports, so in true fashion, I decided to cheat and get the opinions from as many people as possible. I am looking for a way to make very dynamic reports, I will use inventory as an example:
I need a report where the user can search and sort based on whatever critera they want without having the have certain fields on a layout. So for inventory a user may want to see all the inventory for today, and then go back and see what the inventory level was a week ago. Then again, they may want to see what the inventory was a week ago for just 3 parts. I know this can be done as a power user and using native filemaker functions but I am looking for something a little more inventive. Here are the important things to me:
2) Correct Titles (ie. if you search for current inventory the title is current inventory)
5) Easy to use (does not have the be easy to delvelop, I am a pretty old hand at developing)
6) Did i mention speed?
I am looking at ExecuteSQL into a new "Reports" database right now, has anyone tried reporting like this, is it faster then a find and sort?
Thanks so much in advance for your thoughts - any thoughts help!