Hi, The code you provided have some single quotes missing/incorrectly placed. Please recheck the query. Lasi

Hi All, I found a way of implementing this functionality! but sorry for late reply. I am using ReportParameter objects to set parameter values through the visual studio report viewer control. It contains a ''Visible'' property to do hide when necessary at the run time. Following is a code sample: ReportParameter p1 = new ...

I want to convert numeric value to word (ex: 100 ----> Hundred) in SSRS2005.this is available in crystal reports. If anybody know plz reply. Regards, Hasitha

I am passing a string parameter which contain mutiple names seperate with commas ','  from my form to the report through a report viewer . So I need to split them now  . I knew that it (function) should come like this Split(parmeter_name,'',''). But where should I use it?  At layout>available value>nonquery or.. Can i use ...

Organizing data with a combination of different data visualizations is a rather complicated yet important task in report authoring. SQL Server Reporting Services 2005 includes more than three data regions that allow us to organize data easily. This article talks about one of the data regions; Table Data Region. Read and see how ...

There are two ways of showing a value from one of your datasets in the page header textbox. One way is, if the field has already been added to the data region (table), find the name of the textbox (get the properties of the textbox and see the name property) and refer it in the page header textbox by using ReportIems collection. For example, if a ...