Author Archives: sql1984

SSRS Complex chart with StripLines

Posted on August 14, 2013

One of my demands was to develop a report with a chart like this:

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

SSRS Deploying Reports Using Rs Utility

Posted on June 17, 2013

Another solution for deploying a report is to use the RS Utility. To do this, we need to understand how rs.exe works: “rse.exe” is a tool that executes a script file (Rss file) to deploy or manage objects on reports … Continue reading →

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

SSRS Deploying Reports from BIDS

Posted on June 10, 2013

One solution for deploying a report is to do it from BIDS: Select your report project properties:

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

SSIS Script task breakpoints don’t work Using 64bits

Posted on June 6, 2013

My Issue was that I have put many breakpoints on my SSIS script Task. When I start debugging, it runs from the beginning to the end without breaking out!

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

SQL Server Migration Assistant (SSMA) :

Posted on April 16, 2013

SQL Server Migration Assistant (SSMA) For this article, I will use SQL Server Migration assistant (SSMA) for converting ORACLE Data Base to Sql server Data Base. This tool helps to convert Oracle, Sysbase, Mysql and Acces data bases to SQL … Continue reading →

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

SSRS Add objects to a tablix cell :

Posted on April 4, 2013

As we know, customers ask more than simple thinks to show on their reports. One of my issues was to print many objects on a cell of tablix. For this: Create your Tablix based on your Dataset: Add a Rectangle … Continue reading →

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

SSRS Include Javascript to a Textbox:

Posted on March 20, 2013

I was searching about adding a link to an external file to my report, then I think to add a JavaScript to It. Here are the steps to add a simple JavaScript to an URL in a Textbox on your … Continue reading →

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

SSRS simple drill-down tablix group:

Posted on February 25, 2013

SSRS provides grouping options and one of them is drill-down, You can easily add a drill- down option on a report from Report Wizard. But once report wizard closed, you cannot return on it, you have to create a drill-down … Continue reading →

Posted in SSRS | Tagged , , , , , , , , , , , , | 2 Comments