This is what I want to do: I have the following report layout Day Sales Expenses 1 10 2.5 2 12.5 3.2 3 10 4 4 14 7 5 12 5 When a user clicks on a day number a subreport ...more >>

In Visual Studio 2005, I create a Business Intelligence Studio Report Server Project. Then I create a new report, and see the Data, Layout, and Preview tabs. Life is good. In the Data tab, I create a new Dataset from my SQL 2005 database. I type SELECT FirstName, LastName FROM MyTable, hit ...more >>

I have a project that has 10 reports that I need to schedule in various combinations with different parameters on 5 different schedules, excel output to a file server. Possibly up to 170 different reports a day so regular subscription set up would be a nightmare to maintain. I have looked a...more >>

Hi Can someone help me with the following problem? I have a report that needs two parameters at runtime. If I execute this report on the same server as RS with a data source that is connected to a database on the same server as the RS server. Then the report execute without any problems. ...more >>

I had the same problem that Dana notes below when I added a second dataset to an existing report that was working. My report had three lists in it (there were no tables or matrices). After adding the second dataset, I got the error shown above in the subject line. I found that two of the list...more >>

Hi everyone, Is the SQL 2000 Reporting Services not compatible on Visual Studio 2005? I've tried installing the developer version of RS 2000 in a PC that already has VS .NET 2005 but not 2003 which is a requirement according to the setup wizard. Thanks Ricardo Sada...more >>

Hi: I am showing 15 records/page on my report. The problem is when I export it to excel from SQL report, I get 10 sheets on my workbook for the 15*10=150 records. Is there any way to avoid 10 sheets and have the export in a single sheet ? Thanks in advance. SDRoy...more >>

I need to reset the page number when a group changes. The group is controlled in a list. PageNumber works well for overall numbering, but not inside the group, furthermore, I cannot access the current pagenumber from inside the group. I am using RS 2005....more >>

I need to retrieve the number of pages for a report in reporting services 2000. The reason that I'm doing this is because I'm accessing the report by the Reporting Services web service and the toolbar doesn't come with the report that way. So I'm basically making my own toolbar to display al...more >>

I am currently having an issue when trying to export a report to PDF or TIFF format within Visual Studio. With the full dataset that i'm trying to export, i will get the error message... "Index was out of range. Must be non-negative and less than the size of the collection. Parameter nam...more >>

We have a confusing problem and need some guidance. We are trying to use URL access to generate and display a report. We = have tried two ways--building the URL string and popping up a new = browser with the Reporting Services URL access string and simply using = an anchor tag and setting its...more >>

I am using RS2000 SP2. The report server database is on a remote server. When I upload my report objects or the shared data source objects using report manager, everything works fine. When I try to deploy the same objects to the same target server, I get the following error message: "The...more >>

Hi everyone, I have a report with Period field that I use on a graph as Category field (horozontal axe.) I want to group on the month part of the Period. In my sql query Period is DATETIME. I found a similar topic here and used this expession to group on month: =DatePart("MM", Fields!Period.V...more >>

I'm having a hard time believing others have not ran into this issue. Anyway...here it is: I've got a pretty extensive web app. that we're using SQL Reporting Services to fullfill the reporting requirements. (This is a shared server in a server farm...I don't have the capabilities to chan...more >>

I have installed 4 RS Viewer Web Parts on a share point page. When I click on the + sign to expand the detail of a report the detail area scrolls to the top of the sharepoint page. If all four web parts were viewable and you were on the 2nd one down from the top, the first one completely disap...more >>

I’m running SQL Server 2005 with Reporting Services. I have developed a number of reports that use data from a fairly obscure financial package that we use. The data sits on a Unix server and is pulled into SRSS using an ODBC driver. When the connection to the data is made PowerTCP launche...more >>

Is there a way to have a report generate so that there is an 'empty' rich text box for someone to add notes, comments, text to the report after it generates? For example, if i have a report generate out to a shared directory, i want to allow someone to go 'update' that report by adding exp...more >>

HELP.. Since lats evening the SQL reporting services are generating huge logfiles at dir ....\reporting services\Log Files\..... Because of limited space at our C-drive the whole server goes down. Please does someone know how to configure reporting services to store the log files at anot...more >>

Hi I am doing reports and UDMs from a DW in Oracle and it is great (some doubt expressed in another post). I tried Report Builder but the new model wizard comes back with the error: ORA 02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED } The data source file (.ds) has be...more >>

Hi, At our company we are looking at implementing SQL Server 2000 Reporting Services into our internet application. Having followed your book, and produced a dozen reports, I have found a problem with calling reports in a multi-user environment. Some of the reports that our customers want can r...more >>

I have an SSRS report that contains 4 bar charts. In the properties for each chart I set the graph palette to "excel", and when I click on preview to see the report, I get exactly the colours i wanted in the report. However, when I upload the rdl file to the report server, it seems to ignore ...more >>

I can design the dataset using the graphical tools but the report refuses to run, is there a work around. Presumably the problem will be fixed in the next service pack? ...more >>