I wonder if I can automatically pop-up a new window if I click Action (hyperlink) in a report. Any suggestion will be welcomed. Thank You. -- Regards, Jono Indrawijaya PT eBiz Cipta Solusi - Indonesia Microsoft Certified Partner...more >>

Hey peeps, I am trying to know if there is a way to keep a progress bar instead of the default circling image during report load up. Please share your ideas and suggestions...more >>

Will the new version of RS 2005 support natively reporting ADO.NET datasets, allowing us to "bind" a datatable of an ADO.NET dataset to the .RDL layout? As I understand it, to render a report from a dataset dynamically through web services you have to implement a data extension. My web app ...more >>

Is there a report viewer that I can use in a windows based application, not a web application. If there is, where can I find it....more >>

When I try to deploy a report, I received the message "A connection could not be made to the Report Server" Someone knows the solution?...more >>

Hello, Apologies if this is a silly question. I am using Reporting services with ODBC to convert print image text files into pdb files. Each record/line of the file has one character code then the data for the line of the report. I used odbc to describe the file to have 2 columns. The ...more >>

Is there anyway to show a column of variances between the columns in a matrix? The report I'm thinking is like this: Q1 Var Q2 Var Q3 Var Q4 Var Sales 10 - 20 100% 15 -25% 20 33% ...more >>

If i'm understanding some previous posts by Robert Bruckner, you really can't do extensive or fancy custom controls in RS. Is the following to fancy? I have a integer field which tracks contact method (Email, Fax, Mail, or any combination of the 3). Depending on what this number is, will d...more >>

When rendering a report programatically, the Bar Chart that is displayed is missing the Data Label for the last bar in the chart. If I change the chart type to Pie or Column, the label shows fine. This problem does not occur in the initial install, but does occur with SP 1 and SP 2. Is ...more >>

Hi, Is there anyone who can put me some light on, how to view and edit the reports created by others. Because all the code will be on thier machine only. So how to open the present report in designer. Thanks in advance. Krishna. ...more >>

I have installed SQL Reporting in the default web site and added a virtual directorys (same names) pointing to the same Reporting Services folders in a virtual web (external DNS; I don't open the root to internet access). I've tried using both the default app pool and the virtual web app pool...more >>

I have a dataset in my report which I like to have a sort by option on it.I'd like the user choses which field he wants to order by the result and then the report is rendered based on that.Is ther a way to do it in the report rather than doing it in the stored procedure behind the report? T...more >>

Our company recently re-located the servers and somehow in the process of disconnecting -> reconnecting the Report Server the Report Manager now cannot be run. All we get is the error: "The underlying connection was closed: Unable to connect to the remote server." Interestingly, this aff...more >>

I have a field which has a decimal place in the query results in report designer, but on a table in the report it doesn't show the decimal place. So a 10.5 shows as just 10. I already use the cint function to convert it from string to int, but that doesn't help. This was working, and I'm no...more >>

RS Subscriptions are generating the following errors for some (not all) subscriptions: Failure sending mail: The Report Server has encountered a configuration error; more details in the log files The only difference I can see between our working subscriptions and the non working subscript...more >>

I would like to size the width of a table column to be big enough for the data being returned. I don't seem to be able to use and expression for the width parameter. How might I dynamically resize the with of table columns?...more >>

Maybe this was mentioned before but I thought I'd throw this out there... There are a lot of posts about the new client printing in Sp2. I was having many problems getting it to work properly. Tried redeploying, made sure margins and layout was right etc... I had problems with extra blank ...more >>

My users have a report that is wider than legal size - they have been exporting to excel and telling excel to fit it to one page wide on legal paper. Is there a way to do this using the SP2 print control? I havent been able to find it... Thanks....more >>

I have 2 stored procedures which I am using in two different datasets. One has no input parameter, and when I add it to my reports, it shows the field list (it uses a select statement at the end and has no output param specificially defined). When I add the 2nd SP (either alone or in conju...more >>

I have to create a report based off of a query. This query needs to contain a sub select statement as follows. select feilda from tableA where fieldb not in (select feilda from tableb where fieldb <> @Value) the problem is reporting services keeps throwing the following error. Parameter...more >>

Dear all, should i install sql server developer edition in the testing server or other version? Then what version of reporting services need to install into the testing server? Thanks ...more >>

I'm trying to install Reporting Services Service Pack 2 on a Win 2003 Server and I keep getting the following message "The SQL setup failed to connect to the database service for server configuration.", while it's in the gathering information stage. The installation stalls and then finall...more >>

I have a report that contains two date field parameters, StartDate and EndDate. The report returns one record per date per group within the date range. When the StartDate and EndDate are equal, I would like to supress or hide the group footer. Since I return only one row per date per group,...more >>

with sp2 is it possible to change the datasource for linked reports, or is that still in development? thanks,...more >>

Dear all, Is this possible to install report server in msde If not, i am a new in reporting services, is it possible to develop and test just install the report designer?...more >>

My data driven report has been scheduled to send last quarters data on the fifth day of a new quarter. I set the schedule to send: Monthly for: Jan, April, July, Oct and on Calendar Day: 5 at 2am. For some reason I received the report today, which happens to be May 5. What am I doing wr...more >>

Hi all, I am running reporting services on a dedicated server with 2GB of memory, when ever a report is run that contains over 90,000 records the server crashes and restarts. We have looked at the reports, and are to reduce the criteria range to make smaller reports, but it then affects rol...more >>

Can we use it to create adhoc reports in web apps?...more >>

I have installed SQL Reporting Services and sucessfully deployed a couple of reports but I get lots of errors in the Application Event Log like: "The report server cannot create the xxxxxx performance counter" One error for each of the possible performance counters. Anybody any idea what I ne...more >>

Hi, We have very specific requirement for Header and footer in which company logo is there.But it can be changable like when i change it for one plcae all the existing report's header and footer should be changed. How could i achieve this.Also Style for header and footer should be same for a...more >>

Whenever I print direct from Report Manager the document defaults to Letter size paper. Default in Australia is A4. Can I set this anywhere? Thanks. ...more >>

Microsoft SQL Server 2000 - 8.00.818 + Reporting Services SP2 We have created a report (for invoices) that is usually called to render pdf files (for quality) but can also be rendered into tif files (lower quality). The front end program for users is written in Access 2003 with a SQL Serve...more >>