I am trying to create a report in SSRS2000 that will query an ORACLE database and pass one parameter, I am getting the following error message: ORA-01036: illegal variable name/number But have been unable to find much help elsewhere on the web with this error code I was hoping that this would be fairly simple to do, does anyone have a...
I have an issue where we tried to upgrade our TFS 2005 server to 2008. During the install we encountered the error that it could not configure SQL Reporting Services. The log files showed that during the creation/configuration of the virtual directories for SQL Reporting Services (the Reports directory to be exact) a FileNotFoundExceptio...
In Reporting Services I would like to add a parameter that contains data from a custom code block. Ideally, I would be able to run the following code (this is a simple testing example): Function GetPeriods() As String() Dim values As System.Collections.ArrayList = New System.Collections.ArrayList() For i as integer = 1 to 24 ...
We have a reporting server which has a bunch of reports and some ad hoc user reports created by users using report builder. Now we need to move all these to a different server. The new server already has some reports in it. I need to move all the reports from the older server to a folder in the new server because of this moving the datab...
We're writing a web application that is trying to replace all ReportManager functionality using calls to Reporting Services SOAP API. We started working with SSRS 2008 and had our Java code working correctly. We've since had to downgrade to SSRS 2005 and now we're having problems connecting to the Server to get the list of reports avai...
I am looking for a method of changing the data source for a report in SQL Server Reporting Services. Basically what functionality I am looking for is a drop down box (parameter) at the top of the report that permits the user of the report to select a different data source to run the report against (so when the drop down selection is cha...
I need to send mail via data extension I am having Visual Studio 2008. I am migrating from Visual Studio 2005. Will it possible. ...
We have some SQL server reporting services reports. I didn't write then but I have to take care of them. These reports fire when opened in the browser, and with the default parameters (search terms and restrictions are blank) they retrieve a lot of data, which is slow. The client would prefer that the report is not generated until the u...
I have a report in SQL Server Reporting Services (SSRS) that I'd like to schedule to run automatically as an email. I'd like the report to be attached as Excel file. According to the Microsoft overview this should be possible. Report delivery. SQL Server Reporting Services supports both on-demand (pull) and event-based (push) delive...
I'm using the XML data source feature in Reporting Services 2005 but having some issues with missing data. When there is no value for the first column in a row, it appears that the entire column is ignored by SSRS! The web method request is very simple: <Query> <Method Name="GetIssues" Namespace="http://www.mycompany.com/App/"> ...
I have an SSRS report where I need to collapse data into a summary column like so: +Program -Program2 Program2DataElement1 | Program2DataElement2 | etc. How does one doe this? I see it in other reports, but can't for the life of me find the area to set it up. When I put in a group, I get something like this on all records: Program ...
I don't expect to get a great response from this, so if you have had experience in this any contribution would be appreciated. I am trying to use the Visual Studio Report Designer with a Linq to SQL datasource, I have no experience of using the Visual Studio Report Designer. If I go through the wizard and use an object datasource I can...
I want to put a table inside a table row. But when i try to take the preview it's not working. Can anyone help me on this? ...
I have a SSRS 2005 report that has a number of images in it. the way that I have the images included is I have an image object with the URL set in the value property. the actual images are hosted by and IIS virtual directory on the same serer. I'm doing it this way because i need to dynamically change the image source using an expres...
Hi, I'm using the ReportViewer control to display a Report within a WebForm, i've also implemented the "Export to Excel" feature, by calling the Render method of the Server Report eg ReportViewerControl.ServerReport.Render("Excel",etc,etc,etc); My problem is that the exported report contains Hyperlinks that link to other reports, I ...
I want to use the new report builder 2.0, rather than the old VS2005 integrated report builder for the new features and ease of use, but source control integration is a must. I don't see any ability to use TFS natively, and I have installed the TFS MSSCCI Provider, all with no love. Does anyone know how to get them to play well, or am ...
I'm interested to center (dynamically) the list/table on page. Eg I have table with unknown records count (only in runtime will know that) So how to center it on the page? ...
Does anyone know if it is possible to install SQL 2000 Reporting Services Server side by side with SQL 2005 Reporting Services Server? The Reports and ReportServer virual directories are both virtual directories in the default website and they use different .net frameworks. Is this even allowed? Do I need to create a new website to supp...
I am working on an ASP.NET (3/5) web application. In the application, we assemble lists of classes from a variety of data sources. I would like to create a report in SQL Server SSRS that renders a report from the contents of one of those lists, without pushing the list to the database (in fact, it would be a violation of a bunch of rul...
I am using SQL Server Reporting Services 2008 (though this seems to be an issue for me in 2005 also). I have a report that has one page per customer (i.e. paged on customerId). The odd thing I'm seeing is that the first report (i.e. first page of the report) has a bit of extra white space at the top than the other pages. In general th...