Hello. Is there a way in a report to get his url? I'll explain what i want to do: I want to add an option to export the report to excel format with out useing the menu so i want to add a button (or a table cell) and give him,in the nevigation field, the same url of the rreport with the same pa...more >>

I am using MS Reporting 2000 for Report where in one of the report I am using column chart. Now I would like to give customized color to each column in this chart but don't know how to implement it. Please help me out from this situation! Thanks, Sachin ...more >>

I have created a SSRS 2000 report that charts application crashes on a daily basis. Most of the time this chart only displays a handful of values and renders quite quickly. I had a situation recently though where the chart tried to render 2100 values and the report took around 15 or 20 minu...more >>

Hi all, I'm using SSRS 2005 SP1. When exporting my reports that have = subreports in, the sub report doesn't show up. Instead, the line = "Subreports within table/matrix cells are ignored." is there any settings I'm missing? your help is greatly appreciated. Best regards, Mohamed Sh...more >>

My users access SQL reports via weblinks from a Sharepoint portal. Even though they don't have backward access through the folders, they can still hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy? Thanks for the help JD...more >>

I can't seem to get the format codes to work in RS 2005. I assign one to a field, but it just ignores it and doesn't do any formatting. Is this a 2005 bug? Am I missing a trick? Thanks, Leon....more >>

I am new and I browsed through trying to find the answer but got no luck. Everyone here says that to get a subtotal of a group just right click on the group and get the subtotal. I tried so many times but still can not find out how to do it. Where can i get subtotal of a column? thanks a lot...more >>

Hi all, I am creating a report in BI Dev Studio and use the grouping functionality to show the number of leads for different sales representatives. I also use "drill down" to show the leads in detail. The report also uses a filter to filter out certain time period. On the sales persons level I ...more >>

I am trying to get to grips with cube reporting and am running the MDX Query Tool against AdventureWorksDW on SQL 2005 sp1, Standard Edition (I am not fluent in MDX). No matter what dimensions I drag on, the only output I can get is a single cell / report services field. For example, if...more >>

Hey All, Maybe I have been looking in the wrong places for the last 2 hours but can someone tell me how to add a borderstyle property to the 'subtotal' row on a matrix. I can get it to work for the 'total' textbox itself but not the entire row. I have even looked in the XML (which I never mis...more >>

I can't find SSRS 2005 on any of my MSDN Universal DVDs, nor is it available on MSDN downloads. Does this product actually/still exist? Where can I get it or how can I install it?...more >>

Hi, I am using reporting services 2000. Setting the format to currency (C) is not showing the formatted price. Is this a known problem? ...more >>

Hi Community I've written a ASP.NET 2.0 WebApplication which use the ReportViewer from VS2005 in Remote Mode with InProcess Session State. If I deploy the Application to a new IIS Website it works great. Because I want to integrate the Application to our Sharepoint Environment (User Authent...more >>

Hello, I have a client with a single SQL Server 2005 installation. The server is licensed correctly. The client has a number of users who may want to create reports using the Report Designer. Can the client freely distribute BIDS to anyone needing access to the SQL Server? Can anyone po...more >>