none
Which approach is better to give end users to make their customizable reports using ssrs?

    Question

  • I find out two approaches to give users to make customizable reports in my web application using ssrs.

    1st Approach--> Generate RDL file and publish it to report server programatically and web application creates a folder for every user. It saves the report created by user to report server. So there is the possibility of too much reports on the report server.

    2nd Approach-->Create one report template in which we can pass dynamic query to dataset. So when user select particular columns and group by options , then we can generate query and pass it to dataset using parameter. There is one report on report server but we can use it for every report created by user.

    So my question is which approach is best for performance?

    Please help me regarding this.

    Friday, April 11, 2014 4:40 AM

Answers

  • I will prefer to choose the second option if there are no customization involved. Tomorrow if the user say I want to add this or remove this part then it will be difficult to maintain a report template for all the users.


    Regards, RSingh

    Sunday, April 13, 2014 10:45 AM
  • I would also prefer 2nd option of the two.

    But for that wont a better method be to create and deploy a report model. Then users can use report builder application to consume the deployed model and select columns to be displayed and add group by etc columns in the report based on the model.


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Sunday, April 13, 2014 10:52 AM

All replies

  • I will prefer to choose the second option if there are no customization involved. Tomorrow if the user say I want to add this or remove this part then it will be difficult to maintain a report template for all the users.


    Regards, RSingh

    Sunday, April 13, 2014 10:45 AM
  • I would also prefer 2nd option of the two.

    But for that wont a better method be to create and deploy a report model. Then users can use report builder application to consume the deployed model and select columns to be displayed and add group by etc columns in the report based on the model.


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Sunday, April 13, 2014 10:52 AM