I have been setup reporting services success, but after I modify the password of Sql server's default user--"sa",the reporting service can not run, I uninstall the reporting services and try to install it again, but cannot install success. And I modify the password back, also cannot install su...more >>

how can choose more than one parameter in one parameter ejemp id name 1 a 2 b 3 c 4 e I would like can choice 1 and 3 and 4 and same time. thanks ...more >>

I have a check printing functionality which is implemented as an rdl. The check number needs to render in MICR . When the report is rendered in pdf, the MICR font is not getting displayed. I have installed the MICR font on the machine containing the RS and restarted it. Where else may I be goi...more >>

in one of my projects i was dynamically setting the Language property of tables, textboxes etc , but it just wasn't working.. For my needs i solved the problem by rather setting dynamic Formats however i still thing this is a bug.. it is shown in the example below.. i have textboxes where eac...more >>

I have a report based on a stored procedure with three parameters: Start Date, End Date, and Salesperson. The first two are required, and the Salesperson is not. In the report, the Salesperson is based on a query which provides a drop down for choosing a name. It is set to allow nulls and b...more >>

I have a business need to allow the user to render a batch of "End of Day" reports with one event click. All of these reports currently exist as separate reports in Reporting Services. I can schedule all of these to run together but I'm wondering how I can handle ad-hoc requests to run them?...more >>

Hi, I am publishing my reports to a server and for 2 out of 7 reports I receive the following error message: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was thrown. On my machine the reports worked fine. The server does process the other reports correctly. Th...more >>

Good Afternoon! I've run into an issue whilst developing a report using VS.NET, RS and SQL Enterprise Server 2000. The problem I have is that I'm using RS to develop a web based app that can be used to edit base table data. I have the app working fine, but it keeps taking it's data from...more >>

I'm Managing Reporting Services in a mid-size company, and we are just beginning to develop reports for different departments....We just set up a new server and redeployed all of our reports (there were just a few so far).... My question is..What happens when we have hundreds of reports and ne...more >>

I am trying to deploy my reports onto a report server. I am using Windows authentication and I am the dbo. The test connection in the datalink properties works fine, both to the database and to the report server. I have tried with SSL and without SSL. Neither works. The error is: ...more >>

Hi Freinds, SQL2005 beta, I create a subscription and want to email report based on a schedule. It doesn't seems working, no error either. Where can I track it down? Which config files keep the mail SMTP information? Thanks, Pat ...more >>

I am streaming an MHTML file to an aspx page: Response.Clear() Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht") Response.AddHeader("Content-Length", MyByteArray.Length.ToString) Response.ContentType = "multipart/related" Response.BinaryWrite(MyByteArray) Response.Flus...more >>

When we have installed the Reporting Services, it leaves an error to us in event to viewer. This it is the error: Schedule and delivery processor Error id event 113 somebody has had this problem? Thanks ...more >>

When you upload a file in RS - it just gets put in the folder that you are currently in. Does anyone know where there file is physically stored? I uploaded a file and did a search on our RS server and it came up with nothing. I am able to delete my copy of the uploaded file so it's gotta ha...more >>

How do i render a report in Excel using Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer? I have the RDL file available. I need to use the RDL file and render the report. I could do this using Web service. But how to do this using rendering extension?...more >>

I am receiving the following error when trying to run my report from the server: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'SALESLOGIX'. (rsErrorOpeningConnection) Get Online Help The 'SLXOLEDB.1' provid...more >>

Hi, I have one report format for many clients. Some of them request different fonts and font sizes. I don't want to duplicate reports because of differnt fonts. Is there a dynamic way to change font or font size using only one report format? Thanks. Chuck...more >>

Hi, I have one report format for 20 companies. Some of them require differnt fonts and font sizes. I don't want to duplicate reports because they need different font format. Is there a dymanic way to change font using one report only? Thanks. Chuck...more >>

I've created a custom assembly using C# that provides utility functions for reporting services. I'm getting a the following compile time errors. 1. Error while loading code module: 'accentopto.report.utilities, Version=1.0.1885.19928, Culture=en-US, PublicKeyToken=null'. Details: File or as...more >>

Hi All We have a .net application calling some reporting services reports and we pass the parameters to the reports from the application. When no data is selected, is there any way to pass a paramter or something back to the .net application so that we can display a 'No data selected' me...more >>

I need to be able to schedule a report with a dynamic parameter. For example, The user may select "Start of Last Month" as the date parameter value. I then need to turn this into something like : CStr(Month(DateAdd("m", -1, Date))) & "/01/" & CStr(Year(DateAdd("m", -1, Date))) When sched...more >>

I have a table like this: Product M1 M2 AddCol ABC 3 2 5 DEC 4 5 9 DEF 2 4 6 The third column is the addition of the previous two columns. (The actu...more >>

I have a report with a table. Initially the details are hidden and the table looks like this: +Item Summary1 Summary2 Summary3 What I want to do is to hide Summary1, Summary2 and Summary3 when I expand Item and leave Item visible. Is this possible?...more >>

Hello, I have been trying to create a report which gets the Name and ID of a person and then print an X in the column of a Head H if the person belongs to the Head H. In the Stored Proc I insert a 0 if no entry exists under the head for a person or the # of times that persons name is under th...more >>

I am using a Table and I wanted to add all rows above for particular columns. It it possible without using the = Sum(Fields!HistoryDollars.Value) ? I certain Fields that if I use the =SUM() they will not work correctly. Maybe by referencing the the controls inside the Table? Thanks Pe...more >>

I need to change the sheetname with the field value retured by the stored procedure. Say the stored procedure returns 10 rows, when exporting the report , the report should contain 10 sheets with the sheetname(field 1 value). How can I do this. Balaji -- Message posted via http://www.s...more >>

I am working on an automated report deployment tool. I'm working on the last feature, being able to override the datasource in the RDL to point to a common shared one in a specific directory on the report server. I have the data source reference override working for after a deployment. Bu...more >>

Hello, I have a relatively simple report (no sub reports or objects nested in table cells, etc) that apparently runs fine that I can export to any other format with no problems. However, when I export the report to Excel format I get this error: Index was out of range. Must be non-negativ...more >>

I am having a problem getting a report with many charts to export to PDF. Currently the report contains 52 line charts (possibility for much more than that)and fails when the subscription is running. If I only choose data that returns about 10 or less charts than it will successfully create ...more >>

I'm trying to get this URL to hide the parameters and pass values directly, but it always opens with the defualt parameters. http://sql_box/Reports/Pages/Report.aspx?ItemPath=%2fAM%2fAM+Stats&rs:Command=Render&rs:Format=HTML3.2&rc:Parameters=false&StartDate=2/1/2005&EndDate=2/10/2005 ...more >>

Hi all, I'm getting an odd problem installing Reporting Services, hope someone can shed some light. First a bit of background. I had RS SP1 installed on SBS2003 and it was working fine. Joined the SP2 beta and installed this. At first it seemed to be working OK including web parts on t...more >>

Hello, I have a problem installing Reporting Services on a SharePoint Portal Server. I have followed the procedure outlined. I have followed the procedure listed in the msdn article for troubleshooting a side by side installtion of reporting services and Windows Sharepoint services listed here...more >>

I am getting this message: rsEvaluationCopyExpired This copy of the Evaluation Edition of Reporting Services has expired. I downloaded this version from internet and I thought it is free. Is it not? How should I solve it? Thanks, Jim. ...more >>

Is it possible to acces some attributes from a report??? I mean, I wolud like to display or hide a table if the subreport is empty? is there a value from the subreport that i can use?? my expression would be like: =iif(subreport . ????? = XXXX, AAA, BBB )...more >>

Hi, I have a matrix where a couple of columns are percentages derived from other fields. It is possible that one of the fields I am trying to divide on will have no data. I am using the following expression in the Value property of the textbox. =IIF(Sum( Fields!previous_month.Value)>0,(Su...more >>

Hi, I have a request for dynamic creation of the chart axis scale at runtime from some users, based on the displayed results. Is this possible? Thanks...more >>

Good day I am using the CreateResource method (C#) to upload a jpg file to a report server. I have completed this task, however I am manually navigating to the Report Manager, going to the Properties section of the jpg file and checking the "Hide in list view" checkbox. I am sure this ...more >>