I have a report that uses 7 subreports. Some reports show, some don't depending on the data received from the Shared Datasource. My initial report appears fine in the viewer, however I have a single page following the last page with data containing only the header. When I create a pdf, I have...more >>

Hello, I downloaded the trial version of Sql Server Reporting Services from http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en But when I try to install the service I get the error message that the instance of Sql Server that I am...more >>

My understanding is that RS installs ONLY on the default website. I'm hosting four websites on a single IIS computer. I want to use Reporting Services separately on each of the websites. That is, each will have its own database and its own set of reports. Is this possible? How? Thanks. Dil...more >>

When installing RS 2000 I did not have to do anything to have RS be the default website for the server. For instance, I could put in http://myserver and it would re-direct to http://myserver/Reports/Pages/Folder.aspx I have gone into IIS Manager attempting to set the default appropriately but...more >>

I did a default new install of RS 2005. I am not using SSL. The server is Windows 2003 with SP1. I have not done anything with roles. I am connecting to reports from my computer. My domain/user is part of the administrators account on the server. The server is not a domain controller. Default ...more >>

I have an ASP.NET application that includes a Report Viewer form. The user clicks on a radio button list item to sekect the report to be viewed. The system requires the user to enter a userid and password to view the report. Is there a way to simply have the report display? I do not want user...more >>

Hi, I am trying to size a chart dynamically with respect to the number of rows in the data set it is rendering from (it's a bar chart) so that the graphic will render appropriatley. Is there any way to do this? Thank you, Jason Lind...more >>

How can i have the user run a report in which the user may or may not select a value for the parameter?I dont want to set a default value for the parameter because that would limit the results of the query to whatever value you set as the default. I tried Robert Bruckner of [MSFT] suggestio...more >>

Is it possible to set permissions on a PDF export from SRS to prevent changes to the document? I'm looking for functionality like within Acrobat's menu: Document -> Security -> Restrict Opening and Editing...more >>

Hi I have a report with a table which has two groups. Each group is collapsed by default when the report loads. When I click on the first group expand icon (+) the group expands but also the report jumps up the screen so that the top of my first data row in my table is alligned to the top o...more >>

After installing the RTM version of SQL 2005, I have noticed a problem. I cannot add an SSIS datareader as a datasource type. In fact, SSIS does not appear in the drop-down list. I uncommented the SSIS data reader extension in the rsreportserver.config file, but it still will not allow me to s...more >>

Hi, I've got a production SQL Reporting Services installation and have created some file share subscriptions for one of the reports. Sometimes the subscriptions work and sometimes they don't. My customer has now had enough and wants to have them working all of the time (unsurprisingly!). ...more >>

When running a report in VS, the report run fast but when running the same report via the browser (<servername>\reportserver), the report runs slow. How can I increase the response time in running the report via the browser? Thank you....more >>

Is there a way to get this down to one select statement and group it as such in Reporting services? select custnmbr,contnbr,enddate,Cast(total as Money) from svc00600 where enddate >=getdate() and enddate <=getdate()+30 order by enddate asc select custnmbr,contnbr,enddate,Cast(total as Mon...more >>

Hi All, Does anyone know if it is possible to author RS 2005 reports using Visual Studio 2003? I ask because I installed both SQL 2005 and Visual Studio 2005 recently but support for designing or compiling reports in VS 2003 has been removed by the installation. My project in VS 2003 now fa...more >>

Hey reporting Gurus. I've spent the last eight hours or so trying to get reporting services reinstalled without success. I had a full blown installation, uninstalled it thinking I would try SQL 2005, changed my mind and attempted to reinstall after installing VS2005. I tried the followi...more >>

I developed a report using sql server reporting services and the vs.net designer. Then I wrote another class that downloads the result into pdf and excel formats. When I run the program, the excel file opens fine but the pdf says "there was an error opening this document. the file is damaged an...more >>

I have a field "Accept" that can be Null or contain either "Y" or "N". In my test data I have a total of 4 rows, 2 with "Y", 1 with "N" and 1 Null. I want a count of each case in the footer along with some descriptive text. I tried the formula =Count(Fields!Accept.Value="Y") But it returns...more >>

To render a report I am using The LoadRender and Render method of the ReportExecutionService2005 web service. I was using these methods very successfully in the CTP builds of VS and SQL Server 2005. I recently installed Visual Studio and Sql Server 2005 RTM build and migrated my solution fr...more >>

I have just starting to try to use RS and I have some questions. (My development environment is VS 2003/VB). I use a shared hosting service for SQL Server 2000 with RS. I built a report in VS 2003 and deployed it to the RS server I am assigned. Now I want to view that report from a web page. T...more >>

i am calling a report from a form and want to pass 90 parameters to a report. but is not supported by reporting services. please help me to solve the problem...more >>

I am trying to do alternative color row for my report, 1. On Table - it works =iif(RowNumber(Nothing) Mod 2 , "#F9F9F9","#EBEBEB" ) 2. On Matrix with Value - it works too =iif(RunningValue(Fields!Name.Value, CountDistinct, Nothing) Mod 2, "#EEEEEE", "#FFFFFF") 3. On Matrix with Aggregat...more >>

When I attempt to export a 6 page report as a PDF file, only page 1 is present. What is preventing the complete report from exporting?...more >>

Hi All, This may be a simple question, but when I am adding a web reference to Reporting Services (using SQL Server 2005), should I pick ReportService.asmx or ReportService2005.asmx? In SQL Server 2000, we chose ReportService.asmx (obviously), but in SQL Server 2005 there's another choice, Re...more >>

What is up with page breaks in reporting services. Sometimes they work sometimes they don't and its not consistent at all. What I am doning is putting a bunch of sub reports into a page one after another. I put each sub report into a rectange and set the page break at start to true. The rect...more >>

Hi, We are currently running RS 2000, sp2. When the user prints a multiple paged report from the IE browser, it is printing the current page only. Is this an issue or is it just a setting of some sort? Thanks for your help!...more >>

Hello, We installed RS and got the message that we needed to activate the reporserver. We ran the following: c:\program files\Microsoft SQL Server\80\Tools\Binn\rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" Now wh...more >>

I have installed RS on a Web Server with Windows Server 2003 (standard edition) and IIS 6.0. I have registered the AspNet component (v1.1.4322) on IIS. I have no problems during the installation. I have installed RS client on my PC. I have no problems. In IIS on Web Server the protection has t...more >>

Hi I am currently trying to get our reports to run on RS2005. We have implemented a custom authentication system, and retrieve all the reports via web services which we then render to our own report browser. To have all the images render when rendering in HTML4.0 format, we are using the...more >>

I am receiving the "expression expected" error when trying to include the following in an expression for a sql statement. I don't receive it without the IIF statement & do if I include it: "AND (table.field = @Team OR @Team = '(All Teams') " & IIF(Parameters!Category.Value = 'Only Categor...more >>

I want to display everything on my report on the same screen without having to go to any other pages. How can I increase what is shown on the first page of a report?...more >>

Hello, I have SQL Server Standard installed in one of our Windows Server 2003, where should I request or download real version of Reporting Services? I do not want to install trial version to avoid re-installation in the future. Thanks, ...more >>

Hello, I have got a local installation of Reportserver. I want to display data in a bar chart and an image. This report works fine when seen in Preview. When that report is browsed from a URL: http://server_name/Reportserver/...... neither bar-chart nor image is displayed. When I give fol...more >>

Hi, How do I configure report server for e-mail delivery Thanks ...more >>

Does anyone knows how to schedule a report via email, I tried but it seems like is not working. Thanks ...more >>

I have two queries, one that brings back data from a cube and another that returns records from a db. Is there anyway inside reporting services to combine the two data sets? ...more >>

We have been dealing with this problem for months on end. The print button on the sql reporter web interface fails to print. I read about lots of other people with this problem, but Microsoft has not acknowledged it yet as far as I know. ...more >>

How do I pass a multi-value parameter to a subreport? For example, if my main report has a multi-value parameter named @p1 and my subreport's dataset is generated by SQL SELECT a,b FROM MyTable WHERE a IN (@LongList) how do I then pass the user-selected @p1 values from the main report ...more >>

Hi, we created a "Start"-Report with a drillthrough via "Jump to Report" to an "Linked"-Report and both have parameters. If we drillthrough from the Start-Report to the Linked-Report on the SQL Server September CTP Reporting Services the parameters are not visibile and we are not able t...more >>

Hello, I have a small problem with the web interface that users go to check out the reports. Here is what i see when i go to a directory : Friday, November 26, 2004 8:39 AM 2473 Report1 Friday, November 26, 2004 8:42 AM <ds> DataSource1 Problem is that when a ...more >>

What does the following error mean and how do I resolve this matter? ERROR: 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK SERVICE'. The step failed. ...more >>

This there a way to increase the time it takes when users select items from the drop-down list. Please note that the drop-down list is setup to extract data items from backend database (from query). (also, using multi-value selections) ...more >>

Hi, I understand that I can use ReportingService.Render Method to render a report into a byte array image and then stream it into a file. The sample code included in documentation is clear. The problem is that I have to transfer the report image byte stream from the report server into th...more >>

I am in need of Merging 3 Cells from one column to make one big Cell it insert an image into. I can't just make one row larger because I want to have 3 rows of data next to it. I know I can put a table next to an image control but I am trying to keep everything into one control if possib...more >>

I have a database notes field, which contains the text with some html elements (fonts, styles, etc). If I add it to the report all html tags come in plain text. Is there a way to render the field text as html? If not is there a simple way to strip off all html tags?...more >>

I want to draw a straight line whose parameter can be set in a variaty.how to get it? ...more >>

Hi there. Just installed Reportserver. SP2 on windows 2003. SQL 2000 SP4 The //localhost/reportserver give's me XXX/ReportServer - / -------------------------------------------------- Microsoft SQL Server Reporting Services Version 8.00.1038.00 But when connecting to //localhost/reports i...more >>

I have not been able to take a look at the new report builder, but I needed some information urgently! Can someone please help me out? Does the usage of report builder need a client to be installed in every user who needs to use ad hoc reporting? Is this client installed automatically on clic...more >>

Is there a way to configure the amount of memory that reporting services uses? and if so can someone point me in the right direction in regards to the documentation... I apperciate your assistance. -W ...more >>

Hi all! I'm trying to use the rc:Stylesheet attribute to use my own styles for the toolbar area in a report. I've copied the htmlviewer.css stylesheet located under C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\styles, made some changes and saved it under the ...more >>