Customised Reports design RRS feed

  • Question

  • User-1160377615 posted

    Hi all

    I need to design a solution around customers pulling reports data from the DB, requirements are below:-

    1) Clients will access reports on the website;

    2) WCF Services need to be used to get the data from the DB

    3) Client have control over what to bring back in the SELECT statement and also the parameters and how often they want the reports to run.

    4) Reports need to be returned in Excel format

    Currently there is an SSIS package that runs the reports, but client wants data in excel and control as specified in point 3&4 above.

    I just need a pointer in the right direction - bearing in mind different clients have different  reports and solution shouldn't be secure and not have any performance hits on the DB.

    Any pointers would be appreicated.




    Tuesday, March 19, 2013 6:05 AM

All replies

  • User-1160377615 posted

    no-one can advice?

    Wednesday, March 20, 2013 5:22 AM