Hi, I need to do that the Reporting Services works when I change the web site port number (from 80 to any other) Can somebody help me? Thanks. ...more >>

I think this is probably easy but haven't found the setting yet and am running out of time. My report has a column I want to use as a parameter(parameter query). The value of the field repeats several times and I want to limit the drop down list to the first occurance of each value. Hope...more >>

Hi Is it possiable to recover a .rdl file from the report server? I deleted a report file from Visual Studio, but it was succesfully published to the report server. Any help is appreciated. thanks...more >>

Hello there I was wondering is there is a stored procedure to witch I could feed the name of a maintenace job and it will give me all the data that exists in the maintenance configuration screen ? thanks ...more >>

I am looking to deploy reporting services on two serves, one already running SQL2000 plus an exisitng IIS Server. The IIS server is running Windows 2003 Web Edition - is installing the non-DB components of this edition of windows supported - cannot find the into in the deployment guide! ...more >>

Is there anyway we can have dynamic operator in filters ???? instead of > i want to put parameters!operator.value...more >>

I am using xslt to generate an rdl file. The top level node is the Report Designer default: <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdes...more >>

Hi, I have 3 parameters- columnname -takes the column name like name, course, marks operator - takes the operator - <.>.<= value - takes the value like 30,computers , english etc i want to pass these parameter to a table and filter the value out. how can i make the operator as a parameter...more >>

I have a question to ask: I type "http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2ftestreport" in jump to url box, it will go to open a report named testreport in my report server. It is good. I want to rename the testreport to a variable name. If I change test...more >>

Hello, I am very new to Reporting Services and want to do something I have done in other programs using a tool or wizard. I want to group my data by " 30 days over due" , then " 60 days over due" etc..Based on the following DAYSDUE > 30 and < 60 DAYSDUE > 60 and < 90 DAYSDUE > 90 and < 120 ...more >>

How should I install SP WebPart? I need to install the web part on antother server. What should I do? ...more >>

Can we utilize a userID as in the custom security example but also have a friendly name appear on the modified By in the Report manager detailed view? I'm currently seeing the UserId in the Modified By and would rather view a friendly name. Yet I still want to use the integer type user id for s...more >>

The report is made of one list containing 2 tables, one below each other. Depending on the report parameters, the bottom table is made visible or hidden. When that table is hidden at run time, RS still reserves the same amount of white space that the table takes in the report design layout. ...more >>

HI, There is one report with 3 parameters. They are AppID, StartDate, and EndDate. When rendered as soon as I made a choice in the AppID dropdown, the browser logo starts spinning and I have only a short time to get the dates input. What might be the cause of this? Thanks, -- Fairfield...more >>

I have a problem with a default implementation of Reporting Services with SP2 in one box, with SQL 2000 SP4. The tool works fine, I have 10 Reports working without problems, but when I want to execute one of them, this error message appears : aspnet_wp!webserver!294!07/25/2005-16:06:56:: e...more >>

Hi, Is there any facility to restrict the dataset not to display the textbox more than once when exporting to CSV format,when textbox value displays group value(text). Many Thanks ...more >>

How can I incorporate a MS Project Gantt Chart into Reporting Services reports?...more >>

I have a table with 2 Groups and I want to number only Group2 with row numbers. I put in a RowNumber(Nothing) function, and i'm getting something like this: Group 1 11 Group 2 14 Group 2 28 Group 2 Group 1 35 Group 2 etc.... What can I do to get the numbers to show up co...more >>

I am trying to build a dynamic datasource for my report. The problem is there are multiple where criteria that, if left blank, I want to ignore. I could go down the road of nested "iif"s but that would get very difficult to maintain. I have a C# function that already does something like this ...more >>

Hi I have a main Report MR - i added a subreport to it SR1 - and it works fine but when i try to add another subreport SR2 - it gives me an error ERROR: subreport could not be shown. It only hapens with this particular rdl. The subreport thing works for other rdls. the supreport SR2 works fine...more >>

I know in crystal I can join 2 different data sources with in the report . Is this possible in RS ? (note: by different data sources I mean 2 completely different machines) I have he columns I can join on just cant find a way to join them . One way was to bring both parts of the data to a...more >>

I am new to reporting services. I am having trouble aligning my text. I put some things in text boxes and even though I have the boxes as close together as possible, they appear far apart. I tried overlapping the boxes but then when they deploy it pushes the data in the second box down to the ...more >>

I am trying to install RS 2000 on my local SQL 2000 that runs on XP Pro. I am getting an error after installation verifies credentials. The error says something about a wrong version of RS I am trying to install. I have tried Ent, Dev, and Stand versions. Only Dev version gets to the point of ...more >>

Hi It seems there are various issues that lead to this problem. If no other postings appear to solve your particular problem check this.... Are all subscriptions failing or just some of them? If its just some of them your problem maybe that the failing reports have a subscription owner...more >>

From what I understand it is possible to set contants (to be used in expressions) in web.config. I want to use this to dynamically give the location of the reporting server supplying the report in the header e.g. US or Europe. Can anybody give me some example systax? Cheers, Rob....more >>