Custom Reports

[mikebrewer]

Hey all,

I have a custom program that I've developed using Access 2007. I currently have about 30 reports that I use from the program and I use SQL as the back-end database. I'd like to allow my users to create custom reports and be able to run them.

Basically, I'd really like it if the users could use a platform like Crystal Reports or anything similar (I don't know of anything else) so that users can create reports and then choose them as their preferred reports. Is there a way to allow users to create reports in access without having the full version? Can I give them a way to create access reports in access without having full access to everything?

Is there a program available that does such a thing? Is it easy to work with crystal reports from Access or does anyone have a good suggestion?

thanks for your help!

 

[mikebrewer]

well, there becomes my problem. My program is sold to shops and for their use, I'm not going to be "giving" them anything, they will decide whether they want to buy it or not. I just want to allow them to create their own reports (should they want to).

 

[mikebrewer]

I'm glad you mentioned that. I was just thinking about how easy it may be to package something or allow them to create Word templates or Excel templates that they could then use as their reports. The whole key to it is allowing them to be able to edit/create their own files. Main reasoning is for receipts for repair work, I want them to be able to create their own branding, logos, language, etc. on their proposals/receipts. This way, they have a little more control over it. I have some canned things they can use but I like the ability to allow them to have control over it. Have you had success or is it simple enough to create reports based on those excel sheets?