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 >>

Installed and worked great ...more >>

I would like to add my own logos, fonts and layouts so the Report Manager user interfaces better fits in with our site. Is this possible by editing HTML templates or style sheets? Thanks, Steve ...more >>

How does Reporting Services handle multiple report requests simultaneously? ex. I have 800 users that all run one report at the exact same time or they each run different reports at the exact same time. Does Reporting Services que up the reports in an arbitrary order? Do all the reports...more >>

How does Reporting Services handle multiple report requests simultaneously? ex. I have 800 users that all run one report at the exact same time or they all run different reports at the exact same time. Does the report server que up the reports in an arbitrary order? Do all the reports pr...more >>

When I try to deploy the sample reports solution to the local IIS on this win2003 server, the message "A connection could not be made to the report server http://a1900/Reportserver" appears. I do this by: 1. Loading the SampleReports.sln into the vb.net IDE. 2. Right-clicking on the SampleRepor...more >>

Is it possible to change the font, for example to font-family Arial, for all the existing reports made in reporting services. -- regards, pakam...more >>

Hi everyone. I had developed with SQL server & Reporting services now I would like to combine SAP with reporting services. I am just starting to look for information. Does someone knows of possible complications?? Why there are a lot of software for accessing the BD from SAP (e.g. Software...more >>

Hi Everyone, Are there third party .NET controls that can be added to the RS Visual studio environment and that can be used in reprts , where these controls would extend the graphical library already currently shipped with RS? I am looking for guages, cones, pyramid type controls where I can ...more >>

anyone can tell me how it is used it in Reportviewer to render drillthrough links in the same page. I have been experimenting for a while. would like to know if anything i need to take care of thanx ravi ...more >>

have a report that has about 7 columns I would like to enable the user to be able to resort the report by simply clicking on a column heading. For example if my Column names are County Organization Name Program Name I would the user to be able to click the County Column header and re-s...more >>

hi, I am trying to programmatically create a linked report and I'm not sure how to specify the parameters for this linked report. Essentially, I have a parameterized report and a list of values for all the parameters in this report, entered by the user from my custom website. The idea is ...more >>

Hi, Do you know if any command I can use to pass parameters into reports, generate PDF report format and drop it into a shared folder? Thanks. Chuck...more >>

Try putting in folder in the Start Path on the Report Explorer Web Part. Then put in a sub-folder. It doesn't work. This is a bug. ...more >>