Hi, I want to add page header and footer in the report, which will have text boxes pointing to fileds in the database. Also, there will be only 19 lines in detail section per page. How do I do it? Thanks,...more >>

I work for a large government organisation and I have built several reports that enable clients to drill down to case level which they love. The problem is that now they all want to be able to "push a button" and send the cases to a case management system. I know how to write the code to sen...more >>

I have a question about monthly schedule. I checked all months, select 1st in 'On week of month' and click 'Mon' in On day of week. It means that the report will be generated on the First week Monday of each month. But in 2005 February, there is no Monday in the first week. My question ...more >>

I have implemented the forms based authentication by Teo Lachev and it works fine. But whne I change the namespace to something else and make all the necessay modifications in the config files , I just can get it to work. The reportsmanager comes up with unable to communicate to the server!! ...more >>

I have a huge SQL statement with subqueries in the From and Where clauses. When I run it in SQL Query Analyzer, it runs fine, but if I put it into the Data tab of a report, Visual Studio just hangs. I've been able to create the parameter list manually (adding them to the Report Parameters d...more >>

I know how I can create a report that expands and collapses like a tree view control. Is it possible to use that report in an asp.net page to allow the user to select a value? In other works can I tell what value the user selected in a table data region? We're trying to avoid buying a treeview c...more >>

Hi, I have a field in which I use a division. Sometimes the denominator can be zero. In such case, I want to return 0 instead of evaluating the division giving me an error. Here is what I attempted but without success. It appears that both expressions are evaluated all the time regardless ...more >>

I'm wondering what I might have done in my report definition to cause this. When I export a couple of my reports to Excel, it ends up on Sheet 2, while sheet 1 is a blank spreadsheet. Can anyone point me at what I need to look into? oh. I've got other reports that seem to export just fine. ...more >>

I have the following records: Unit Create_date Type A 01/02/2004 Clock A 01/15/2004 Car A 01/20/2004 Truck A 01/23/2004 Clock A 01/24/2004 Clock A 01/25/2004 Car A 01/27/2004 Truck A 02/01/2004 Clock A 02/02/2004 Car A 02/15/2004 Truck A 02/20/2004 Car A 02/27/2004 Car A 06/03/20...more >>

Hi, I've discovered a problem with repserv sp1 that I just can't see a way around at the moment. Basically we have a custom front end that allows the user to select the params from either dropdown controls or textboxes. The text boxes allow four states: 1/ All records 2/ Exact match 3/...more >>

Hello, Can anyone tell me how to decode the MIME document produced by the Excel Renderer? Thanks in advance. Darryl ...more >>

Hi All, I have been trying to get Forms Authentication to work for reporting services. I followed the article at MS's Library to a tee but I keep getting a http 404 error when I attempt to pull up report manager. I would assume that its referring to the login page can't be found but I checke...more >>

Hi, We have developed a 3-tier application and have developed our own method of handling row level data security. Basically our application passes all ad-hoc SQL queries through an object that replaces table names with view names. Each user is assigned a role which has a view defined for it...more >>

When running report, continue to get the following error: "Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) Get Online Help" Report has a start date and end date parameter. Report has a subreport. Subreport parameter is a key...more >>

Hi, My company has just purchased the needed SQL Server Enterprise Edition licenses so that we can upgrade our RS SE to RS EE Do I just uninstall Reporting Services SE and then install RS EE? If I do this will I lose any of my subscriptions, published reports, security configurations, et...more >>

I have an aspx page that uses the ReportViewer control. The dimensions are set at runtime. private void Page_Load(object sender, System.EventArgs e) { reportViewer.ServerUrl = "http://localhost/reportserver"; reportViewer.ReportPath = "/Samples/Company Sales"; reportViewer.Wid...more >>

How can I achive this. I need some reports to be on my page; I already know to use reportviewer. So I will show it inside my page. But I want to configure some of the reports that the user dont be asked for a DOMAIN user name.* What should I do? -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 3...more >>

How do I data bind to a table object. Meaning I want it to pick up the column names automatically without me assigning them to the text boxs. My dataset is a stored procedure that dynamically returns all columns from a selected table that I in turn pass to the table object. Basically I'm build...more >>

Trying to set up a Reporting Services / Windows Sharepoint services demo site and I am a little confused about the best way to allow anonymous access. I would like to allow annonymous users to run reports but not set properties, create subscriptions, or upload reports. I have seen some post...more >>

I am using a runningvalue for group footer, but now would like to take the final running total formy group footers and put it in the report footer. I have tried using reportItem!tbox.value but it gives me a "reportItem is a type and cannot be used in an expression". What am I missing her...more >>

Hi! I am trying to install SP1 to our dev box. This is the app machine, while the repository DB für RS is located on another server. DB connection will be with MSSQL user and password. Currently the SP1 setup gives me: "SQL Setup failed to connect to the database service for server co...more >>

Hi, Sorry for requesting response asap, but I am in a fix right now. I have created and worked on a lot of reports but never worked on this particular problem, which seems simple to me. If I have time, I can research and find a solution but VP of the company just told me to add this column ...more >>

We are having real problems getting external report (from a URL) images of a good quality consistently for both screen and PDF print. Can anyone advise as to the best image format, sizing option, resolution, etc. for SQL 2K reporting services SP1? Thanks, Chris ...more >>

Good Day to All, I have setup up an SQL Reporting Services server with out email support and I am trying to modify it so that it can support email for the subscription option. I have modified the rsreportserver.config file with the smtp server name and from address but I am still not ab...more >>

Hi Running the unpatched Reporting Services (ie no service pack) I find everything is working great other than exporting. After playing around with things I find that if I use http then the exports work fine, but if I reconfigure for https, they don't. So, http://myRSserver/Reports/Pag...more >>

Hi there, I've been using RS for a couple of weeks now without any problem until today. I cant open preview no more it just says "processing report..." all the time. Does anyone know what the problem could be? Thnx ...more >>

I have a matrix and have a column groups on month and products ( I have only 4 products) and am showing the number of products sold in that month. What I need is to show instead of number products, I need to show the % of sales for that product as compared to all sales. I need to access th...more >>

Hi, We have many reports that have been uploaded to Report Manager (RM) that contain drill downs. When you click on a drill down, it doesn't work. It makes a click but doesn't drill down. When previewing in Report Designer, all the reports work just fine. Any ideas? Thanks in advance for...more >>

=IIF(INSTR( Fields!EvaluationRelatedInfo.Value ,"03$" ) > 0,MID( Fields!EvaluationRelatedInfo.Value,INSTR( Fields!EvaluationRelatedInfo.Value ,"03$" )+3,INSTR( Fields!EvaluationRelatedInfo.Value ,"03#" )-4)," ") In the above expression, I am getting a "#Error" when the value of the first I...more >>