Implement Custom Sort Order in SSRS

Let us see how do we implement the custom sort order in table using custom code in SSRS. Following image contains the report data.  It contains the sales details based on city and you can see that the data is not ordered in any fashion. If you want to order the data in ascending or descending order then we can achieve this…

Back up reports Using rs utility

In this post let us see how we can automate the back up of SSRS reports using RS Utility. If you want to know about the RS utility and where you can find it in your system please refer to one of my blog click here. Let us get into the real world scenario, generally we all do…

Deploying Reports Using RS Utility

Deploying the reports manually and assigning data source to them is a tiresome process.. I thought there might be a way in which we can reduce the efforts.. That is when i found that there is a utility called RS using which we can reduce the effort. Let us see how we can automate the report deployment with…

Using Where and Having Clauses

It has been some time since I have posted my last article let us kick-start with the next one… Generally there is little confusion in using the Where and Having Clauses. Let us understand with the help of this article Where Clause:        Where clause specifies the filter condition for the table. It is optional to use the…

Connecting to SQL Server using Command Prompt

 I was going through the videos in VirtualTech days, I found that there are some interesting tips given by the speaker Vinod Kumar. I thought  of sharing some of the tips in coming days so that it might be helpful for others as well.   Following are some of the options that are available to connect to SQL…