No problem. Just be cautious because you'll lose a lot of the protection from misuse that SSRS can give you!
Yeah ive thought about that
what i have proposed is that i create a spreadsheet that can be downloaded from the intranet and when it is opened it refreshes the data and then any links to the database are removed
i just need a bit of vba in the spreadsheet
Please bear in mind that this implies that whoever will open the spreadsheet will require at least datareader privileges on the underlying tables in the database.
Space, the final frontier? not any more...
All limits henceforth are self-imposed.“libera tute vulgaris ex”