Hi I'm a first time user of Reporting Services - currently can't even install the product. Keep getting the following error: "Report Server Component Requirement IIS 5.0 or later is either not installed, or is configured in a way that is incompatible with a REporting Services installa...more >>

Hi, can chaptered recordset be used with Reporting Services. My dataset works fine (with SHAPE and APPEND commands), when viewing the results in the panel and if the column is a chaptered recordset is says "System.DataOleDb.OleDbDataReader", the question is how can i read this object by column ...more >>

hello, I am trying to use aggregae function within IIF clause. I am trying to run this code =iif( Fields!CLIENTID1.Value=Fields!CLIENTID2.Value,0,count( Fields!CLIENTID1.Value ). It gives me an error that aggregate functions cannot be used in report parameter expression. Can any one ...more >>

Hi, Can I set up RS and then install VB.NET 2003 at a later time to add the Report Designer functionality? Thanks Jerry ...more >>

Hello. Does RS have to be installed on the same machine as SQL Server in order to get scheduling to work? I created a schedule to run every minute (for testing). The time has come and gone, and the Next Run time on the Shared Schedules screen isn't changing, and the Last Run column shows...more >>

Hi, I have to install a new server and I am a little confused about working combinations between 30bits, x64 and IA64... My server use intel Xeon processors with EMT64. So I want to install Windows 2003 x64 Ent. but which version of SQL Server can I install? the 64bits? 32bits + SP4 (S...more >>

Hi all, My query needs to work with different back ends say oracle, sql server,db2 etc. so i need to make use of only the ansi sql. I need something like ="select col1,col2,"&_ "(case when parameters!gender.value='m' then 'some calculation'"&_ "when parameters!gender.value='f' then 'some ...more >>

Hello. I have created a domain account, granted the account Administrator access on the report server machine, have changed the two windows services to run as that account, and have created an Exchange mailbox for the domain account. I created a simple report that has no data source. I cre...more >>

Hello Chris, I have a data set with the following fileds: plan month leads orders I have made the following matrix table: month for column, plan for row, and leads and orders for the details, and subtotals. ----plan----------Jan------------Feb---------Total --------------leads order...more >>

I am displaying the output from a Report inside a literal. Everything is OK, except the images are not displaying. Is there anything special I have to do? When using preview or the MS Sample Report Viewer Control, the images appear. I cannot use the Report Viewer Control as I need to pass X...more >>

I hope someone can help me. I've tried to install RS but can't get it to work. I have XP Pro, VS 2003 Enterprise, SQL Server developer ed installed on my machine. I'm trying to install RS Developer Edition. I got a bunch of errors near the end of the installation but it said the installa...more >>

In some of my reports, I have both a bar and a pie chart. The pie chart renders the correct color, howerver the bar chard renders only green for the three bars when they should be different colors. This seems to be isolated as other machines render the correct colors... Suggestions on where...more >>

Hi gang - I've just recently begun playing around with SQL Server Reporting Services (SSRS), and I was blown away by it. I had no problem installing it to my development machine (XP Pro, IIS 6, SQL Server 2000 Dev Ed), but I'm having a lot of trouble setting it up in the production environmen...more >>

I'm having problems with the point label on the bar nearest the x-axis of a bar chart. All the other bars have the correct point label, displayed to the right of the bar, but this one does not display anything. I have tried changing: a) the sort order of the underlying dataset so that a dif...more >>

Can I access the Report parameters in the Data Processing Extension class library ? If not, Is there any other solutions for the Data processing extension programming to parametrize our data retrievings? Thanks in advance....more >>

I'm implementing Data Processiong Extension which shouldbe able to append additional restrictions (in where clause) to the sql query text. I've decided to get this restriction as parameter. If I set up parameter value in VS my extension gets it but If I use web interface of the Reporting Servi...more >>

Hey Im trying to display an image in a report in .PDF, but the problem is, that there will not allways be an image. Im retrieving the image from the database (MS SQL Server) but the table with the images is left outer joined with some other tables ie. it will allways return a row, but not all...more >>

Hi, i have a string representation like '200509'. I want to convert that to "Septembre 2005". So i've split the two parts up with the left and right function (now i've got 09 and 2005). Is there a way to say that the 09-part must transform automatically to "Septembre". I'd rather not use an...more >>

Is there a way to build one dataset from a stored proc that returns both a result set and some output parameters? ...more >>

I am trying to install Reporting Services on a Windows Server 2003/MS SQL 2000 SP4 system. The installation halts with "This edition of the Report Server Database is not supported on the edition of SQL Server 2000 you have chosen.". I could only find a reference for the above error message...more >>

Hi I'm developing an internet application that involves sensitive data. I don't want users to be able to access reports by using URL access outside of my application and passing parameters in the URL access. I know this is the way that Reporting Services works but I hope there is a way to...more >>

I have installed it but the only document I can find on how to use are the white paper (only 2-3 pages) plus the help file !!! I do not know how to do for example connect 2 cubes into one single table. Please can anyone help to advise where I can find some training document ?? Thanks !!! ...more >>