I have an odbc connection to an Informix server. I can get data from it but when I try to union some data to an 'All' field for a dropdown it comes with syntax error. SELECT root.debkart.navn from root.debkart.navn union select 'All' If I do this there is no problem SELECT navn from r...more >>

I am running 2005 reporting services and 2005 visual studio. I have a c# .net web application located in the default web directory in IIS that uses forms authentication, but that authentication is to active directory using an ldap call inside the code. We set it up that way so the user can log i...more >>

I have some reports that were developed using a beta version of Reporting Services 2005 on a virtual server. We need the reports off of the original virtual server, but do not have the project anymore that the reports were created in. I need to basically move the reports from the old server to...more >>

Hi, I just noticed a behavior change from SSRS 2000 (SP2 version) to SSRS 2005 (RTM version). With SSRS 2000, if I use IE to bring up a report that can drillthrough to other report, I can right-click at the textbox (where drillthrough action would take place) to select "Open New Window". I...more >>

I have a report that works just fine and has for some time. I had to make a change and added a new parameter to the stored procedure. I updated the report and republished it. It sees the parameter but doesn't seem to be using it. I even ran SQL Profiler and it definitely is not calling the s...more >>

Hi Group, We are using Win 2000, SQL RS 2000sp2 and SQLServer 2000(sp3) and we are rendering to PDF. In most of our reports, in the body we have a title and a description, followed by a table with a grouping structure like this: Title GroupHeader1 (visible) GroupHeader2 ...more >>

I'm sure body+margins=page width, there is no way the report is splited to multiple page when print preview. The report is a multi-page report. The matrix is added in the 4th page. Before adding the matrix, everything is fine. After added the matrix, the first page is splitted to 2 pages or ev...more >>

Hello, I am using RS 2000. What is the URL rc command to not display the Export option in the toolbar? Steve ...more >>

I am trying to make use of the table for a variable list of columns. I have a max limit of columns that I design the table for and depending on a parameter choice, I should be able to hide and hence pack all visible columns without hidden white spaces. It works if I simply hide a random set of...more >>

How do I access the 2nd grid/table in my report? Basically I have a SP that has a SUM in one grid. The second grid cotains the data I want to display in RS. Is there a way to get to the 2nd grid without altering the store procedure(Its being used on another report)? regards, Stas K. ...more >>

Hi, How sould I format a Currency Column without decimals ? Thanks ...more >>

I'm trying to use Reporting Services 2005. The service is running, but if I type http://192.168.1.49:8888/reportserver I see the directory list. With http://192.1681.49:8888/reports, I see an error: The request failed with HTTP status 503: Service Unavailable.The error is in URL. http://192.1...more >>

Hi I am writing an ASP.NET application and using reportingservicesGetReportPArameters API to retrieve the parameters in a report and its valid values. I get the valid values, and values for the parameters that has default values. how can i get the values for a querybased reportparameter. ...more >>

Is it possible to add/remove/hide report parameters based on the Windows/Domain account accessing the report for SQL Reporting Svcs 2003/2005? In our LAN, I want only managers to see/set certain parameters, otherwise have a default value set for the department. The only way I know of is ...more >>

How can I dynamically set the chart type based on a report parameter? -mdb...more >>

I urgently need to install a report that I developed (in Reporting Services for SQL Server 2003) in a different computer, that doesn't has VS.NET (that is, a can't build the reports there). What files do I need to install, and where do I install them? And what about the connection string of t...more >>

Randomly had this error...... An error has occurred during report processing during a report demo. People were not pleased. Anyone ever find out what generates this error. Is it a high-level/generic error that is thrown? Are there any hidden log files that perhaps specifices the cause of t...more >>

How do I write expression to calculate a value to show percentage of the subtotal value in a Matrix? I have already tried =Fields!name.value/sum(Fields!name.value) and this does not work Example: Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would like to show the ...more >>

Using SQL 2000, reporting services w/sp2. When any of our reports are exported in CSV, the first row contains the headers. The problem is two-fold. First any hidden columns, while not being in the data portion of the export, are included in the headers. Second, the headers are the design t...more >>

I am curently Evaluating SQL Server 2005. I am currently creating a Data Driven Subscription to Email recipients. I have 3 Parameters on the report. 2 are available to the End-User, Start Date and End Date. The Third Parameter is a lookup to a users location. I have hidden the parameter in the...more >>

Hello, Is there any way I can get all the report names from report server and populate a dropdown list in my asp.net C# application? Thanks, ...more >>

I have a report that has a date parameter that is used to call a stored procedure. I need to get the user input of that variable after it calls the sp to call another sp. This is just calling the same sp but with a date - 1yr. thanks,...more >>

I have a pretty big problem: I'm building my reports on top of an OLAP cube. That's pretty basic. The thing is I'm also building a sub-report which is based on values/parameters from that report and that's where the problem kicks in. The sub report takes the parameter I pass to it and perfo...more >>

We are working on creating a copy of our SQL server machine for disaster recovery purposes. ReportServerTempDB is purely a temp database, correct? Meaning, the data in it does not need to be replicated from our production server to our disaster recovery server, correct? Could someone just...more >>

I know this is a little out of the charter for this forum however there isn't a Visual Developer forum that fits as close to the issue I'm running into. Report Viewer in VS2005 seems to draw a lot of its function if not base code from SQL Reporting Services so I'm hoping that someone knows wh...more >>

I have a single service account to render reports using web services. I am encountering this error in testing: Begin Exception Date 1/9/2006 6:00:09 PM Source System.Web Description Exception of type System.Web.HttpUnhandledException was thrown. Stack Trace at System.Web.UI...more >>

I need to make use of the HTMLViewerStyleSheet parameter in SP2. I have applied SP2 and the Hotfix, but still do not see <HTMLViewerStyleSheet> in the RSReportServer.config file. Am I looking in the wrong place? If not, can someone please tell me exactly where and in what format the paramete...more >>