RDLC and stored procedure RRS feed

  • Question

  • Hi,

    For security and performance reasons our reports are developed only with stored procedures. We offer the ability to our users to also create reports, and copy them into our product : however it is a little clunky asking them to write stored procedures for their reports - as their level of knowledge will not always be adequate.

    Is there a way we can directly convert their query to a stored procedure (behind the scenes) within the report builder, or BIDS environment ? For example can we add a custom assembly, control, etc. - or change the RDLC file while it is being created ?



    Sunday, April 22, 2012 11:55 PM