We have the ReportViewer placed inside a DotNetNuke framework which is displaying the initial report fine. However if we create a sort link on any table header name or create a link on some data returned for a drill though the new report renders outside the Iframe, outside the framework, and ...more >>

I have successfully created a matrix consisting of payroll dates as column headers, with task types as my rows and hours/task/day the detail data. The columns total perfectly, but the totals only display to the RIGHT of all the data. We display our totals FIRST, then the detail data. Can I ...more >>

how can i change the link from http://servername/... to http://ipaddress/... in the subscription email? Right now I don't have dns setup yet so I would like to you ip address instead but the email sent out with the http://servername/... link. Please advice ...more >>

Can Get/SetExecutionOptions really get/set all the Execution properties that are available via Report Manager? As far as I can see I can set a report to Live or Snapshot and set a schedule if Snapshot. How do I retrieve the setting " Cache a temporary copy of the report. Expire copy of report ...more >>

hi ppl, I am trying to connect to the RS Web service through an ASP.NET web app. When I just try to list all the reports, it works fine and lists all the reports. But when I try to get a report which needs a passed parameter, I get the following error Any ideas ? thanks ravi =========...more >>

I have tried several times now to put a filter on a table. Everytime, I get an error that it cannot be performed. Help is a bit then here too. What is the secret? Here is what I want to do. I have a dataset with all the data, but only some of is to be displayed. All of it is needed f...more >>

here is an example of this bug at work.. (i am using RS SP1) 1) upload this report into report manager 2) - RUN THE Report, and notice that the 2nd parameter called 'defaultparam' gets set to the date, and it works.. (all the report does is show this parameter) 3) - go to the parameter editin...more >>

How do I format a DateTime to Military time? -- Message posted via http://www.sqlmonster.com...more >>

Hi, Issue 1: I am having a report that takes in parameters and then finds out the associated heading from the db. Now i am faced with a typical problem. Report server does not allow for dataset fields in the header or footer coz the minute i put it there i get an error telling it is not possib...more >>

I'm generating a rss script for a report that will be depolyed to a new server. If the report uses a shared schedule for its history snapshot then in the script I need to pass a ScheduleReference to SetReportHistoryOptions. What's the easiest way of interogating the new server to see if a Shar...more >>

Problem: Subscriptions error out when SQL connection is configured as NT Security Environment: Report Server: W2K SP4 5.00.2195 Server RS installed to run under a domain account (Domain\Reporting_Admin) with Admin level permissions to the local machine SQL Server on a remote box: @@Ver...more >>

Hi, I've stuck with an error message and I can't sort it out. I am trying to install a standard reporting service on a server separated from database server. Web server (report services): no domain Databasebase server: a member of a domain. I can install RS with domain authentication mode ...more >>

I am getting an error on Table level filter. Error: "An error has occured during report processing. Fail to Evaluate FilterExpression/Filter Values" Filter Expression: Expression - =Fields!Accounts_Cost.Value.ToString() Operator - = Value - String.Empty I tried "" instead String.Empty ...more >>

But with some simple changes to ReportingServices.js it does. 1: Replace all instances of "document.all" with "document.getElementById". 2: Add in this: window.navigate = function(url) { window.location = url; } I don't know why the author didn't just use getElementById from the ...more >>

I'm curious exactly what functionality is lost when you use the RS Web Service rather than accessing the direct URL. We're evaluating RS vs Crystal and specifically need XLS export functionality. Is this lost if you use the RS Web Service? Is there a way to export to PDF, XLS, etc. and stil...more >>

I have some existing .NET app, and so I'd like to integrate the RS w/ them. Reports created by RS is very impressive, now I need to think about integration. Two choices for me: 1. URL Access 2. Web Services Option 1 is the fastest and efficient way, has the followings: 1) DataSource in de...more >>

Is it possible to attach a pop-up tooltip to a parameter label?...more >>

I'm wondering if anyone has any good Reporting Services books they recommend. I'm a DBA so I don't actually do or need to know the report development and deployment but need to know the back-end of RS - the security - etc. Many of the books I've seen so far concentrate on report creation. I...more >>

Hi - I'm running a development Reporting SErvices on Win2K SP 4, SQL Server SP3, Reporting Services (I just applied SP1). I am running through some scenarios to verify whether RS will meet project requirements. I am having trouble getting File Server share subscription to work. The error th...more >>

Hi, i am working with RS form authentication.I fallowed all the steps as in MSDN guide. But when i am trying to open ReportManager ,I am getting the error like. Unable to communicate with report server. Please verify that the report server is operational. While i tried to open Re...more >>

Has anyone in this group been able to set a report datasource to point to a shared datasource via code? If so, I would like to know how you did it. The sample in the documentation for SetReportDataSources is not working. I am transferring over 200+ reports from our staging RS server to pro...more >>

What are the default directory security settings for each of the virtual directories installed with RS? /Reports /ReportServer In my quest to get authentication working properly I have changed 'em and now they are totally broke. If someone can help, it would be most appreciated....more >>

I need to view reports from my application using a report viewer component (specifically with the AxSHDocVw.AxWebBrowser component). which appears in the toolbox. how do i add this component to the toolbox? Thanks Sanjeev ...more >>

I am trying to install the reporting services on a Windows 2003 webserver using NT Authority/Network Service for the ReportServer Windows Service access and a SQL Server account for SQL Server access. I am getting the following error when trying to start the RS Windows service. Service â€...more >>

When I create a report and preview it everything is in place. However = once I deploy it, and look at it from the server many times the = formatting is totally different. Many times graphics are out of place, = or in this last case the whole table is shifted out 4 inches from the = left margin.....more >>

After applying the following patch from Microsoft: MS05-004 ASP.NET Path Validation Vulnerability (887219) http://www.microsoft.com/technet/security/Bulletin/MS05-004.mspx I am now getting the following error when navigating to the properties tab on a report within the Report Manager: Una...more >>

How do you store XML in a custom tag of the RDL? We are just persisting the XML into the tag and don't want RS to be confused of the XML as part of the RDL. I assume there might an attribute that we need to set. I don't know....more >>

I need the page numbers in the header (or body if it can work like this) to reset after a grouping in the body, is this possible? In Crystal it is the checkbox option in the Section Expert tab called "Reset Page Number After."...more >>

Hi, I currently have the following expression as my document map label: =Fields!themonth.Value + Fields!theyear.Value But I need to have the month and year seperated, maybe like this: =Fields!themonth.Value + ' - ' + Fields!theyear.Value I can't seem to get this to work, keep getting ...more >>

When generating a report it looks fine on the web, but if I export it to a pdf and then open it, if it has certain characters in it eg € when I open in acrobat the text beyond the character is corrupted, this only happens in acrobat v5, in v6 its OK. If I create a word document with the sam...more >>

Hi, is there any way how to sum value of rows in table? rows in table has values calculated by another sum function, so I cannot use another sum function ... my question is, if exist some "sum(table.rows)" or something like this ... thanks anyone for help...more >>

Has anyone ever managed to successfully use System.DirectoryServices to return the WinNT user groups for a user in a custom assembly once deployed to the Report Server? Or should I just give up? Works fine in development but has security issues on the Report Server. I am just curious if anyo...more >>