Hi, We are experiencing inconsistent errors for report subscriptions. Subscriptions are showing either of the following 2 errors: - Failure sending mail: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. - Failure sending mail: An unexpected...more >>

Hi, I have recently got started on Reporting Services using the excellent book by Mr. Teo Lachev as reference. I am stuck, however, on the use of the ReportViewer Server Control. I compiled the project that was located in the SQL Server folder, and then added the .dll server control comp...more >>

Hi, Is there any way to have different Sizes of Page Header in different pages Ponnurangam ...more >>

I'm doing a proof of concept on Security Extensions using the Sample Security Extension. I've implemented the Sample Security Extension without any problems. It's worked successfully with our WinForms application, which manages Reporting Services using the Web Services. However, the WinF...more >>

Hi We are using SQL reporting services as the reports engine on our projects. Some reports come with a table view and a chart view. User wants to see (print) the table report first by default. The chart report is optional. The original approach is to have a link (button) on the first re...more >>

Can anyone provide me pointers to how error handling can be done in SQL Reporting Services? Thanks...more >>

In the RSExplorer sample, what is the reference AxInterop.SHDocVw? I can see that it points to some DLL named AxInterop.SHDocVw.dll, but what is this DLL? Thanks. ...more >>

Hi When I run the following RsConfig -e command for Unattended execution, I get the "System.Management.ManagementException: Not found" error. Does anyone know what the problem is? C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsconfig -e -u Sqlusername -p SqlPassword -t System.Mana...more >>

I have a chunk of SQL that is use if a particular report needs to have a point in time parameter. Is there any way to store this code so any report in the solution has access to it? I don't want any business users that develop reports to have to type all the SQL in every time. Any thoughts?...more >>

I am attempting to install Reporting Services on a 32-bit application server with the database on another box running SQL Server 2000 "Enterprise Edition (64-bit)" . I am receiving the following error: "This edition of the Report Server Database is not supported on the edition of SQL Server ...more >>

Hi, I am using a symbol(Character code: 216) of Wingdings font, it displays fine in ReportPreview . But when I export the same to PDF, it shows me some weird Symbol. Sometimes it does not display some symbols or special characters in PDF This happens in some other fonts also It's ver...more >>

Hi, This issue is driving me nuts (well.. more nuts). Our invoices have lines which run from the top of the page to the bottom. How would we achieve this in reporting services assuming we are using a table to show the items on the invoice? thanks Matt ...more >>

Hi We are trying to setup security on the RS server and looking for some pointers to get started. By default, the BUILTIN\Administratots group has been setup for the reports when you open the Report Manager. We would like to define a new group of "users" who would have access to only view t...more >>

Reporting Services is on its own Win2k3 server , running a report that does a query against our Production database using Windows NT Integrated Security. The query never returns any data, yet when I run the query in Query Analyzer it works fine...I have another report that uses "Credentials ...more >>

Hi I am trying to get the HTML viewer help file to appear. When I click the help icon I go get a new window with the URL http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm which is blank ( file exixts on the server ) when I goto another server http:/...more >>

Anyway to put the Totals column to the left of the data column? ...more >>

does any know if SQL server reporting services will be offering a RTF format export or Word export?? I need this function - it force me to use crystal reports (ARRGH!!) Or does anyone know of a provider that made one? ...more >>

Hi, A field in my query returns the address formatted with carriage returns (using CHAR(13)) like so: Address = Name + CHAR(13) + Address1 + CHAR(13) + Address2 + CHAR(13) + City + SPACE(1) + State + SPACE(1) + PostC...more >>

Currently, I've got two filters to give me a date range: Expression: =Fields!LastConnectDate.Value Operator: > Value: =Parameters!start.Value AND Expression: =Fields!LastConnectDate.Value Operator: < Value: =Parameters!end.Value This works great, but I would also like to includ...more >>

Hello, Is there a way to export multiple reports(lets say 2 different reports) into one Excel book at the same time?? please help -- Saptagiri Tangudu PNT Marketing Services...more >>

Yello, We have a very simple report that lists the contents of a table called GenericReport that contains one field of varchar(120). All the report needs to do is list the records in this table. Unfortunately, I'm finding that RS will pick up the text from a record, and strip out any spac...more >>

We have an issue where emails can be sent with links but not the reports themselves, this error being returned in the logs: AuthzInitializeContextFromSid: Win32 error: 234 There is a previous post regarding the error which I can't find a complete answer to. Anyone have any thoughts? ...more >>

Hi All We are having a problem after XP SP2 is installed on the user's machine, the export to PDF no longer works as instead on opening the report in PDF format inside the browser it actually tries to save the .aspx page, I think it is something to do with MIME types. Has anyone noticed thi...more >>

I have an issue with setting up permissions on report services manager. I have four folders that represent different companies, and I have created users on this server, that are set up to be browsers on selected folders. None of theses users should have rights to view the other folders, unless...more >>

When I attempt to set up an snapshot execution I get this error when clicking the execution link: Invalid object name 'ReportServersTempDB.dbo.ExecutionCache' Background: IIS running on - Pentium, Server 2003, 1.8GHz SQL is on - Itanium, Server 2003 64 bit As far as I've seen everyth...more >>

I am getting an error message that I can't debug. Processing Errors An unexpected error occured in Report Processing. Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Now the problem, I am running reporting services off of a...more >>

Good morning to all. I am running into the same problem with PDF attachments within a subscription as many posts talk about, except we are using Exchange rather than Lotus Domino. I haven't found any information relating to this problem. The attached PDF has a size of 4 KB, but when I open ...more >>

Hi I have a report where I need to Sum the values of a group and not the details row. Group1 Sum(Value) 'but only for all the Values in Group2 Group2 Value Details Value Details Value So Group1 should display the sum of the values in Group2 and not the...more >>

Hi, I have a report with various charts, table, matrices and textboxes. The data and the charts overlaps somewhere when I export it to PDF. Also the page size of the report is different from that rendered as PDF. Do we have any control on that? Is it possible to change the PDF render page s...more >>

Hi, I have a chart which has scalable Y-axis. I want to set the scale of the Y-axis dynamically when the report loads based on the maximum and minimum values the Y-axis variables can take. How do I do that? Thanking you, Jd....more >>

Hi, I want to provide the functionality for exporting reports to rtf/gif/jpeg from the html report viewer. How do I do that? Is it possible to add/remove formats from the export list on the reportviewer. Thanking you, Jd....more >>

Hi Can someone please tell me why =Code.MyConversion (Globals!ReportFolder) does not work but =Code.MyConversion ("123456789") does work. ?? the argument is of type string Thanks Francois...more >>

How to change parameter sequence in reporting service ? Is it possible ? How ? Thanks....more >>

Hi, when I deploy a report - where does it go? As in, are each of the individual reports sent to some folder somewhere, or are they bundled into some dll or something? All I know is I've set my deploy location to http://<machinename>/reportserver - but can't see the reports in that folder....more >>

Is it possible to sort a table by the subtotal value. I found many references to other sortingf requirements, but none about sorting grouped data by the subtotal value. I.E. Sorted Desc Group1 100.00 Group2 99.00 Group3 50.00 I can...more >>

Good day, I would like to know if it is possible to do the follwoing. I have a report that has 3 parameters. What I would like to do is when the user seects the first parameter the second parameter drop box will be populated with options available according to what was selected in paramete...more >>

Hi Can the user not change the graph type at run time the same way you can change for example background colour. I want to have a parameter for the user so he can choose line, bar or pie for the same graph. Thanks Francois...more >>

I wonder if someone can help clarify this one..? If I’ve implemented Reporting Services across a Web Farm, and saved a copy of the encryption key for each node – If encryption is broken, which key do I apply? Thanks, Mark ...more >>