Category Archives: SSRS

SQL Server Reporting Services

Managing Shared Data source – SSRS

Posted on February 18, 2013 by

A shared data source specifies connection properties for a data source. A shared data source can be used share the connection string with large number of reports, models, or data-driven subscriptions This is a best practice consider creating a shared … Continue reading →

Posted in SSRS | Tagged , | Leave a comment

Generate PDF report from SSIS

Posted on February 15, 2013 by

One of my project, I have been asked to design a SSIS package to upload some data from a source ABC to SQL tables and at the end of the package execution we should create a PDF report from SSRS. … Continue reading →

Posted in SSIS, SSRS | Tagged , | Leave a comment

Bookmarks – SSRS

Posted on January 29, 2013 by

Bookmark is used to navigate within SSRS report section. Bookmark can be created with any component that has action propery. In this blog post, I am going to show you a simple example that has bookmark to navigate within SSRS … Continue reading →

Posted in SSRS | Tagged , , | Leave a comment

Refresh SSRS Report Data

Posted on September 18, 2012 by

SSRS BIDS report preview won’t show latest changes after it completes the first execution. Because, it caches the report data in to a file to show the report preview faster and it will read the data every time you request for report … Continue reading →

Posted in SSRS | Tagged , , , , | Leave a comment

SSIS and SSRS Template File Location – SQL Server 2008 R2

Posted on July 25, 2012 by

Templates are used to make the development process easier or eliminating repeated work. For instance, the company reports are always having some standard format. if you are asked to design a report in SSRS with your company header image,footer text and … Continue reading →

Posted in SSIS, SSRS | Tagged , , , , , | Leave a comment