Probably not ideal but throwing it out there as an option...... One way to do it is to actually use MS Access. If you can create an ODBC data source pointing to a read only account on the database you can do an import and link the tables to the database. You can set the permissions on the database to let the user only see the tables they need to see and create a sample report for them to use as a template. I actually used this sort of set up using MySQL so a company could get a daily report and running of orders placed in real time for accounting and inventory purposes.
G! On Thu, Oct 7, 2010 at 8:25 AM, Richard White <[email protected]> wrote: > > Hi, > > we would like to include a feature into our software that allows users to > create any report they like to display their data - similar to the reports > feature in ms access > > does anyone have any suggestions on the best way to approach this > > thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
