my production server is running on Win NT and i have installed Reporting service on that. everything is working except scheduled snapshot creation and subscription? will reporting service works with Win nt (sp 5)...more >>

Hi, When you want to use the Excel export function, you may never get the export even if it is less than 64K rows. I suspect that the xml format of the generated file is so large that the client computer runs out of memory. For a 64K rows export, the xml is probably 64M rows??? Any Excel binar...more >>

Hi, Queries hitting tables of several million rows can take a very long time to process. I notticed that these queries would execute much faster if ran from query analiser. After carefull tuning of both indexes and queries, the processing time is still very long. I am after best practice docum...more >>

Hi I installed Microsoft SQl Server Reporting services server in one of our server(which doesn't have .NET Installation) and installed the client in my development machine.I already installed Microsoft VS.NET 2003 in my PC. I already installed Microsoft SQl Server Reporting services service ...more >>

I recently upgraded to SP1, hoping it would solve my problem with subscriptions triggering. Now I get this error in my ReportingServerService log file: ReportingServicesService!dbpolling!d2c!06/22/2004-21:06:32:: EventPolling polling service started ReportingServicesService!dbpolling!d2c!06/...more >>

Hi If a server has all the latest Hot fixes but not Service Pack 4 is it possible to install Reporting Services? Thanks....more >>

First of all the excel import works fine. Especíally the grouping behvior has been improved. I found two problems 1) A matrix with a coloured subtotal is not presented correctly. In contrast to the HTML the coloured cell does not spread over the whole sum row. 2) At least one of my tables...more >>

I choose Microsoft OLE DB for ODBC driver provider and my SQL is "SELECT * FROM EMPLOYEE WHERE EMPL_ID = ?. I have defined ? in report parameters. When I preview the report, no problem is found. But when I deploy it in report server, the following error is shown: ORA-01036: illegal variable name/n...more >>

Hi I tried to access and view my reports using http://servername/reportserver it asks for user name and password for tht server I gave admin user name and password and it works fine. can any one tell how to get rid this? I mean I dont want reportserver to ask user name and pwd. what woul...more >>

What I was talking about is storing the "individual" pages of the report's intermediate format into a database. Those pages can be selected, tagged and exported not just to PDF by to any of the other formats that AR supports. Bryan's response made it appear as if I was talking about PDF pages ...more >>

hi i have used report project wizard to test one report.. it shows data fine in preview and when i deployed it shows successfully deployed. but when i looked on site it gives following error msg... An error has occurred during report processing. (rsProcessingAborted) Get Online Help Can...more >>

Hello all, We are looking at installing Reporting Services at our company here. We wish to install the Report Server component on an IIS 6 web server that is on our DMZ network, and hence not in our domain (where the SQL Server resides that we want to put the RS database.) While reading BOL's ...more >>

Hi, does it possible to set the "hidden in list view" option at design time of the report (or any other objects) in Visual studio prior a deployment? Because I've a lot of reports and images to send to RS, but some of these are hidden by default. My front end interface hidde these reports to...more >>

How can I get rid of empty spaces following the text value? This is happening for a Comments field, the text is longer and RS seems to add some extra blank lines to the row. i have set both the properties of the cell to "Can Increase to accomodate contents" and "Can decrease to accomodate cont...more >>

How do I use a form in a web page as opposed to querystring in a URL to retrieve a report? Also, I want to have the report target an IFRAME within the current browser....more >>

I am getting the 25619 error when I try to install RS. I followed every suggestion found in this forum but still no luck. Can Microsoft please help me on this? Has anyone successfully remedied this error? ...more >>

1. Cookies are blocking my chart from showing in Report Manager. I just get the small web image placeholder. 2. If I disable cookie blocking in ZoneAlarm firewall, the chart displays perfectly. 3. Is there a place to set cookieless = true for ReportServer? I already have that setting in t...more >>

I know that this is going to seem picky.... We just installed SP1 and ran some reports that get sent out as Excel files. They are certainly smaller and can be read by Excel 2000. The only thing is - where are the rest of the gridlines? Is this something that can be corrected from the report...more >>

I can't get my table to wrap to column 2. When I run the report it makes the overall width the width of one column. There is plenty of room for this 2nd column. Why isn't it showing?...more >>

I received a "free" evaluation copy of SQL Server 2000 Enterprise Edition at a recent conference and wanted to install ony Report Services. 1) Is this safe to install on/into a current licensed copy of SQL Server 2000? 2) During my initial review installation - it required Visual Studio....more >>

I thought I read somewhere here that SP1 would allow us to customize the font color to any RGB combination. I downloaded SP1, but still don't see how I would be able to do that? Is it something I have to do through an expression? I tried using =RGB(x,y,z), but the editor returns "The color ex...more >>

After installing SP1. I'm getting the following error when I try and Preview a report in the VS report designer: TypeLoadException: Could not load type Microsoft.ReportingServices.Interfaces.CachedDataStatus from assembly Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neut...more >>

I have installed Reporting services on a development server, Windows 2000 Server, SP4 The install had an error: Setup could not initialize error, which said to manually initialize according to the BOL. I went to BOL to find out how to do this and found only one article: Troubleshooting an...more >>

I try sql setup newsgroup but nobody answer. Hi, I have a SQL server dev edition in windows XP pro, I wan to install Reporting Services but I have an error at the end "error code 25619". It creates two databases--> ReportServer and ReportServerTempDB. How can I pass this error? Any ideas? Tk...more >>

Hello all, I have a report that has a list of citys on the left: eg. Vancouver Melbourne Auckland New York And the body of the report lists sales in Year to Date and Period to Date which is set by a parameter. e.g City PTD YTD Vancouver 1...more >>

Hi all, I'm all new to this... I'm trying to find a way to limit the contents in parameter listboxes based on logged on user. Want to use Reportingserver WEB for User interface. Anyone know if its possible? The listboxes are rendered with databasequerstions Thanx Kjell Brandes ...more >>

Im trying to use a font that displays a picture instead of a letter and it works fine until I export it to PDF. Once exported the picture is turned into a letter however Acrobat still claims it is using the font. Does anyone have any solutions? Thanks. Regards Jonas Larsen DBA/System De...more >>

is it possible to do this? ...more >>

In Visual Studio when I create a new Report Project, once it's created I go into Solution Explorer, right click on the "Reports" folder and select "Add New Report", and I get the following error: Exception from HRESULT: 0x8013141A I've re-installed Visual Studio, the .NET framework, and Repo...more >>

I just hope the rest of the Service Pack doesn't perform this way. The very first change I tried did not work. I tried to put the point labels outside a pie chart. I got some nice lines pointing to the segment, but no labels! When I put the point labels back inside the chart, I got labels. Th...more >>

I have a written a function where I am defining the return value as decimal. Now I need to do the formatting to make the negative number look like (123.34%) and postive numbers as 123.34%. When I try to do this, I am getting values like (123.3456788). How do I get rid of these extra decimals? ...more >>

Besides the well-know painfull process of getting dynamic values in the page header or footer, we got some major issue with the current release of reporting services. The euro character (?) can not be displayed correctly in pdf format. In the report manager itself everything is looking alright, b...more >>

I am pleased to announce we have released the first service pack for SQL Server 2000 Reporting Services. A press release is at http://www.microsoft.com/presspass/press/2004/jun04/06-22ServicePackSQLPR.asp and you can download the bits from http://www.microsoft.com/downloads/details.aspx?fami...more >>

Hi, I'm having some issues with running multiple methods on the Reporting Services web service. Basically here's the exception that's being thrown: - System.Web.Services.Protocols.SoapException: A subscription delivery error has occurred. ---> Microsoft.ReportingServices.Diagnostics.U...more >>

Hi How to add our own buttons in toolbar?I can't find toolbar in design time where i can find it?pl advice me. thanks ...more >>

I have seen reference to the above component - can anyone please tell me what it is? Is it an optional part of VS2003 installation? TIA, JB...more >>

Is sysadmin on RS like sysadmin in SQL Server - can it do everything. If not, is there such a role in RS? TIA, JB...more >>

I'm having a real hard time with a division in my table. It is in a field in a group that I have no problem getting the correct result by these expressions: =SUM(Fields!NrOfOptysTotal.Value + Fields!NrOfActivities.Value) or =SUM(Fields!NrOfOptysTotal.Value - Fields!NrOfActivities.Value) But if ...more >>