I've created several reports, using ODBC to an external data source, and they preview just fine in Visual Studio 2003. However, when I deploy the reports, open Report Manager, and select a report to run I get: An error has occurred during report processing. (rsProcessingAborted) Get Online...more >>

Hi I need to be able to view a report from an RDL XML document. I would like to be able to dynamically create the RDL and run the report without having to first upload it to the server. Do I need to use the web service for this? Can it be done with the report viewer control? Any ide...more >>

Hi all, I use hidden report parameters to populate textboxes in the pageheader and come across this problem. When the query for the default value for a parameter returns no rows, I get an error "Parameter validation failed. It is not possible to provide valid values for all parameters. (rs...more >>

Hola Comunidad, Tengo un problema con Permisos en Reporting Services, Me inicia normal me deja navegar por los menus, pero cuando le doy click a un reporte para que me lo muestre me sale el siguiente error. *************************************************** No está autorizado a ver esta ...more >>

Hi, I am trying to learn Sql Reporting services. Is there any good resource which gives me alot of walkthroughs on how to create different types of reports. I tried the online documentation which comes along with the product but it doesnt have many walkthroughs... -- pmud...more >>

I have a report with a subreport attached. I've deployed both reports to a folder that is governed by AD group permissions. When I run the report (I'm a content manager) the subreport shows up but when I try to run from my test user's account the main report shows but I get the "Subreport co...more >>

According to http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/7fcbd1e9109b9b4b/67a26738d8cd2126?q=install+client+vs.net, when I install the client components of SQL Reporting Services, the add-ins should automatically be added to VS.Net. I've tr...more >>

We are having issues with Mac users accessing our RS reports. When they use Safari RS refuses their connection and when they use IE 5 they are prompted for User/Password/Doman (which is OK) but the drop downs (prompts) aren't showing up. Is there a solution? Thanks ...more >>

Apologies in advance, newbee to SQL Server and Reporting Services... Installed Reporting Services in TEST environment (without SSL). I can author a report, view the data from the data source and preview successfully. However, I receive the following error message when trying to Deploy a Solut...more >>

I have made some decent progress on switching RS to use form based authentication. Currently the application validates the user against are Oracle database, then accepts the cookie created by the page and then converts the cookie into a principal object which is used for the authorization porti...more >>

I have a report that has a pct avail column where the font is colored red, yellow, or green based upon thresholds. The color is based upon an IIF formula that compares against the thresholds (db fields). When this report is exported to excel, the colors are all red (NOT a good thing ... freak...more >>

How to implement Reporting Services to the Internet? -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 3. MIEMBRO ACTIVO DE ALIANZADEV http://spaces.msn.com/members/extremed/ ...more >>

I am designing a report to output address labels (Avery 5160) and the spacing of the data in the columns and the rows descrease as the print moves down the page. By the final row of labels, the name line is in the row preceeding row. I am using a list object and the margin settings are per A...more >>

Is there any issues with writing the security extension for RS in VB.Net. All the samples I have ever seen use C#, which I prefer, but company policy states otherwise. Thanks ...more >>

I'm trying to decide whether I can use sql reports for my application, and the main problem I've run into thus far is that my available parameters need to change based on the user who is running the report. For instance, low-level users should only be able to see data about themselves, whereas...more >>

Hi there, I made several reports using RS with SP1, they worked well untill I made a change: There are two parameters for every report - Network and Region, which were independent. I changed them to related, i.e whenever I choose a Network, then only show Regions under this Network. I made ...more >>

I have an ASP.NET page which shows a list of reports available in my reporting services with a checkbox besides each report.user can choose multiple reports to be rendered.Then I'd like the user to be redirected to another webpage an all the reports that he chose in the last step to be rende...more >>

Hi, I have a report that bolds font in a table cell based on an expression. This works fine when I browse the report in reporting services. When I export the report to Excel - all of the bold text returns to normal weight text. Any ideas to get around this? Thanks, Melissa ...more >>

I am using a custom data source. (using ADO.net dataset). I don't store the credentials on the report server. (basically I select the 4th option: Credentials are not required). Everything was fine till I installed RS SP1. Now whenever I run a report I get the following error: rsInvalidDataS...more >>

Our application is used by multiple companies. Each company has its own SQL Server 2k database. Each company has access to the same list of reports in SRS. We would like to deploy one physical copy of each report in the report database for simplest maintenance of RDL files. Our application...more >>

I've set up a report with sub-report which is using 2 columns. It seems that the multi-column setting is ignored when using sub-reports (works fine when opening the sub-report directly). Or am I missing something? Jens...more >>

From Report A, I have a jump action to Report B. Report B has 2 parameters. In Reporting Services Preview, after the jump, I can select the parameters , click "view report", and run Report B. However, after deployment, using Internet Explorer, I would click the Link in Report A, it will j...more >>

Hi, I scheduled a data driven subscription job that pass four parameters (server name, database, stored procedure and date) and generate PDF file into a shared drive. But I got error messages from the log as below. I don't know why it keeps saying 'GetSystemPermissons'. Can someone help? T...more >>

When accessing a report via a url, is it possible to wait until the user clicks the 'View Report' button, rather than running the report straight away with whatever default parameters have been set? Fred...more >>

Hi, Can i sort the records within the groups?? Thanks,...more >>

Can someone tell me where can we download and install the reporting services Or is it only available through CD. I do have a valid license for the SQL Server 2000. I will be connectiong to the SQL Server from my development machine where the VS.NET 2003 is installed, do I have to install th...more >>

I am trying to write a custom rendering extension for the SQL Server 2000 version of Reporting Services. The documentation I found on MSDN indicates that it is possible to write one using Visual Studio .Net 2003 (which is what I'm using). The samples they have are for VS.Net 2005. I'm tryi...more >>

I have recently installed the SQLH2 tool and upgraded to latest release. I also installed the SQLH2 Performance Collector and tweaked it so that it doesn't generate errors when I run the SQLH2 executable. My question concernes the Performance Counters report. Is there a detailed document that ...more >>

I have a date like 12/1/2004 12:00:00 AM. I need to subtract one month and display the three character month name so I can concatenate it. It should look like this: Nov Act 2004 Please help. Thanks in advance. ...more >>

Hi all, I have the report layout like this: Group1 Item1 Item2 ... Group2 Item1 Item2 ... .... I would like to alternate the background color on Items and Item1 always starts with the same color and alternate from there for the rest of the items in that gro...more >>

Here is an example SQL that might be useful to others. I was looking for a way to preview what folders and reports any other RS user is permitted to see. The API only allows you to see the catalog items viewable by the credentials used to call the API (Windows login), Plus, the Windows delegat...more >>

The requirements of Sarbanes-Oxley are getting downright outrageous. Everytime we run a report, we need to verify that the SQL statement has not been modified since it was last verified as accurate. To combat the constant requests to show the SQL behind the scenes, I would like to show the SQ...more >>

I saw post on the same issue but it is not answered. I use win2k server and reporting service standard edition. The register function works fine. But When I try to log on to http://servername/reports, I get the following error: Client found response content type of 'text/html; charset=utf-8...more >>

How can I create a Drill-Down Report for Excel ? I've created a report with several Lists. The visibilty of the lists depends on a Parameter: For Example: =Parameters!managementsummary.Value.ToString() = "0" This works fine for HTML and other outputs but not for excel. I always get a ...more >>

Hi, i am trying to filter the same data i have to two charts, each chart will count the number of cases submiotted by each person. Chart 1 to show all those with more than 1 case chart 2 to show all those with 1 case or less Each time i try and use the filter tabs i get errors. Would it ...more >>

Hi, I need to display the result set in a textbox, if there are multiple rows i need to show them as comma separated.. Can anyone give me idea of how it can be achieved.. Thanks in advance, ...more >>

Hi, im able to get the alternate coloring in tables using the code =iif(RowNumber(Nothing) Mod 2,"WhiteSmoke", "LightGrey") when i insert a group in the table for the weekenddate.the alternate coloring of rows has disappeared... i cant get where im going wrong... im grouping the record based ...more >>

I have created a drilldown report for Microsoft Reporting Services that I have rendered using the Web Services. However, when the user clicks on the "+" to drill down into the report, the NetworkCredentials are no longer remembered and so a logon dialog box comes up prompting the user for the ...more >>

Hi, I have a simple matrix table that only has one group. It has several columns, of which a couple are simple dataset field values, one is a calculated value from reportitems and one is a percentage value calculated from 2 dataset field values (ie field!amount.value/field!total=AD.value)....more >>

hello, how can have the mailto feature in rs? can someone please help me out on this? thanks....more >>