We are still having issues running certain reports that take up to 100% CPU and eat memory like it is candy. Some of these are not very large. Could this be due to the fact that IIS, MS SQL and RS are all running on the same box?...more >>

I had to uninstall Report Server and Report Designer on are SQL server machine because of bandwidth concerns. Instead, Im installing Report Server and Report Designer on a different member server. However the Report databases remain after the uninstall on the SQL server machine. Is this ok fo...more >>

In a drilldown report, is it possible to sort by an aggregated column like total? Here's an example of what I mean. I would like the final report to sort by TOTAL in descending order. original data set: region state sales ------ ----- ----- East NY 500 East MA 100 West CA ...more >>

Hello Everyone, Is it possible to format the textboxes that are used for parameters. For example a string field is double the length we require. We show 9 characters but it show 27 characters. This is a great product, the user friendliness of the parameters is causing issues with the di...more >>

i'm trying to make certian stuff inside a table header be shown on the first page ONLY ,and other stuff hidden on the first page.. I'm having a lot of problems in the end i want to put hidden.visibility to be based on some logic, but i've found no way to differentiate the pages.. for example ...more >>

Hello all, I am trying to use the reportviewer control to publish reports in another website to provide customised interface. I am using the example at http://www.odetocode.com/Articles/128.aspx to try to make it work. It works fine normal. I get a frame of params and after Submitting i get ...more >>

I have a strange issue I just experienced while working with Reporting Services (with SP1 installed.) I created a report in Visual Studio, with 3 Report Parameters. 2 of the parameters had default, non-queried values specified, and one did not. I uploaded the RDL to the web server for the f...more >>

I am having the following problem: When the report runs on the deployment server, the hostname used for the area of the page where the report is generated contains only the computer name, not a fully qualified domain name. I.e.: http://hostname/ vs http://hostname.domain.com/ I need t...more >>

Sorry I have posted in wrong group yesterday. Have to repost it again. Anyone can answer the question? Appreciate it!! ------ I want to have report exported to excel to have the same format as it was before export. I have set textbox properties to "canGrow" true. Every cell is expanded no hi...more >>

Anyone knows how to make the format in exported excel file as the same as you defined in report? My problem is the cell does not grow as content grow even though I have set textbox cangrow property as true. Thanks! ...more >>

Hi , I just deployed a report on a report Server from my Dev m/c.... The Report is running fine except the Property page for the Rpeort shows the following error "Unable to generate a temporary class (result=1). error CS1514: { expected error CS1001: Identifier expected error CS1031: Type ...more >>

Hi, Before installing Reporting Services SP1, I can deploy and view reports. Everything works fine. However, after I installed Reporting Services SP1, I can not deploy all my reports to Report Servers. On the other hand, I can preview the reports through Visual Studio .NET and it looks very...more >>

Hi gang... I have sucessfully created a deployment application for my reports to be deployed via web services to our customers. However, the only thing I am not able to set correctly is the shared datasource for the report itself. Below is a snippet of my code: /Test/Test is my shared data...more >>

All, My report should look like this: WTD MTD YTD Actual value 3 5 7 Percentage 10% 20% 50% I have set a parameter list based on time dimension in the cube and they are displayed in diffe...more >>

Is there any way in MDX to give multiple where clause: Example in SQL: SELECT * FROM Price WHERE Type in("Cost1", "Cost2", "Cost3") I have total 10 Cost types. But I need this query to return only 3 listed above. It is simple with SQL. My question is How to do this in MDX? I have tried...more >>

Hi, I had a few sets of Reports, who were working fine. today I added a report to my solution file at my dev machine and deployed it on the reportserver. The Report got deployed successfully but when I browse the Report from the browser before opening it shows the windows dialog box for "Fil...more >>

Hi, I am working with Fomauthentication in RS. I fallowed all steps as it is which had given in Msdn. My problem is while working with ReportManager Users r regestring properly.But while iam trying to logon with the same user an error has occured like "http error 401" like that. But ...more >>

Hello all, I have been looking at various models and ways to implement a custom interface for the Reporting Services. My client wants some kind of a default website (should be available only in the Intranet) where he can get 1. an interface with a list of reports. 2. The fields required for...more >>

I have 2 textboxes in a page header near the upper right hand corner of the report. The textboxes have a navigation property that reference external URL's. If I make the left most textbox "HIDDEN" - when I view report, the right most text box is displayed at the position of the hidden tex...more >>

Hi, I'm posting this problem for the third time. Still no answer from the MS Team. I've found other users on the web having the same issue. I have the following problem with AD an RS: when creating a group of users as a "domain local group" in AD, i'm able to give a specific item-level rol...more >>

How do I get a string and value in one text box? Example: Title of report and the current date. In the text box I tried, ="Expenditures in Divsion " & Date, but I get the error, "'Date' is a type, and so is not a valid expression."...more >>

How do I get a line to go across the detail in a table? If I set the underline for each cell, I get the value in each cell underlined, I don't want that. I want an underline to go across the detail section of my table. So, the user can see a line between each row in the detail....more >>

I'm trying to create a chart for each client. In a DataSet, they are returned in a sorted order like this: ClientName Month Sales ---------- ----- ----- Client 1 1 500 Client 1 2 100 ... Client 1 10 900 Client 2 1 100 Client 2 2 200 ... ...more >>

I have created a custom assembly that contains a function that uses System.DirectoryServices to determine the user groups a user belongs to. It works fine in development (preview) but returns the following error on the report server: "Request for the permission of type System.Security.Per...more >>

I would like to be able to include the report revision date as part of a footer. I would like to get this date automatically from the date the report was last saved or the date of the RDL file itself. Can any one provide any advice or suggestions about how to do this? Thanks!...more >>

Hello, I do not know if it is possible but let me explain what I want. I have a matrix which contains to groups on rows: region and process. The region can be expanded so that the process group becomes visible. I have created a chart based on the same dataset. What is want is dynamic gro...more >>

Hi, I have reports with parameters that use custom code, and when you hide the parameters in the report manager the reports no longer work. I thought it was a parameter dependancy problem, but have done the following test to prove its not: I have just created a report, with one parameter c...more >>

Is it possible to use SQL Server Repotring Services without using .net framework? I want to use it using ASP....more >>

Hi there I am trying to set up some sort of date picker for my reports in Reporting Services and found an article which basically uses an asp.net calendar control as a plug-in to the report (see link below). http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_...more >>

Hello I would like to export my report to PDF with a pageheight of 21cm. The report itself has a pageheight of 11cm (Set in Reportproperties-->Layout) I dont want to use URL parameters, how do I do. I have tried to change the Render extension in RSReportServer.Config but to no avail. Chang...more >>