Hello, My ASP.Net 1.1 Web application should run in a DMZ machine and it needs to accesses http://MyReportServer/reportserver through ReportViewer component (RS2000). It runs if I put application on a machine in the domain but in DMZ I get username/password dialog box. What should I do? ...more >>

Hello, Is there a way to migrate my Reportserver project for SQL 2000 Report services developed with VS2003 so that I can use and modify them in VS 2005 or have I realy to install VS 2003 on my new machine? Greets Jean Paul ...more >>

I have a table where I want to jump to a different report based on the value in the table cell. The report that I am jumping to has a parameter, and the parameter value that I need to pass is based on the table cell's value. I know how to set this up in the report but can't figure out how filt...more >>

Hi, I got a very simple report project that i successfully deployed to ReportServer, I just using Windows Authentication. And when I got to Add a new subscription to this report I got this error: "Subscriptions cannot be created because the credentials used to run the report are not stored...more >>

hi, We have multiple servers with sql server. All of the databases have the same structure, tables etc.. just for different clients. in my RS project I have a shared datasource that points to a local dev copy of the database. Now if we open that project on another machine it trys to connect...more >>

hi, We have a lot of reports done in Reporting services. Now here is the thing. When you upload a report it gives the report the name of the rdl file. ex. HoursbyClient.rdl the title will be HoursbyClient. We change this in RS to Hours by Client. Now if for some reason the server crashes ...more >>

Hi there, This issue is about the Expand ICONS showing inverted. I have a simple report with 2 groups. Each group toggle visibility based on the group above. The report needs to start fully "expanded". When I run the report, all data shows as it is fully expanded, but the icons for toggling...more >>

We're trying to do an export to excel of a large amount of data. When we do 100 even 4000 rows it happens in a decent amount of time. However, when we try to export say 35,000 rows it never finishes and appears to hang after a long amount of time (15-20 minutes). Does anyone have any tip...more >>

I have a requirement to condense my report length. Each group is about 40% of the page length, so 2 per page would fit nicely... ....but I can't figure out a way. For performance reasons, I have the data filtered in the table object. I have tried several things: 1. (Runningvalue(Fields!...more >>

SQL/RS 2K, VS .Net 2003 - several single resultset/dataset reports working just fine, finally got some multiple-resultset/dataset reports working very well, too. today, however, i am creating a new one that isn't working, and i can't yet determine why. i have 5 different datasets so far,...more >>

I'll make this short.. i can pass multi-valued parameters to reporting services without using valid values (comma-delimted list) no problem.. we decided to use valid values based on a dataset to move the lookup logic into the reporting object (rather than manage SQL in a database). Now when i pa...more >>

When i address following web address http://srv06/reports/ this error occur The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. --------------------------------------------------...more >>

Hello, I would like to get answer for following question: What reports can be viewed by defined user? I don't know how to do that in RS. Any suggestions? TIA, Kamel ...more >>

Hi there, Today I can select different table style in the report wizard e.g. Forest or Slate. Is it possible to customize or create my own table style so it matches our company graphical standards??? Best regards Lasse Bjerre Knudsen ...more >>

Just curious if anyone has experience with this. SSRS2005 I have a report that has a dataset and populates a table. I have 8 sub-reports that are placed on this report. Is this approach the best for performance, or should I add the other 8 datasets to this one report, and then include a tab...more >>

Hiya, Can anyone confirm if Reporting Services 2000 Reports are compatible with SQL Server 2005 data sources? Has anyone experienced any problems with this setup? Thanks Wendy...more >>

I have been creating several reports that point to a test database. I can build and deploy my reports to the Report Server and everything is fine. We also have a DEV database and a PROD database that have the exact same tables/columns as the test db. I would like to point my reports at one ...more >>

> I am creating a report where I need to create a border around a series > of cells. It looks great when viewing it in Report Manager; however > (there is always a however) when I print the report some borders are > thin and of a lighter weight than they should be. > My cells have a 0 padding,...more >>

Hi, I am new in Report Service. I have recently set up a report using a stored procedure in SSRS 2005. The stored procedure has two input parameters, So I have set up two report parameters. The two parameters are @state, and @city. They both get their drop-down list from a query. My question i...more >>

I want my list control only be visible if there is data. So, in my report I have several list controls, one of the list controls shows alias data for a customer. If the customer has no alias data then I don't want the alias list control to show. In the alias list control I have several textb...more >>

Hi all. I was wondering if I have a report andI want to prompt the user to choose say current inventory or all inventory...Can i do that within a parameter? The problem I'm having is that if the user chooses current inventory it runs a query but if the user chooses all inventory it would hav...more >>

Hi, I dont know how to word this but I'll try. I have a report that shows two field in the output, i.e city and count. When the report is run it displays about 44 rows on one page, but since there are only two fields the rest of the page is left blank on the right hand side which can easil...more >>

We have a work order print that is called from a web page using a URL. The print consists of 4 tables. All of the recordsets use the same parameters but come from different data sets. I have a request to make it print multiple work orders at a time. When I use a select for multiple wor...more >>

I have a report on which i want to add a checkbox to the extreme left of every row and allow the user the ability to select it, hit a button named "Export" and move the contents of only that row to MS Excel. Does Reporting services 2000 support this? Any suggestions on how this can be done?...more >>

Hi, I would like to find the toggle state of a textbox in the report to set an expression according to that state. I need to navigate to a second report with different parameters according to the toggle state of a particular row in my report. How do I write the expression (something like ii...more >>

hi... i need help from u all... i have a problem about SSRS 2005.. the problem is; i have to default start date to "01/01/year" any ideas how to get the current year?...my end date is key in by user... i have try this =cdate("01/01"+cstr(parameter!endDate.value )) but it not works.. :( tha...more >>

I have a parameter that does a query. The parameter is a multi-value selection. Here is the problem. The query may return 500 values. The user needs to select maybe 5 or 10 values in the dropdown. However currently they are all selected forcing the user to unselect hundreds. Is there a way to ...more >>

Hi all, I'm running SQL Reporting Services and my question is: Can I connect the datasource of my reports to a business logic object that returns a dataset instead of using a direct connection to a SQL Server? Anyone that knows if and how this can be done? ...more >>

Are the 2005 reporting services part of SQL 2005 or cam the reporting services be used in a SQL 2000 environment? ...more >>

Hello, I would like to use a parameter in the url string; however, I don't want it to be displayed in the report's parameter header section. Is there a solution for this? Steve ...more >>

Hello Has anybody found a good way to add version control to a report? I could add a text box to the report and enter Version:20060927. Because this is a manual operation some developers may forget and it will become unreliable. If someone found a better way please let me know. Thanks ...more >>

Is there any way to prevent row information from suppressing the print if the data would normally just repeat itself?...more >>

I have written a stored procedure that contains queries which return data. It works correctly in Query Analyzer, returning each of the labled fields. When I create a report the only return field the report wizard shows is from the first query. When I add each of the other return fields and ru...more >>

Is there a limit to the number of records that can be realistically handled in Reporting Services 2000? I have a query that is returning 7000 records, the query seems to run pretty fast, especially when cached, but the report in the RS 2000 IDE is very slow to render. I have stripped all t...more >>

Hi, Have any of you work with Extensions to schedule delivery of reports directly to printers? I played a little bit with the sample Delivery Extension provided by Microsoft, I do not seem to get it to work. Any ideas of how to schedule RS to print reports automatically? Thanks ...more >>

I have a client who has SQL 2000, doesn't want to upgrade to 2005 right now, and is starting to use Reporting Services. Of course, they went out and bought VS.NET 2005 for various reasons. And now it looks like we can't author RS 2000 reports in 2005? Is there a solution for setting up the R...more >>

I currently have a RS 2000 solution running on SQL 2000 database, AS 2000 and RS 2000. I want to migrate this solution to the same schema running on a SQL 2005 database and AS 2005 with RS 2005. Please kindly explain the best way I can accomplish this migration. Thanks Karen ...more >>

I am using RS 2005 ReportViewer in an ASP.NET 2.0 page. The Toolbar Page Count, "of xx", has a Font Color of White and does not show up very well on the default Back Color. It appears to be inheriting it from the StyleSheet Color for BODY. If I change that Color, the Page Count Color chan...more >>

I need Visual Studio to debug SQL stored procedures and already have SQL Server 2005, which comes with that pared down version. Do I need a full version or an upgrade? Do I need Standard Edition or Enterprise Edition? ...more >>

When creating an e-mail subscription, the TO: field contains the users Domain Name instead of their e-mail address. The TO: field is also read-only so that the user is unable to enter their correct e-mail address. When I do the same thing, but I have 'Content Manger' privileges, I am able t...more >>

Hello, Is it possible to have two different header images (JPEG) in one report with multiple pages? I need to have one header image appear on the first page, and another image to appear on subsequent pages of the report. How can this be accomplished? Any help is greatly appreciated!...more >>

I have a table in my report that shows cases, that are grouped by Court and Case. Each case can have one or more defendants. How do I add the defendant data to the table? In other words, how do I add a sub-table in my current table and link by Court and Case? ...more >>

I have Reporting Services project created and tested on one SQL Server 2005. Now, I have to transfer this project to another SQL Server 2005 with its own Reporting Services installed (and the same structure of the data sources) What is the right way to do this? ...more >>

I have a question regarding How to run reports through a batch file or a command line command. Scenario: We have a structure of reports based on State. User wants these reports based on Country (Which includeds all states). It is not possible to render these reports by Country. We are allo...more >>

Problem: I have a MySql database that houses status information that is linked by a primary key from a SQL2005 database Using Report Designer in VS2005, I have created 3 datasets pointing to the 2 datasources. I need to create a relationship between the MySql based datasets and a dataset t...more >>

HI all, I'm new to RS and VS as a whole. So please excuse the obvious. I have a report that is based on a SP in MSSQL2005. It returns a recordset. All works fine, however, I need a column in the report that is a calculation based on the total of the report. THe column needs to represent a pe...more >>

Guys, Hopefully, this is a simple problem. I am new to SSAS 2005 - I have created several reports that I can view and filter fine using http://localhost/ReportServer. I have created a web page with a Report Viewer control in it and I have LinkButtons set up to load one report or another like ...more >>

Is it possible/ok to write a report with sql 2005 report designer and deploy the report to a SQL 2000 Report Server? -- moondaddy@noemail.noemail ...more >>

I am having trouble passing through multivalued parameters to a stored procedure. I have created a UDF as to present the parameters as a string but when I am not sure how to call the stored procedure. Could you please tell how do I call the stored procedure from the Data tab in Visual studio...more >>

Hello all - I have reporting services installed on SQL server 2000 database and have developed many many great reporrts on it. However, I have the need now to address datasources from PostgreSQLdatabase open-source database and I wonder if RS would work with PostgreSQL ODBC and if the onl...more >>