Hi I'm using the following expression for the BackGroundColor in a matrix detail cell: =IIF(Fields!ID_Quarter.Value = "Cumulative", "Gainsboro","Transparent") This is checking the value of another cell before setting the BackGroundColor value. I'm also using an expression for the bottom ...more >>

Hi I'm just wondering if anyone knows how to merge cells in a static group in a Matrix. I have a column group across the top, ...more >>

I have 70 reports with same company logo. I try enter the image's relative path e.g. /Reports/images/CompanyLogo.gif in the URL. An error 'The URL is not valid' is shown. But if I enter http://localhost/Reports/images/CompanyLogo.gif, it's ok. Can I just input the relative path instead o...more >>

I am wondering if anyone can tell me how I can create a report with 4 tables in it. Just like iterate the table out. Sunny ...more >>

How can you sign up for the beta? I am trying to rollout and would like to test on SP2 before rolling. Any ideas? Regards Michael...more >>

Hi, I wanted to put my company name instead of "Home" in the reporting services manager. I tried to search the whole reporting services folder for the text "Home" and not able to figureout how to change it. Looks like we cannot change the text? Any ideas? Thanks "Hausbro" <Hausbro@disc...more >>

I am getting the following error while attempting to install RS on a Small Business Server 2000 box that already contains the ReportServer DB from a previous setup where the Web portion of RS resided on another box. The error is: "A database with the specified name (ReportServer) already exi...more >>

Hi, I have installed SBS 2003 premium andSQL Server 2000 on my server with default settings and patched it using Windows Update site. Also, installed SQL Server reporting services. During setup, it warned me the Sharepoint is installed (I don't know how Sharepoint got installed) and at the end...more >>

I'm creating a report with Visual Studio 2003 and the reporting project. I'd like to group like: 1/1/04 Mary Bill John 1/2/04 Mary bill John Right now I'm getting the grouping: 1/1/04 Mary 1/1/04 Bill 1/1/04 John 1/2/04 Mary etc... The Groupings are: Group Header #1 is as...more >>

I am upgrading my RS server to a windows 2003 server and want to use the MySQL.dll for .NET. I know that I am able to add custom data sources to the report designer but have yet to figure it out. Can someone point me in the right direction with some very good documentation? Thanks Ke...more >>

I appologize in advance if this is a question that has already been asked. My problem is this, I am creating a report that will run on a daily basis, and I need to add weekly total lines. Something along the lines of, if the day is friday then add the row, which would calculate the totals for ...more >>

How do I include the report as part of the body of the emai?...more >>

Can someone help me figure out how to render a PDF in landscape? I have a report that has several subreports - some of which have portriat and landscape orientation. Right now, they all come out portriat. Is there a way to have one report render each page differently? Thanks, Jim JLEmle...more >>

I'm creating an expression in a textbox in a table. I would like to concatinate two expressions together. What function can do this? ...more >>

Hello Group, I am trying to set up a e-mail rendered Standard subscription in Report Server. I have edited the RSReportServer.config file according to BOL. Can anyone give me an example of a working SMTP E-mail enabled config. Thanks, Heres the error I recieve in My Subscriptions....more >>

Hello, I have created a report based on a stored procedure which uses 13 parameters. The 13 parameter values are mapped to the report parameter selections (for example: Parameter @CATEGORY, Value =Parameters!Category.Value). When the stored procedure is executed from the 'Data' tab of ...more >>

I have built some custom authentication library but have run into a problem. The custom code uses MySql.Data.dll(a library from MySQL for .NET) to authenticate users against a MySQL db. I get an connection error when I attempt to connect and believe that it is because of CodeGroup permissi...more >>

SETUP ME: internally I have sql server, vs.net 2003, iis5, sql reporting services setup on a machine. SITE2: site 2 has sql server, iis5, reporting services. On my interternal machine i create an ASP report using SQL reporting services report designer. How do i transfer this report and...more >>

Hi, Im trying to get my head a round the concept of Reporting Services. My setup involves a single IIS machine and multiple SQL server on different subnets. If reporting services is install on my IIS6 machine, is it possible to get it working with all SQL servers ? i.e can i setup ReportSe...more >>

When I attempt to install sql reporting services enterprise, i receive the following: "System Check results---asp.net is not installed or is not registered with your web server". I review services and iisadmin is there and running as is also asp.net state services which I had started to ru...more >>

I have created several reports that use multiple datasets. I have found two errors and I need help. First, is there a way to define the order in which the datasets are executed? In some of my reports, the first dataset populates a table that the remaining datasets query from. However, when ...more >>

The column and row subtotals in a matrix total correctly for a number field but do not for the % expression. = Fields!No_orders.Value/ Sum(Fields!No_orders.Value, "matrix1_txt_StoreDescp"). I either need to hide this for the totals or have it calculate correctly. -- cjm...more >>

I am using a matrix to display information on length an order is open. I have a caluclated column % to total for each row. The SubTotal for the columns shows a Percent that is one of the items in the row. How do I hide just the Total for the % and not the number column?...more >>

Hi, I have looked up information about my problem in this group but couldn't find any fitting solution. I have deployed a report to the report server. I've added a textbox to the report and delpoyed it again. When openening the report in the reportserver i still get to see the old report...more >>

I wanted to post this in case anyone else runs into it - save you loads of time. Yesterday we deployed our latest release of reports - someone forgot to move the pin on the report in source control and yet the updated stored proc for the report went out. Net result was the updated stored p...more >>

Hi all. I wont create template for my reports with header include logotype and name of the reports. Logotype and name included to box with green color, i wont that this box will have 100% width. i set 21 cm width as A4 format next i create my report use this template and deploy it to RS server...more >>

Reporting services will not install when sp4 of sql server is installed - it requires sql server sp3a. Any ideas to overcome this? Thanks -- Dawie Steenkamp...more >>

When I specify page break at the end of List it does not work but when I place a rectangle instead of list and apply page break at the end of rectangle it works.. Pl help.....more >>