Data Quality is very important and you want to make sure the business users get the Correct data from the Cube or from the Datawarehouses. In some circumstances where the data loads may fail you may want to disable the subscriptions so that the business users dont get the wrong reports. I use the following [...]
May
21
2010
21
2010
Jan
20
2010
20
2010
Running SQL Reporting Services Report from SSIS
Whenever you create a new Subscription in Sql server reporting services, a new job is created under the Sql agent as shown in the figure below. You can use the msdb.dbo.sp_start_job procedure to start the job. In SSIS create a new SQL task and run the job wherever required exec msdb.dbo.sp_start_job @job_name = ‘JobName’ For [...]
Dec
18
2009
18
2009
Reporting Services ToolTips
One good feature in SQL server Reporting Services is ToolTip . It is a simple feature but has more advantages if you want to show the complete information in a report. Its a great way of saving some Reporting space.I use it when Designing Dashboards or if you want add the redundant columns like the [...]
Dec
7
2009
7
2009
Creating a simple FrontEnd using Reporting Services and Merge
Problem: A Business User wants to update/insert/delete the values in a table that sits in the metadata of the Datawarehouse on a regular basis. Based on these values numerous calculations will be done in the warehouse which generates a data driven Report on a weekly basis. Initially I got the following Solutions 1. Create a [...]
Oct
13
2009
13
2009
Checking TSQL in SQL Server Reporting Services Datasets
Recently I have been checking all the Dependencies on the Reports in SSRS(Sql server Reporting Services) because of a Major deployment on the ETL. The ETL change was to accomodate the transfer of a few columns from old Table TableA to the new table TableB. Some of the Datasets in the Reports are Stored Procedures [...]
Sep
17
2009
17
2009
Reporting Services Date Format
Many Clients have varied Requirements for Dates. You can do the conversions in Date format using T-SQL from the following link in MSDN. In reporting services you can convert datetime using the customs visual basic datetime formats using Expressions. Here are the following links on MSDN for Visual Basic Datetime Formats Predefined DateTime Formats Using [...]
Sep
8
2009
8
2009
Report Server Names for Instances
If the sql server reporting services is configured on the server called “SQLBOX” then the URL is http://SQLbox/reports. If there is a named instance like SQLBOX\VIVEK then the reporting server URL is http://SQLBOX/reports_vivek
