I have a web application in one server and reporting service in another server. This web application is to list out report items. When I call web application in any client machine, error is always shown - 'The request failed with HTTP status 401: Access Denied'. But if I install the reporti...more >>

I setup a folder called _Master in Report Manager and I deploy all reports to this folder. I setup additional folders through Report Manager that are related to specific job functions: Sales, Customer Service, Marketing, etc. Whenever I create a linked report using the "Jump to Report" fea...more >>

I have a windows 2000 Ent. test server with IIS, SQL 2K Ent., ASP.NET running. Today after I installed RS Std. version the ASP.NET stopped working with a permission error. I chose not to install Report Designer and asked because Visual Studio .NET isn't installed. Removing RS fixed will f...more >>

Is there anyway to drag the fields on to a report and have it create labels for those fields without having to create each of them individually and without using the table or matrix? David ...more >>

Hello, I've searched the news group postings and have not found an answer. The question is: Is it possible to export a report from RS into excel and have the expand/collapse feature in excel work? Thanks, Ross...more >>

Hi, I have Start date and End date as parameters. Now is there a way to have the start date always default to the start date of the current month...i.e 1/CurrentMonth/CurrentYear and EndDate default to 31 or 30th of the current month & current year? How can this be done? Thanks -- ...more >>

I read a post from one of the MVPs that stated "If you mean that the result set has 90,000 records or 180,000 records then you have the wrong product. RS is not designed to generate reports that are 1500+ pages." Is there documentation available about the limits of RS (i.e. max number of re...more >>

Hi friends, I have one issue. In our organization there are CEO, Managers, asst managers, TeamLead, Teammembers. There is a report which displays all of them data. But what I want is if the user is CEO then he should be able to see all other's data in that report. if the user is Managers t...more >>

We know that RS will generate a fixed and limited set of PDF Properties to a report rendered into PDF format. Can this set of properties be expanded upon to include CUSTOM PROPERTIES? thanks. dlr ...more >>

After importing the RSClientPrint.dll type library into Delphi 7.0 Enterprise. A simple test app which calls then RSClientPrint .Print() method returns these errors; Error loading resource libraray. (0x80004002) & No such interface supported. ...more >>

Hi, I have a report which shows all the orders in the systam . I want to be able to view the order details for an order when an order number is clicked and be able to edit some information so thagt it goes back to the databse. Is it possible to edit data with REpotrting svcs? If not, th...more >>

I'm trying to issue the Render method based on some samples I've tried to adapt and I am getting errors about the path. The doc states the first parameter to be passed to the Render method is the "full path name of the report". I'm not sure what is wanted there. I currently have 2 project...more >>

Is there a property or hack that would allow for the numbers (for each series) in a piechart to appear OUTSIDE the "pie" itself. In other words the numbers displayed outside the series with lines or arrows pointing to the corresponding "piece?" the intent of course is to allow users to see ...more >>

My company is interested in using Reporting Services but doesn't yet want to commit to their own servers. Does anyone know of any hosting companies offering hosting of SQL Server Reporting Services? So far, I can only find one - discountasp.net and I'd like some more alternatives....more >>

Hi, Right now there are 3 developers in our company who are producing reports.They all produce the reports in different ways( using different fonts and layouts and colors).I was just wondering if I could make a standard look and feel from which everyone can derive their reports from to stop...more >>

Hi all, I have a table, I can merge cells in a row but i cant seem to merge cells for a column. Is this just not functionality of Reporting Services 2000 or is it a bug? Is this rectified in the SP2 -- Thanks in advance, Dave Hunt...more >>

I have some report elements that have their visibility set conditionally using an expression. The expression is based on the value returned by a query that determines if the user has appropriate privileges to see certain data. This seems to work quite well, except when the element to be di...more >>

Hello all. I need to overlay two charts (column & line) & I keep seeing references to this technique on these groups but no explanation of how to do it (nor in the help). At the moment when I overlay charts the top one is visible but not the bottom on,e & I can't see how to make the backgroun...more >>

Hi, Can I show my subreport under the "master" reports calling column. I also want to show my subreport in a new window. Please help me! ...more >>

Hi! I'm trying to add a visibility toggle to a table group in my report. The table has one main group and a subgroup. I want to hide initially details from the subgroup. So I changed the visibility property of this subgroup to "Hidden" and then choosed that visibility can be toggled by anothe...more >>

1. When using a table control. Is it possible to have my columns be auto-sized to fit all the data and column headers without wrapping the data? 2. Is it possible to define the report so that the gridlines are viewable after exporting a report to Excel?...more >>

hi allo, i have develop reportes in arabic language i use SOAP API function to call the reportes and export it to PDF for printing or display everything is working fine but i need to display the numbers in idean numbers not arabic numbers thanks for help in advance...more >>

When i try to run this REPLACE(Event.Memo, Chr(13), '') AS Memo in my report i get this error 'chr' is not a recognized function name, any ideas??...more >>

How should I store an image into my SQL database in order to be able to read it using Reporting Services Image control? I have a table with an image field (datatype of the field is 'Image'). I have tried several ways and the report is always rendered with the image showing a red cross insid...more >>

i'm using the Yukon beta and I don't see it. -- Message posted via http://www.sqlmonster.com...more >>

I have installed the April CTP version of Yukon and been able to get started with the new Reporting Services, especially the new and exiting feature Report Builder. I have created and published a report model whose data source is a relational database to the report server. Then I try to use th...more >>