OK one more try before I venture over to the Crystal Reports board...
Here is an example of what I need.
I want to pull my net sales number for everyday for the last 30 days. I do not want a lump sum number, and I don't want to have to put multiple 'weekly' reports together for the data.
I want to export one report to excel that has the date and the net sales number for the last 30 (or x) days so I can graph it.
With a SQL DB running, no problem as it had a master DB with lots of good stuff.
I am now back to running the native aloha DB. This has no master DB. How can I pull the data I need. I can't be the only one that wants this kind of data. What does everyone else do?
Thanks!
Here is an example of what I need.
I want to pull my net sales number for everyday for the last 30 days. I do not want a lump sum number, and I don't want to have to put multiple 'weekly' reports together for the data.
I want to export one report to excel that has the date and the net sales number for the last 30 (or x) days so I can graph it.
With a SQL DB running, no problem as it had a master DB with lots of good stuff.
I am now back to running the native aloha DB. This has no master DB. How can I pull the data I need. I can't be the only one that wants this kind of data. What does everyone else do?
Thanks!