Question, I have an external web server that uses the ReportViewer dll to point to a Report Server located internally - Not visible to the outside world just to the intranet. I get a page not found error when trying to view a report via the reportviewer dll. I have a feeling this is being...more >>

Hello, I have been trying to install RS for a while now. I was able to install it successfully when I had the SQL server running locally. But I need to make to work having the SQL server on a different machine. Here is my scenario. 1. SQL server 2000 is running on a Win2003 Server which...more >>

Hi, I 'm calling the report server web service to generate email subscription. The code are following, it fail at fireevent with message like: "The permissions granted to user 'xxxx' are insufficient for performing this operation." The user was granted content manager role. Please suggest ...more >>

Hi- I'm trying to enclose a group of textboxes by a border, essentially a VB groupbox or panel. I've tried using both a rectangle and text box object with a border to accomplish this. When you preview it looks right; however, when the report is rendered, the html generates a separate table wit...more >>

Hi, Whenever I click on a report to open it, it asks me for my Windows user ID and password. I am connected to my desktop using my domain account and report server is installed on SQL Server (domain controller as well). The report is using NT authentication method. Does anybody know how can I...more >>

Nothing shows up under the "Last Run" column. No error msg or entry in reporting services or SMTP log. Looks like reporting server is completly ignoring the subscription entry. I'm using "once" option and selecting a time just 10-15 minutes ahead. Here are the entries in my RSReportServer.con...more >>

How can I set Regional settings for Reporting services? I don't want my currency to display in US Dollars and I don't want my date form in the current way. Is there any way to set the regional setting for rs? Thanks R ...more >>

We'll be hosting a public chat on the contents of Service Pack 2 on February 8th at 2pm Pacific Time. It's listed at http://www.microsoft.com/technet/community/chats/default.mspx. -- Sincerely, Stephen Dybing This posting is provided "AS IS" with no warranties, and confers no rights. ...more >>

I know that I can have access to the value of a paramter by using Paramaters!Name.Value .I'm using a dropdown in my report which has lable and values ,I'd like to get the lable not the value. How can I do that? Thanks for your time in advance. Ali ...more >>

Good day I would like to know if one can have the boolean parameter as an checkbox? Thanks Karl ...more >>

Hi All, Can anyone give me an idea on how to schedule to run an Crystal report's report, which gets its data from an SQL stored procedure with 3 parameters. Also need to auto email the finished report to different email address. Thanks very much advance! ttidy...more >>

When I ask Reporting Services to Export a report in PDF format I always get a cached copy of the report. In other words: open browser export a report to PDF change data in back end table export the report again in PDF get cached copy of report (!!!) close browser Is there any w...more >>

Hi, I can display reports in the Report manager and run them on the server but when I try to access the reports from a users machine I get the dreaded "Page Cannot display Error". I can connect to webserver and see the report manager but when I click on the report listed I get the above er...more >>

Im tring to gte my report server to work on the Internet. It works fine locally but when I add the ReportServerExternalURL to the config file as documented it fails saying ; The configuration file contains an element that is not valid. The ReportServerExternalURL element is not a configuration...more >>

Is there a way to modify the execution timeout of a report programmatically? I know it can be done through Report Manager, but I can't find a method in the Web service interface to do the same thing. Thanks, - Rudy...more >>

Hi all! I have a staff Turnover report with table that has a group for "Status". The value of this group is either Active or Terminated, so here's a very simple description of how the table looks when previewed: _________________________________ TURNOVER REPORT Active (5 associates) ...more >>

Hi I can do a select top 100 records from a table. But how do I do a select top 101 to 200 records from a table?? Thanks SELECT TOP 100 Names from tableDetails how do I do 101 to 200??? ...more >>

After i installing the SP2 Beta my pdf-exporting issues (blank pages and wrong page breaks) are fixed. Good job mates! thx a lot regards Frank ...more >>

Hi! On two of our Report Servers, I am getting the following when trying to access a report via report manager: "Directory Listing denied" "This virtual Directory does not allow contents to be listed" I would greatly appreciate it if someone could give me a clue what might be wrong. I ...more >>

have this matrix report that looks like that : Type1 Type2 Count Time Count Time Zone1 2 20.5 3 20 Zone2 23 40 25 35 Zone3 11 40.5 23 13.3 i would like to sutotal the columns "Count" and "Time...more >>

I have 2 reports that run against a Oracle database. They run fine on my development PC. Had huge problems getting them to run on the Reports Manager scheduled. We finally got one working, after days of beating on it, it was uploaded by the senior DBA (so owned by his userid also), the conn...more >>

Is it possible to install the reporting services dev enviroment in Visual Studio without having to set up a new SQL Server db each time? Our dev server is getting cluttered with these, but I haven't been able to install the RS dev environment without creating them. Many thanks, Burt ...more >>

I am passing the parameters to a report in a URL. How can I hide the report parameters dropdown select list when the report displays?...more >>

Months ago we moved the log files to our E drive using the following setting: <RStrace> <add name="Directory" value="E:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles" /> </RStrace> (We probably should not have put LogFiles on the end of that path, but that's besi...more >>

Can anyone tell me the best method for migrating reports from one environment to another? I am looking for the simplest way to move reports from a test report server to a production report server. I am looking for both manual and automated methods for doing this....more >>

After installing SP2 (beta) it is possible to print on the client side, but it seems that printing is not correct. In VS.NET I also have problems, but it is what you really get when print from IE (browser). Has anybody suggeestion about this ? Thanks, Jovan ...more >>

Would like to know anyone knows how to create the ability to export to Access from RS web. Maybe making it available in the dropdown. We are reaching the limitations of excel and would like to automate it saving as table in access. Thanks...more >>

Is MS Reporting Services capable of adding new kinds of charts like a pareto chart? If so, i'd like to find out if there's one that plugs in to VS .NET 2003 designer and MS Reporting Services. Dundas does make a pareto chart in their enterprise charting package. They also designed the cha...more >>

We currently use Crystal Reports due to having to build forms to match preprinted forms. Does Reporting Services support Templates that we can populate? Thanks, Mario ...more >>

I have a basic report with 3 text boxes. The first text box contains a title and two smaller text boxes. The two smaller textboxes contain a string "Report Created:" and the date and time the report was created. The layout in VS is correct, it is correct in the preview within in VS. When I exp...more >>

Reporting Services Error -------------------------------------------------------------------------------- a.. An error has occurred during report processing. (rsProcessingAborted) Get Online Help a.. Cannot create a connection to data source 'ClinicalTrialsFinances'. (rsErrorOpeningCo...more >>

Hello All, I have been trying to install reporting svcs EE on win2003 server for the past 4 days. but not successful so far. This is the set up i have. win 2003, sql server 2000 EE and reporting svcs EE. trying to create the RS databases on the local SQL server. First I tried using the ...more >>

My company just installed SQL Reporting Services and they've given me permissions to where I can view the home page of the Reporting Services site. I'm using Visual Studio.net to develop in but I'm unclear on what I need to install on my end to create the reports and deploy to the report serv...more >>

Hi, i had created a report (ReportA) in which i m calling another report (ReportB). I had added a textbox (tb) in ReportA and had set the navigation property of tb to "jump to report" and given a report name ReportB (i.e. the second report). Now, i m using asp.net report service, i had create...more >>

I was wondering if it would be possible to generate reports directly from Windows Sharepoint Services (WSS) Lists or from the output of a Webservice? tnx -= Maximizing Creativity and Productivity =-...more >>

I have a simple report that shows the result of a SQL Server 2000 SPROC. This works fine from any PC within MY DOMAIN. When a user in the same company (Intranet) but on a different DOMAIN attempts to run the report the can get as far as the report screen asking for the parameters but then th...more >>

Hi All, Bit of strange one this. I have a key field in one of my databases that is a Char(18). I use this as a parameter field in one of my reports. When I run the report and specify the key field parameter manually the report runs instantly. If I attempt to set this as a parameter variable an...more >>

About Excel: I found that the content of the subreports can't export to the Excel. It said "Subreports within table/matrix cells are ignored." Is this mean that it is not support or there are some way to do that. the subreports is very important to me. About PDF: There are Chinese cont...more >>