I keep getting asked credentials when I try to login to the above site. Now matter what credentials I use it just gets prompting me. The most frustrating thing is that there are no real errors in event viewer. I get the 401.1 and 401.2 depending if I change basic auth on the IIS side. Any ...more >>

Hi We've got a oddity when exporting to Excel. If you export the same report to Excel twice in sucession (don't refresh between - just export) some report give different results between exports, with some columns being shifted. Subsequent exports seem to be conistent. The problem may be rel...more >>

Hi, I have a LocalReport to which I'm trying to add some code to (Report Properties -> Code). The code is fine syntax wise, but when I attempt to use it in the Expression editor, the function never appears. Other examples seem to just add the function into the code window and it just shows...more >>

I am trying to create a report with many subreports in the detail section. I have as many as 4 subreports on one line (lined up next to each other). The problem is, even if they are spaced evenly in the layout tab, when I preview the report they aren't spaced evenly. If I include some graphic...more >>

Im trying to make it so my drop down box on the parameter for my report automatically fits or at least I can specify the size. Im using ssrs 2005 and there is a sroll bar on on both sides. I would like to increase the size so I dont have these but dont know how to. PLEASE HELP!!!! ...more >>

bs"d While creating the report I looked for a way of filtering the data by "WHERE" to compare two attributes such as ( customers.name = friends.name ) Is there a way to do it by the gui setup? -- dai...more >>

What permission is required to be able to go into the "My Site" settings in the Report Manager? Is it looking for a specific permission in the ReportServer database, config file, or some machine permission?...more >>

Hi folks, I've been searching for a way to get mulitple sub total rows. Here is the requirement. I have a report that looks like this DataCol Emp1 Org 1 Expense1 3 Expense2 5 Expense3 6 Org 2 Expense1 1 Expense2 7 Expense...more >>

I have a report that asks for two dates and wanted to control that the difference between two dates is not superior to two months. Exists some way to control the dates before clicking the button of "View Report"? Thanks,...more >>

Hi all, i have a question, i'm making a report in visual studio, where i have a textbox which i fill with a value from a database and i wanna know how you can change certain strings withing the filled value.... example: This is the expression for the textbox: =First(Fields!MyFieldName.Value...more >>

I have a report in SQL Reporting Services 2005 which calls a stored proc and the report takes a very long time to run and sometimes returns zero records. But when i run the stored proc in query analyzer it takes about 4 seconds. I have checked the execution log on the RS using the below sql: ...more >>

Does anyone know a field to display the report last updated date or version in a generic report footer for my 5th grade computer class? I did this in 4th grade on Crystal and it was too easy. What's up with Reporting Services?...more >>

Hello, I just wonder if there is anyway to compress the report before sending it to customer via email? Thanks Hooman ...more >>

In Report Manager, using a parameterless report or a report with parameters that have default values, if one clicks on the report link in a folder, the report automatically begins generating and then the data is viewable. Is there any way to prevent the report from being (automatically) gen...more >>

Hi all, I need to create some reports in my company and I have SQL Server 2000 and Visual Studio 2005. Well, to create reports I will use the tool Report Server from the SQL Server 2000. When I try install RS I can't because I don't have the Visual Studio 2003. Can someone help me? ...more >>

I have a report that requires 2 "tables". The first table summarizes total lbs by a category and then provides a company total at the end: cat 1 75 cat 2 100 cat 3 200 ------- total 375 The second table needs to display the % of the total for each category: cat 1 20%...more >>

Hello All, I will Appreciate assistance I getting the following error "Syntax error converting datetime from character string." when I run store procedure as follow: exec Store_Procedure_Report5_test1 '06302007' (which the input parameter is from type of datetime) The Store procedue l...more >>

All: I am having a problem with Microsoft Reporting Services. I am running a local report (RDLC) on ASP.Net. Running the report obviously can use a lot of memory because it must consume ADO.Net. My problem is that the report does not seem to be very good about releasing the memory. It...more >>

Hi all, I have to desing an applicaiton which allow user to generates repots. it should allow user to drag and drop image from file system, allow to change text in a page and also allow to export this repot to PDF, Word, RTF, PPT all other fomates. Could you please advioce me how can i start...more >>

We have the need of constructing a report with a main data category and two subcategories, meaning the following: One customer can have n phone numbers (so it is a 1:n relation from customer to phone numbers), and one customer can also have n orders (so there is again a 1:n relation from the c...more >>

How can I have different reports deploy to different subfolders? all of them are currently going to same folder. TIA Dean ...more >>

Has anybody tried to display a Google Map inside a report using Reporting Services? Thank you, Alain Quesnel alainsansspam@logiquel.com ...more >>

I have a matrix and would like to be able to add to the column titles the column number. I have been looking for a function maybe similar to the rownumber() function, but cannot locate anything for column number. Is this a possibility? Thanks! ...more >>

OK.. I'm stumped. My IE 7 is working fine. I can access any websites I want with one exception. What is this exception? I recently installed MS Reporting Services 2000 on this computer. All went well. When I try to access the http:// site where all of my reports have been deployed,...more >>

I am printing report using custom print. For each page it prints an empty page. Is there something I can do? Thanks ...more >>

Good evening. This may be an easy question but I am using SMS Reporting (which is SQL Reporting Services) to generate reports for inventory collections, etc. I am not the greatest with SQL but is / how can I display plain text in my reports? This text is descriptive / comment text and not ...more >>

Below is the query and a screen shot of the report layout - I want to show only the top 10 totals in descending order. If I add top(10) to the select now - it only shows the top 10 clients within a service instead of the top 10 services sold. How do I make it look at the sum total and show ...more >>

Question: Can you have a report were the top half is filled in with one query and the bottom half is filled in with another query??????????????? I have a report that is just fine right now. I was asked to have the comments to the agency print at the bottom of the report. Query1 is big, ...more >>

I am using RS 2000 Eval Edition I have just enstalled it on my notebook. This is where my existing copy of SQL Server 2000 resides. The SQL 2000 Server is working fine (as it has for the past several months) I installed RS 2000 Eval Edition using all of the "default" settings. I then ...more >>

We have an MSRS2000 extension that was originally written under VS2003 (.NET 1.1). We have updated our extension and compiled it under VS2005 (.NET 2.0). We now use the extension under MSRS2005. We would like to use the same, .NET 2.0-compiled extension dll under MSRS2000, but receive e...more >>

I have chart with data grouped by years and months. My data stops in Jan 2010 and the chart is showing this data with a year grouping of [2] instead of [2010]. It appears to be truncating the year because it there is data for only one month and it is the right most value in the chart. Any idea...more >>

Hi. I want to intercept any errors generated when the report's stored procedure executes. I've created a handler for the ReportError event but it never fires. My web page is in C# and has AutoEventWireup="true". I even tried explicitly adding a handler... theReportViewer.ReportError += n...more >>

I am trying to create a .rss file that deploys my reports to the report server. I have everything working except for the creation of the datasource. The problem is that I am using an Oracle database and I cannot set the correct setting in my code. I can create a datasource; but I have to ...more >>

After a server failure and subsequent restoration to new hardware reporting services is only allowing members of the builtin/ administrators to view the reports (or any of the report listing pages for that matter). The steps employed after the restoration from backup to new hardware that I to...more >>

Just wondering if MS Report Builder is a good tool for creating adhoc reports on very large database that contains dozens of tables, several of them containing 8 million records each. So far I have found it takes very long time if your output (report) contains several thousands or pages. If any...more >>

I am trying to find a way to add a simple trend line to a line graph in reporting services. I have been unable to find how to add a linear trend line. ...more >>

I am trying to create a set of parameters that will alow me to select data either based on criteria from dropdown boxes or from a text box. In my DataSet I have something like this (simpified) if @ItemDesc is null select citemno, cdescript, 0.0 as price from icitem where ..... else ...more >>

I am running SQL 2005, I have the latest service pack on SQL 2005 and also on the Windows 2003 server. This is on a single server. I am using my Exchange 2003 server as my SMTP server which is on a different server with the same subnet. -When a domain user schedules a subscription it won't ...more >>

Hi there. There's an iif statement that I'm struggling with on Reporting Services. This statement is on a calulated field. The iif statement is as follows: =iif(x=0, 0, ((y-z)/x)*100). In other words, if x is zero then 0 must be the output. Else the above formula must be the output. The...more >>

Hello, I have two DateTimePicker in my report. The first day of week is Sunday but I want to change it to Monday. How can I change the first day of week? Thanks and regards, Stefan ...more >>

I am running the Report Services website on IIS6 on WIndows 2003. When I browse to the /reports website on the server, I get a message in big red letters saying that the server is not avaialbe and that more info is in the event log of the server. When I look at the server's Application event...more >>

hi, I'm having issues exporting "large" Reports into Excel. These reports create 11 separate worksheets with most not going over 7-10K rows on each sheet. I have been able to export "smaller" reports that have the same 11 Excel sheets but perhaps not as as many rows (1-2k a piece). ...more >>

Hi, what would be the best way to call the same report with diffrent parameters. right now I am calling the RenderInvoice which is called in a loop (view code below) is there a better way to do this, like a batch process? this works, and it does 50 reports in about one minute, I wonder if I ...more >>

Hi, My custom code i have written try catch end try block and in the catch section just i returned the err.description. But locally it was working fine. Once deployed it was not working fine. just showing #error. Any help would be appreciated. Regards, Sri....more >>

I have a report where I use Globals!ReportName in the header of the report for the report title. In Development and on SSRS stand alone the value for Globals!ReportName is in mixed case and the file extension is omitted. When the report is published to a MOSS server integrated with SSRS the ...more >>

I have parameters that are too long to fit into the dropdown box which then requires horizontal scrolling. How can i change the width of the dropdown controls? TIA Dean ...more >>

Hi All I have a From and a To Date in a SQL Server 2005 Reporting Services Report. How do I go about restricting the To Date so that is can't be less than the From Date and also so the To Date is no more than 12 months greater than the From Date? Thanks...more >>

I am a new to SQL Reporting service. I want to know the following, Please help I have got SQL Server 2000 machine, with the Reporting Service and Report server database installed in it. My Reports are already deployed there. I have lost the Reporting source code after deployment (i.e. .rdl f...more >>

OK... I've made a boo boo... I added IUSR_... as a user with browse only role... I now know I should not have done that.. however, now I can't log on as administrator! It automatically logs me on as IUSR when I browse /server/reports, so now I can't remove the user.. I even went into ...more >>

Hi I was wondering, I previously worked with Crystal Reports and in this offered the functionality of Multiple Sections, in the Report Header/Footer, Page Header/Footer, Group Header/Footer and multiple Detail Sections, I cannot seem to work out how to do this in SSRS, whilst building repor...more >>

Hi, We have a scenario where we want to test the <a href> url generated by parsing the <Hyperlink> element present in the rdl file This check needs to be done without deploying the rdl file on the report server. So we are planning to use Local processing mode of the report view control. ...more >>

Hi all, I have a requirement to get at the underlying data which SSRS is serving up to its renderer, prior to rendering. This is so I can use SSRS report builder etc. to create data exports which I will then format into very specific output formats for sending to other systems. In this resp...more >>

Hi I currently use SSRS2005 and I develop reports, for use in our company. My question is, I was wondering if it is possible to embedd some sort of tag, which holds version information, since some of the reports that we develop go through several iterations and it would be useful if we cou...more >>

I am trying to access my report from my laptop. Both development computer and a laptop are on the network with DC. I am using http://devcompip/reports but I am getting prompted for the network password. I am trying to enter it but it keeps prompting. What's a problem? Thanks for help. ...more >>

Hello all, This issue has been a major pain point for me with the new SSIS license model. In the past, I would create MSDE back-end applications and delpoy the DTS runtime with the packages to handle Import/Export processes. I used the DTS runtime because for Imports and Exports since it...more >>

I have a report that when I view it in IE works fine. But I try to print it using custom report printing I am getting an error: An error occured diring printing. Here is a log entry for that: aspnet_wp!cache!f28!06/22/2007-15:40:54:: i INFO: Item not cacheable: - PersistStreams /Accident Re...more >>

Problem: When I try to run the setup for Reporting Services it fails near the end, stating the following: Product: Microsoft SQL Server 2000 Reporting Services Standard Edition -- Error 29581. SQL Setup failed to execute a command for server configuration. The error was: Database 'Report...more >>

After I develop my report on my development computer how do I actually deploy the report on the client's site? Thanks ...more >>

Hello all. After a brand new install on my dev machine, I am unable to browse the ReportServer or Reports web apps under my local IIS. I am prompted to Authenticate 3 times then I get the following error: "HTTP 401.3 - Access denied by ACL on resource Internet Information Services" I ha...more >>

Hello: I am trying to find out if there is a way to print a particular page from the report in SSRS2005 Report Manager. Right now I have several reports that are formatted to be printed and exported to Excel and PDF. Everything is working fine when a full report is printed. The problem is just...more >>

I need some help, this is my first matrix report. My stored procedure pulls data in the following format. Internal_User user_id expense_user_id Amount category Period month year Doe, John 99 1234567 385.7900 Airfare May-2007 ...more >>

I'm trying to call a report I created (and deployed to our dev server - running reporting services 2005), while passing the parameters on the URL. I think I'm very close, but it doesn't seem to like the format that the date is in. However, I've tried everything I can think of (surrounding the...more >>

I have a report on reporting server that I need to email as excel file weekly. As default it comes with document map as the first excel tab when exported which I need to stop from happening. I have found on the internet that I can use this <DeviceInfo><OmitDocumentMap>true</OmitDocumentMa...more >>

Hi. I'm using the web ReportViewer. I've got drillthrough working ok, but in some circumstances I'd like to cancel the drillthrough and leave the user looking at the original report. The _Drillthrough event has a DrillthroughEventArgs parameter with a Cancel property. If I set it to true t...more >>

We have couple of group in table on one group when we try to export to excel it supress the data visible to the user. Suppose i have 10 lines to display it supress 8 lines and show only 2 lines as the size of it is as such. What property can we provide to dynamically increase the row height ...more >>

Hi I have a strange problem with creating subscriptions for my reports. I can create them in Report Manager, but when I right click the subscriptions folder in the report in Mangement Studio, "New Subscription" is greyed out. The data source uses stored credentials. To further add to the conf...more >>