Hi Group, When i tried to export my report to excel it throws me this error Error: Index was out of range.Must be non-negative and less than the size of the collection.Parameter name:index. My Report contains subreport in one column.I Placed my subreport in rectangle tool and placed the ...more >>

During the web server install, I used the network service account to run the report server. My Error: setup could not initialize the report server. you must manually initialize the report server before using it for the 1st time. see reporting services setup doc. My environment: sql serv...more >>

Hi, I have two datasets im my report I am trying to connect one of the field of a dataset to a textbox value, I get the following error: The expression referenced a non-existing field in the fields collection Any help is appreciated ...more >>

I've written an application that generates a couple of stored procs and views, and installs them into a DB. I also have a series of reports in Reporting Services that pull data from those views. Its easy enough for me to distribute the .exe for the app that generates SPs and views, but how ...more >>

Hi, I am submitting a report to be run via sending the reportname and some parameters via the RS WebService. Behind this I have a DPE. This all works fine when there are no parameters. when I do pass params though, I have a problem. Trouble is that I cannot seem to lay my hands on the p...more >>

In a line chart, where data is missing, the line goes from the preceding or next point to zero. This can result in displaying incorrect information to the user. Example: Display sales over past two years. We have not measured sales last year until May. And for this year, we have only measured ...more >>

Hi Guys, i have a problem with the subscription function, the error message is: Subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values or if a linked report, the link is no longer valid. I stored the...more >>

I've been having more or less a good run with SQL Reporting Services but today I began getting the "Permissions granted to user MACHINE\IUSR_MACHINE are insufficient for performing this operation" error when my users tried accessing their reports After lots of web research, I thought I wa...more >>

Hi, how can I disable as specific export option in report manager. Actually I want to disable the "HTML with OWC" option. Thanks, Carsten ...more >>

There is a requirement that I need to display the XML data stored in database in one of the report. How can I display this data in Reporting Services with the color schema similar to IE (elements and attributes in different colors etc..)? Thanks, Live_Love_Laugh ...more >>

We are working on a web site that is using a number of standard ASP.NET controls, and one third-party Rich Text Control ("RTC"). We are using the third-party control to capture excel worksheets, word tables, and Visio diagrams. The application is saving the data from the RTC control into a tex...more >>

When I export reports in pdf, I have glyphs in some textbox, I use Arial normal 8, and I checked, the font is installed on the server and the client. I only have the problem in acrobat 5. Any solution?...more >>

A "typical" report consists of a query and a grid showing the data. What I have, is a query that returns a recordset where each row represents the data for a report that is to be emailed to specific people for that row. Just as an example, lets say that you have a helpdesk application. Ever...more >>

How would I angle my category labels along the x axis of a Stacked Column Chart. I can set the colors and and styles, but how do I go about making the label or text sit at a 45 degree angle instead of vertical? Is there an expression to place on the label property for the categories? ...more >>

Hello, I'm trying to run reporting services that comes with MS SQL 2005 beta. I've just installed it and I know I have to activate eg. using rsactivate... Here comes the problem, rsactivate gives me the following message: "File or assembly name 'ReportingServicesNativeClient, .....', or one of i...more >>

Is there anyway to have a parameter that can be a multi select. Example something that will allow multiple states to be selected? ...more >>

I'm in desperate need for insight into how I can use the current date, or part of the current date, in the filename of a report delivered through a data-driven subscription and snapshot? Any info is appreciated, apparently this is possible but there's no info anywhere on how this can be completed...more >>

I have developed a report in VisualStudio that uses a FoxPro .DBF as a datasource. It works fine in my development environment using a UNC name in the connection: Provider=VFPOLEDB.1;Data Source=\\server-name\share-name\path-name;Collating Sequence=MACHINE However, when I deploy it to...more >>

Hi All, I have two tables in a SQL 2000 database. One table contains a few text fields and the other contains any overflow data from the original table. I am required to print a one page report with the data from the first table and then if there are any data in the overflow table, to a...more >>

Hello, I searched for a response from the already posted queries. But I could not find an answer to the problem that I have. I have a report that looks fine on the screen and also when exported to Excel. But when exported to PDF some textboxes display garbled data. It may be because o...more >>

Hello, Is it possible to give another name that "Sheet1" when I export my report to Excel ? Can I put the title of my table report, for example ? Thanks. ...more >>

The documentation for Reporting Services ("Setting Parameters in a Report URL") says to use 'isnull' in the name-value pair with a colon to pass a null value for a parameter: http://reportservername/reportserver?/foldercontainingreports/reportname&region=west&division=mailorder&sales:isnull ...more >>

Hi All, I have programmed a script to deploy a set of reports with the RS.exe utility. Everything works great except, when creating report links (or any objects names) that contain international caracters, it fails. I have tried using straight caracters and html escape codes (ie É for É ...more >>

How do i modiify the title that appers in the document map. Right now, it is the name of the report. Is it possible to modify this? ...more >>

I have a query that drives the generation of a table. The query is filtered during output. If the filtering results in no rows being output for the table, i'd like to put some verbage on the table footer indicating "No Matching Records" or something similar. Is there an easy way to do this t...more >>

Hi, I have table having a column whose value is the following expression. ="' " & Fields!AgencyNumber.Value & " ' ' " & Fields!MessageNumber.Value I want to keep the double " " space characters but when the report is rendered all is converted to single spaces. Am I missing anything...more >>

Having developed my C#, SQL Server, .Net Web application I can create a Setup.exe for the Web App using a Setup Project. The Setup.exe can be copied to any transfer medium and the App. can be installed and run on the production machine (as long as it supports .Net and IIS). When it comes to the SQ...more >>

Hi all i'm having a problem refreshing the fields output tables - i run a report using any stored procedure - which runs ok - however when i click the refresh fields option the following error is stated " the query contains more than one unnamed field. please supply column aliases" - this hap...more >>

We installed RS, then upgraded to SP1 a while ago and everything is working fine. Now, I'd like to backup the encryption keys and I notice that rskeymgmt.exe isn't present on the server. Looked in \Program Files\Microsoft SQL Server\80\Tools\Binn, and then searched all local disks. Is this...more >>

Hi, i have a report with 5 regions. and when all those regions are filled may report stand on 2 pages. my Pb is that event if the region are empty, the space use by each region do not desapear. Is it possible to hide a data region with no row ? i wnat my report to apear on 1 page when al...more >>