Author Archives: sql1984

SSRS Complex chart with StripLines

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

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

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

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) :

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 :

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:

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:

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