I would like to get different values of the same field to be displayed as a comma-separated list in a textbox at the end of each group. In dataset: Name1 Name2 Name3 .... In report this should look: Name1, Name2, Name3, ... I fugured out how to do this by using a class member vari...more >>

Can you pass like a parameter the name of user log in to reportserver. thx ...more >>

We are displaying our reports though a .Net program using soap. We have impersonate set to true. The reports come up fine and we have security in place to handle who can view what reports. I also have it set up so that if someone types in the default http://servername/reports, they will see t...more >>

I've just installed Reporting Services and am working through the walkthroughs. I am stuck on one that deals with subscriptions and sending reports via email. I used Report Manager to setup the report subscriptions, but I get the following status message: "Failure sending mail: The Report...more >>

Hi Is it possible to change the weight of a line in a line chart? There seems to be the option to change just about everything else but not the weight of the actual data line itself? Thanks Pete...more >>

I am upgrading the server that houses the SQL Reporting Services databases (RSwwebservice, IIS and Report Manager are on another box). The new server will have the same name (fqdn) as the old one. Any issue with simply backin up the SQL RS dbs and restoring them the new new server? Thanks...more >>

Hi, I am trying to set up a data-driven subscription. But the button is not visible on the subscriptions tab. I have also made sure that 1) the report uses stored credentials. 2) A report that includes parameters. 3) The report server that is configured to use the e-mail delivery exten...more >>

Is it possible to populate report parameters based on another query using parameters from within the report itself? Thanks JML...more >>

Good Day, I would like to create 3 roles in SQL Server 2000 Reporting Services but do not have corresponding NT groups. The sys-admin has asked that I do not create these 3 NT groups to use in Reporting Services, but to find some other way to create these roles without corresponding NT grou...more >>

Hi I'm trying to put a like in a filter e.g. to select where string like '%abc%' What is the exact syntax for the string when putting in the value I've tried "%abc%" '%abc%' %abc% and others but none seem to work. Any suggestions please? Thanks Pete...more >>

Hi all, I'm really new at reporting services. I'm hoping someone can help. I have a subscription that runs daily. The MSDN tells me "AutoIncrement, the report server appends a timestamp or number to the file name to distinguish it from existing files of the same name". Currently the number is...more >>

I’ve built a report with a subreport at the bottom, both pulling from a ‘Dataset1’. I’ve also created a ‘Dataset2’ which returns a title, a report name and a few other fields via textboxes (similar to Value=ReportItems!Title_1). These textboxes are strictly used in the page heade...more >>

Help!!! After applying SP2 beta to my Test Server I get the following message when launching the Report Manager: "The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.6.54'. T...more >>

I am using the ReportViewer.dll in a ASP.NET web application. The report being displayed takes 2 parameters. One of these is programmatically set. I would like the user to select values only for the other parameter. So when displaying the report within the control, can I just show the second ...more >>

Hello! I've met the following problem in my reporting services experience: How should I behave when I need to display such information. There is for example 4 cell in a row. But when I receive from the dataset rows of another type, I need to turn these 4 cells to 2, so I mean to merge them. B...more >>

Hi, I keep getting this error when I try to export my report to Excel: • Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help o Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderi...more >>

Hello, I just made a fresh install of Win2003 with VS.NET and SQL server 2000 with reporting services. When I started to do some test projects to see if everything was working again and to see what the reporting services where I ran into some problems: - first I started a new reporting p...more >>

We have reached the maximum length that Report Designer allows - 180 inches. The problem is that we need to make the report longer. Also - it appears that the maximum size for a rectangle is 60 inches - this also is too small. Does anyone know how to report these items to Microsoft Reporting S...more >>

I have a table in Database A with users and a table in Database B with call log records. I need to report the call log for each user in the User table, sorting by Dept (User table) and then user (user table). Call data will be detailed for each user. Report will run with a date range selecti...more >>

I have a table in Database A with users and a table in Database B with call log records. I need to report the call log for each user in the User table, sorting by Dept (User table) and then user (user table). Call data will be detailed for each user. Report will run with a date range selecti...more >>

Has anyone attempted to get user information for reports using the SYSTEM_USER function (something like this would strip the domain name SELECT SUBSTRING( SYSTEM_USER, (PATINDEX ( '%\%', SYSTEM_USER))+1, 255)) instead of User!UserID. This seems like a viable option yet I don't see any threads...more >>

I render a report on a asp.net page, I need the report and linked report to be in a new bowser window. My code is as following: result = rs.Render("/DemoRPT/AMSMRPT", "PDF", null, "<DeviceInfo><StreamRoot>/UniReport/</StreamRoot><LinkTarget>_parent</LinkTarget></DeviceInfo>", par...more >>

i need to move the reporting server from one database to another. i deployed all the reports to the new server. how do i get the execution logs from the old server to the new server. all the keys have been modified. is there any easy way to do this?...more >>

I have a report that is a certificate that show how many diamonds will be added to a ring for a ring order. the options can be 1 thru 14, the sample we were given displays this area like this: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 I h...more >>

I have verified that iwam_computer is enabled and in sync. error mesage - Internet Information Services 5.0 (IIS) or later is either not installed, or it is configured in a way that is incompatible with a Reporting Services installation. log - Microsoft SQL Server 2000 Reporting Service...more >>

I have been trying to determine if I can run a different stored procedure base on a parameter value. I have a stored procedure on each of my SQL Server machines that lists the SQL Server jobs. I would like to be able use a parameter to list the SQL Server machines, select one of the SQL Serv...more >>

I am using a hiden report parameter to track changes in an integer value. I need to dynamically add, minus, times or divide this integer by another value, for item on the report. What I need is some way edit the default parameter value either in the field expression, or by using some custom co...more >>

Help!! I rand DCPromo on the report server. The /reportserver management page used to work fine, but now I get this error accessing the page: "File or assembly name xxx.dll, or one of its dependencies, was not found." where xxx.dll is a random alphanumeric hash that changes each time I...more >>