How to Create Template Report

Question

Hi My client is having total 50 different clients through globe.Now my problem is that for each Client's client We have some change in report like minor modification means need to display some column in one report and take out in other in someone logo is top and other it is bottom so how can i manage it.and through Web application how can I manage it means means during report call what should i need to do ? So here I need to create 50 separate reports or what

My second question is that is there anyway I can give client a just common template and during run time without any SSRS knowledge he can just select required columns,change logo from top to bottom setting tablix width and height and font?

Answer 1

You can create a Report Model and let the user to build his own reports. Building a report using Report Builder does not require any SSRS knowledge. The user can create a basic to medium complex report (Table or Matrix) using the Report Builder. The user can freely choose the columns he wants to display in his report and their order. The user can also modify the width and height of the reports and select the font and style. The user can then save his reports in the Report Server.

Also using Report Model, you will be able to control the columns / data sources that are exposed to the user for his Reports.

---

Please mark this post as answer, if it addresses your query.

Answer 2

Aminesh,

Are you looking for some kind of Report Templates where you can give it to your clients? Pretty much it would help you achieve common patterns for all reports.

Try to create Report model or SSAS cube and give your clients the freedom to design their own reports using Report Builder.

---

Regards, KarthikShanth. "Mark as Answer" if this helps you!

↑ Grab this Headline Animator

Disclaimer: The contents, I write here are my personal views, not the view of my employer and anyone else.

Answer 3

What version of SSRS are you using? Report Models cannot be created anymore in SQL 2012. And if you are on a lower version and decide to upgrade to 2012 the report models will work but you won't be able to alter them using SQL 2012

Breaking Changes in SQL Server Reporting Services in SQL Server 2012

---

Josh Ash