rpt file storage and deployment
I have a few questions I'm hoping someone can answer.
Currently we deploy an application with around 1100 reports. Due to customer security the report must be stored locally by them on their server with no outside access. Due to this we currently ship them new and updated reports which are stored in a standard \reports folder. One of the problems with this is the integrity of the rpt file itself. Storage of the reports in this manner allows the users to open the reports (if they have CR installed) and make changes which then are manifested when ran within the application.
I would like to store / deploy the reports in a different manner but I don't know that much about it and I am not sure what methodology would work the best.
Being that out data is stored in a SQL server can rpt files be stored in a SQL table (like a blob?) If so if it easy to call the reports from the table?
Can you store rpt files in DLLs?
I know we could assemble the reports inside the application itself but that would require a release when one off report changes take place.
Am I barking up the wrong tree here or if what I am thinking about possible?
Thanks a lot for any and all responses!