Idea and discussion portal for the COMMANDseries V2 product line. Users may submit, view and vote on value-added ideas submitted by all users.
AdHoc reporting would be a great feature!! Command has great reports, but many times I have to run two to three different reports and manually combine the data to get the needed results. As a admin, it would be great to have the ability to create these reports and publish to the end users.
Also need the ability to load balance report runs. For example, Production should always have priority over reporting during business hours.
Curt Gould
Thanks for your suggestions. We have discussed expanding our canned reports (order report, ticket report, etc) by opening it to FastReports. This mechanism is like Crystal Reports in that you can specify your own format and save it as the default. It also allows for a direct db connection, so you could print additional information not typical to that report. I think that would meet your need.
Load balancing would have to be done at the database level I would think. It would have to know which connections are reports vs production and throttle resources accordingly. I don't think we would attempt to tackle this.
You are correct on your assumption regarding load balancing. The problem SQL has is the connection from the "software" to the database uses one user (as SQL sees it). SQL does not understand how to load balance one user with hundreds of connections.