SSRS Complex chart with StripLines

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

Continue reading

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 server.

Here more information about rs.exe

In order to deploy a report to a report server we need to go through three steps:

Create Folders (data source, report folders)
Create Data Sources
Deploy 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:

Continue reading

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!


Continue reading

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 server 2005, 2008 and 2012 versions.

Let start from Oracle:

Here the link for downloading (SSMA for Oracle v5.2): http://www.microsoft.com/en-us/download/details.aspx?id=28766

Start your SSMA :

Start -> Microsoft SQL Server Migration Assistant for Oracle -> Microsoft SQL Server Migration Assistant for Oracle


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 to your cell


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

Select your textbox and go to Properties:

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 manually.

Here are some Steps for creating drill-down on a report manually:

Step 1:

Create a report; add your query and your tablix:


Continue reading

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