Is there any way to convert RS 2005 to RS 2000? Or should I rewrite report manually?...more >>

Is there anyway to get a Subreport to render in a group footer? It is not a (sub)report problem, as it renders fine as a standalone report. It is not a parameter problem, as I can hardcode all of them and it still fails. It is not a NULL value for the grouping, as it cannot be NULL. Any idea...more >>

Hi all, Little question for you all: does the SQL express (Advanced) edition come with end user report builder tools? Will it be possible for an end user to build reports itself? Thanks in advance, Peter ...more >>

I know this is 101 stuff, but I'll be danged if I can figure it out. I have a stored procedure that returns OrgID, OrgName. I want to show OrgName, for the client to choose from, and assign OrgID to the parameter, to pass to the report stored procedure. Help, please.... msflinx...more >>

Im running a report in RS-2005 and i need to create a new table based on the count of groups in another column. Curently our databas is in VFP 9 so im using "Microsof OLE DB provider for visual foxpro". the problem is i cant even get a basic GROUP BY command to work in the query designe...more >>

I am seeing my reporing server (v2005) has a conneciton to my db server that is causing blocking. the dbcc inputbuffer results show this: " ReportServer.dbo.WriteLockSession;1 " I dont see any entries on Google for this problem, does anyone know what the RS server is doing? the thread appears...more >>

I've got a ton of reports that effectively have 3 parameters FranchiseID Period Year Even though period and year parameters have no parameters that point to franchise, I always have to select a period before I can choose a year. I don't see anywhere in the report designer to say this pa...more >>

Hi When i try to deploy a report from VS, it asks me for a user name and password to connect to Report Services. I am the administrator on the machine. Any help would be appreciated. -- Gerry Connolly...more >>

Hello, I have an issue with multivalue parameter. I need to pass it to stored procedure. FE I have @parameter that can have multivalue. When I use select statement in report it very easy: select * from table where col1 in (@parameter) But when I want to pass it to stored procedure exec s...more >>

Hi, Is there anyway you can disable pagination so when a report is rendered in HTML it displays all the rows in one page. I am displaying the reports without the RS toolbar and do not want to use the page functionality. I understand that it is more effecient to use pages but I will only e...more >>

Does anyone have a script laying around to set up the ReportServerTempDB database with RS 2000? ...more >>

Hello, I need to create TOP {n} report where n - parameter. In Crystal its very easy... Is it similar way to do it here? I need to return all value (I need to have total SUM) from dataset and then show only n rows in the report (I need to show total for this N rows)... I can do it using Visab...more >>

Running a .NET web app on a web app server, while SQL 2000 (standard) runs on a separate DB server behind it. Question is, can I install RS on the DB server and still serve reports from the web/app server? So as to avoid an extra SQL license for installing RS on that box? I noticed RS in...more >>

i have a problem with mdx query. here is a simple example of what i=B4m trying to do select {([Project_Owner].[Project Owner],[Date].[Year])}ON COLUMNS, {([Customer].[Customer name])} ON ROWS from [TestCube] this query works fine... my problem is that the [Customer] dimension has 3 members...more >>

Hi, I have created some reports using SQL Server Business Intelligence Studio 2005. How can I call these reports in my java application. Any sample example will be of great help. Thanx, Aruna ...more >>

I have a column with e.g. 5 values A,B,C,D,E I need a table that groups on this value but in 4 groups: A,B,C,D+E Is there an easy way to do this? Thanks Daniel...more >>

Hi, We have a load of personal records like (e.g.) these Name, Function, Stardate,Enddate Fred,assistent, div1, 1/1/2001, 31/12/2004 Richard,assistent, div2, 1/1/2001, 28/2/2003 Richard,director, div2, 1/3/2003, 31/7/2003 .... Now we need a matrix showing how many people works at date 1/7 of ...more >>

Hi, I want to build Dynamic MDX query in SQL Server 2005. Is it possible? ex. I have one SQL Server Report parameter which contain following value: 1. Station 2. Free Test I have three Dimension Station, Free Test, Overall Result and one measure Total Test. If I select Station in re...more >>

Hi Peoples, I'm trying to pass parameters from one report to the other. Setting them seems to work fine, but I don't get how to pick them on the target report. I've tried setting them to the same name, but they just don't seem to get picked up... any ideas gratefully recieved :) ...more >>

maybe my word will be confusing for you all..actually i want to deduct 2 select statement to get a result.this is due to not knowing how to use coding in mssql...i'm using visual studio 2005...this is the select statement.... SELECT a.no_akaun, a.nama_penyewa, SUM(b.Amaun) AS sum1, ' ' AS ...more >>

I'm trying to create a Report Model as per article http://msdn2.microsoft.com/en-us/library/ms345313.aspx I am logged-in as local administrator, part of the BUILTIN\Administrators group. This group is part of the "System Administrator" role under "Site settings... Configure site-wide securi...more >>