We are installing Sql Reporting Services 2000 Evaluation Edition. During the setup we are selecting the Remote Sql Server Instance (On the same network and it is an enterprise edition) as the Reporting Server Database. Locla system has IIS and ASP.NET installed, so it will be used as Report ...more >>

Can anyone tell me if VBScript is supported in this product? I have developed a report that takes one parameter. I have removed the checkboxes for allowing nulls and blanks for the parameter, yet when I execute the report and do not enter anything into the parameter field - nothing happens. ...more >>

I am trying to write C# .NET code to stream a report without using the SOAP Reporting Services tools. (There is a reason for not using SOAP in my case.) I am using the System.IO.WebRequest class to get the response from the server Here is my code: WebRequest request = WebRequest.Create( ...more >>

Someone was asking a week or so ago for a sample code that shows how to request reports via the RS Web service when RS is configured for Forms Authentication. Well, I whipped out a simple WinForm app (sorry C# only, but they are free converters out there for C#->VB ) to show how this could be do...more >>

Here's something to put on the "wish list". It could be argued that it is outside the scope of RS, but I'll bring it up anyway. Hey - you don't get if you don't ask! :-) I think it would be nice if, when viewing a report in a browser, the user could rearrange both the order and the widths o...more >>

Hi, Is there a way to use an expression to check if the report is in html or Excel? For instance, for displaying in html I could want some format, but in Excel not. Is there a way to test something like this??: =iif(ReportExcel, "GainsBoro", "White") The part of ReportExcel, to test...more >>

Hi all, How would I go about referring to the value of a TextBox within a report? I have a TextBox that I named "txtCount", in which I use an IIf expression to selectively count records when in a group. In the footer of the container group, I'd like to refer to that TextBox's value. I have ...more >>

Perhaps I'm only overlooking something very simple? I want to display different columns from my resultset, depending of the data in one column. I also want to apply different styles depending on that "controlling" column. I understand that I in a Table can define attributes for the whole row (...more >>

I have a stored proc running: Declare @cmd nvarchar(255) Set @cmd = 'C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rs -i "C:\CmdLineReportRendering.rss" -s http://localhost/reportserver exec master..xp_cmdshell @cmd But, the report the RSS file will render has 3 parameters the user...more >>

Hi, I have RS with sp1 in one server and MS Analysis server with sp3 in another. Both inside of Domain and the user is the administrator. Also I have the correct roles in the AS. I got this error: An error has occurred during report processing. Cannot create a connection to data source...more >>

I have a report that is landscape (11w x 8.5h). The left margin is .2 and the right margin is .2 and the body is 10.149w. The total (10.549) is under the 11 inches of the width but when I go to print preview, the report is 15 pages with only 10 containing data. The last five pages are blank. ...more >>

Is there a customer Data Providor for Reporting Services that handles Parameteized MDX statments I.E. For instance the below MDX Statement would have <%TOPBOUNDS%>,<%BOOKINGS%>,<%DTLVL%> etc replaced by the parameters passed into the data providor WITH SET [MAIN] AS '<%TOPBOUNDS%>({[CUSTOME...more >>

Is there a way to force a page break based on a value of the current row? If the value of column A for the current row is "Z", then break to a new page. Thanks Tibor Karaszi ...more >>

Hello all, The subject should just about sum it up. We have a web site that uses ASP, COM, & SQL Server w/ Reporting Services. We want to use the web service to render the report and then return it as XML. We could then use a XSL transform to format the report and insert it into an ASP pag...more >>

Hi, I have been using the trial version of reporting services and am now trying to install the standard version. I removed the Reporting Services databases from SQL and deleted the reporting services folder in the SQL folder. When I try to install I receive the following Setup Error: SetDia...more >>

Ive tried the Forms Athentication sample, but i would like how to implement it so i can use the form to log in to my own app, can i just make a reference to the authentication dll and call it from my projects own form? how do i do it? ...more >>

We have 2 reports with a date parameter start date and a end date. One report does a postback on the onBlur event. So as soon as you tab off the field in the Report Manager viewer, it does a postback, and gives an invalid parameter error on the end date text box. The other report does no...more >>

Here are the contents of the ReportServerWebApp log file. When I browse to the site httpS://www.server.com/Reports I get the unable to communicate with Report Server message. <Header> <Product>Microsoft SQL Server Reporting Services Version 8.00.878.00</Product> <Locale>en-US</Locale...more >>

Hi, I'm a newbie when it comes to Reporting Services, so please bear with me. I am having 2 issues: 1) I am trying to get an exported Excel report to automatically select the correct paper size. I have a report that is fairly wide, so I set the report page up to 14" x 8.5" (Legal) and se...more >>

Hi, I'm trying to work out whether Reporting Services is the right technology for an application I will be working on shortly. I need to generate reports with a variable number of columns. I have found out that I can modify the RDL file at run time - but can I get access to the RDL file fr...more >>

I'm having some problems rendering reports as images. We've been using PDF rendering in the past and had no problems. However, when we switched over to IMAGE we noticed that in reports with grid type layouts, some of the lines in the grid would be missing. For example, a grid starting on th...more >>

Hi, I am having problems displaying OCR-A, zipcodebarcode-regular and (third party)SKANDATA-C39 fonts on my application. The way I am trying to render the fonts is by running a MS SQL Reporting Services application and then doing an export to adobe acrobat. In reporting services, all the f...more >>

Hi All Is it possible to use =User!UserID in a SQL statement/Dataset i am new to SQL reporting and i can get it to work. I need to do something like Select * From TableName Where Field = User!UserID Any help would be great Thanks...more >>

I have a report that has a matrix in it. It is a multidimensional report with drill down effects resulting from an MDX query. It has 2 columns (measures). I have created a parameter in order to hide/show a column. I have written the following expression for the Visibility property of my Headin...more >>

I have a table displaying the results of a dataset. Some of the columns display values which are calculated from two fields from the dataset, e.g. =IIF(Fields!Trg_Enr.Value Is Nothing OR Fields!SUMS_MULTIPLIER_03.Value Is Nothing, "", Fields!Trg_Enr.Value* Fields!SUMS_MULTIPLIER_03.Value) ...more >>