I am working on a project to create an application to assist the creation of FMECA's.
Basically everything is fairly okay but I have had a request on which I would like advice
I will be producing a report based upon our own standard report format and that is not a problem but the request is associated with a tailored report to a customers request.
Firstly there is no additional data requirement. All the required data will exist within the application. The sort of thing required will be that the customer will request
1) A standard column/s to be omitted
2) Column sequence to be changed around a bit
3) Font changes
This application will be used by Reliability Engineers. What is not required is for the Reliability Engineers to become Access people and start designing reports.
What is required is like a Report Generator that allows them to "drag and drop" data items onto a report.
Personally I think there are many potential problems but I would like advice on
1) How to do it and/or
2) Why it cannot be done.
Based on the principle that nothing is impossible if you throw enough money/resource at it the "Why it cannot be done" should maybe be read as "Here are alternative options" because what you are asking is
2) Extremely complex
3) Full of problem areas (define)
4) More complex than teaching the Engineers Access
5) Cheaper to get the developer to design reports as and when required. (Like this one..... 10 years to retirement)
All comments advice etc welcome