December 2009 - Posts

If the reports that you create for your organisation contains common items, perhaps images such as company logos, or report properties such as language or pagination settings. You can create a report template that can then be called from within Business Intelligence Development Studio (BIDS)

 1. Create a Project and Report within BIDS.....make a note of the project location for your BIDS project

 2. Add the components to the report that you want to include in the report template, then save the report, close down BIDS

 3. In Windows Explorer, browse to the project folder and copy the report

 4. Paste the report to the following location

     C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProjects

To use the template you have created

 1. Create a Project within BIDS

 2. Right Click the Report folder, point to Add and then click on New item

 3. Within the Add New Item dialogue box, your report template appears, select the template and define a name in the name text

You report template is added to the report with the objects presented that you added when you created the report

 

Posted by Testas | 1 comment(s)

A number of features have been introduced which makes exciting times to be working in BI

Report Builder 3 with the integration of Maps and sparkline data regions is well worth a look. check out Andrew Fryers piece here.

http://blogs.technet.com/andrew/pages/using-sql-server-2008-r2-report-builder-3-with-bing-maps.aspx

Powerpivot also provides excellent analystical capabilities within SharePoint and Microsoft Excel. Check out www.PowerPivot.com

 I am working on demo for these at the moment and will let you know once they are available

 

Chris

Posted by Testas | with no comments

November has been a busy month with the conference season.......Teched and SQLBits which I attended and of course PASS,

and I will provide an update on these in my next blog

A quick tip as a result from a question from a customer who wanted to restrict the amount of connections that a user can have to a report server that is to be hosted on an extranet.

 You can limit the number of active requests per user by editing the following key within the RSReportServer config file located in

C:\Program Files\Microsoft SQL Server\MSRS10.INSTANCE\Reporting Services\ReportServer

<Add Key="MaxActiveReqForOneUser" Value="20"/>

 The default value is 20 and can be changed to a number that suits your requirements

Thanks

 Chris

Posted by Testas | with no comments
Filed under: