Click to See Complete Forum and Search --> : User-defined reports (from a beginner)


Karl Ott
May 26th, 1999, 11:28 AM
I would like to allow users of my VC++ 6.0 app to be able to generate user-defined reports. I am not sure exactly how to go about this. I am assuming at this time it will be some sort of doc/view approach. Can anyone give me any clues?
Thanks,
KO

ric
May 27th, 1999, 07:45 AM
If you use SQL to create reports, then you should Open you database the SQL string, and print it on the screen. But this means that you users must know a thing about SQL.
You must be more specific in question if you need more specific answers.

Karl Ott
May 27th, 1999, 12:15 PM
ric,

Sorry for the incomplete description. I am using ADO to access an MS Access database. I would like to create a 'template' report that users can modify - Add/Move/Delete Text boxes, fields in the report body, graphs and so on. The users of my app are not computer oriented people. So it has to be easy. They can't be expected to pick through the tables and fields in the database and know how to put a report together. What I am looking for is a report generation scheme similar to that of Inutit's Quicken - although my app is not financial. I would like the users to be able to simply drag/drop text or whatever object and be able to format each 'object' so they can make the report look the way the want. Once I have the first report 'template', I can provide the users with other templates to speed up their processes. How does one go about this??? Hope this gives you the info you need.
Thanks,
KO