I'm having problems with executing a report with a hidden parameter. For the record, I've got SP1 installed. I have a report with a date range that a user can modify: From - defaults to previous business day To - also defaults to previous business day I also have a parameter called Current...more >>

I'm new to the RSClientPrint, so I've read all of the previous posts, the readme, etc. This may be trivial; however... If I make a simple call to the Print method, to where does it print? The client's default printer? My code is as follows ***** Dim rs As New RSClientPrintLib.RSClientP...more >>

Can anyone explain to me how to use the SetReportParameters method? Or, maybe point me to some sample code or something? I'm having trouble with it and the documentation isn't completely clear (at least for me). I have reports and a custom ASP.NET UI that allows users to enter new paramete...more >>

Hi All, I am trying to add tooltip on my charts to show bar specific information while pointing to a specific bar or column. Any help or suggestions greatly appreciated. Thanks, Rose...more >>

Hi All, I am trying to add tooltip on my charts to show bar specific information while pointing to a specific bar or column. Any help or suggestions greatly appreciated. Thanks, Rose...more >>

I am trying to set up a link using the navigation/hyperlink action/jump to url feature of reporting services(Right Click ->Advanced->Navigation->Jump To Url). When I click on the hyperlink, I would like the navigation target to be a new form (_blank), NOT the existing one. I have tried ...more >>

I am using SSRS in VS.Net 2003. I have created a report with various images, text boxes, tables and lines. The preview in VS shows it working exactly as I designed it. However, when deployed to the reportserver viewed in IE, the position of objects shifts horizontally and vertically. The objec...more >>

I have created a contract, at the last minute there is a change that must take place based on a value I am pulling from the db. Scenario: Contract contains 2 datasets which are both contained in lists..ex list1, list2. There are a number of "paragrahs"= textboes that are static, however toda...more >>

Hi, I figured out why the javascript wasnt working in my browser. If you just say localhost/reportserver - it doesnt work try typing your <servername>/reportserver - and the javascript functions will work. Hope this helps Thanks RP...more >>

I would like to install the Report Manager on a web tier and the Reporting Services on an applications tier behind a firewall. The install program automatically installs Report Manager and Services on the same box, but it seems that the Manager is only a UI for calling the Services which are ...more >>

I want textbox2 value to NOT show if textbox1 has the word "***mail***" <---just like that between the quotes. Any help is appreciated. Thanks, Trint ...more >>

Is there a way to get the subject line to report the values of parameters? For example, "Report Date Range is {start date param} to {end date param}"...more >>

If I want to use Windows Authenication as opposed to saving a password in RS, what are my IIS settings? I have read that I should use Basic Authenication istead of Integrated Authenication, but that allows the password to be passed as clear text. Even if I used Basic Authenication, it does n...more >>

Hi there, I'm having a problem with pdf rendering in my report. Basically it is two tables slightly overlapped to give the appearance of once, as I am using two different datasets on each. Although everything works fine in HTML/image view, when I try to export a pdf two things happen: 1....more >>

We need to migrate a server containing SQL 2000 and Reporting Services to new hardware. I saved the encryption key, backed up the ReportServer database on the old server, restored it on the new server and began the Reporting Services install. I get a message "A database with the specified name...more >>

I know you can share a datasource, but can you share datasets as well?...more >>

Is there an easy way to change the formatting options for a value? Example: I have a report listing a slew of numbers. If i use the default formatting options i can display this value as #,###.## or ####.##, or #### if I round. Normally this would be great, but my users are requiring...more >>

Hi, How can i use a java script function in sql reporting services. I have a textbox - which i want to make as a hyperlink and when the user clicks on it - it has to open another report or say url in another browser. i am usin <hyperlink>="javascript:window.open('http://www.google.com',_blan...more >>

Hi! I would like to define optional parameters in a report but run into strange problems. I have defined a parameter in my report (from the layout view) called Status, and also declared a filter =iif(Parameters!Status.Value.Length <> 0, Parameters!Status.Value, "*") that is supposed to f...more >>

Hi, I am looking for some sample code which will allow me to use an ADO.NET DataSet as a Reporting Services Data Source. I have come across an article from Microsoft (http://msdn.microsoft.com/SQL/sqlwarehouse/ReportingServices/default.aspx?pull=/library/en-us/dnsql2k/html/rsdsetex3.asp) w...more >>