Category Archives: SSRS

Sql Server Reporting Services

SSRS Complex chart with StripLines

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

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

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

SSRS Grouping at the right of tablix:

One of my issues was to develop a report with a grouping column at the right like that: a group on ProductCategory and ProductSubcategory

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

SSRS: How to pass a sql query parameter from the main report to a subreport:

As you know, Sql Server can link reports easily with parameters. One of my processes required sending a multiple values parameter that consisted of a concatenation of all IDs of the main report’s query, to a subreport. To construct a … Continue reading

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