Hi, In my e-Commerce site, I am developing SQL Reporting services for the users to see their sales report online. I don't want them to access Report Manager where they can have access to Report Builder and other properties. I think giving access to the Report Manager for the public is dangerous.
My need is the user should be able to select a start date and an end date; then the system should generate a report of his sales within that period.
How can I achieve this using SQL Reporting Service? Can anyone help me, please? Thanks,