I am using the generic query designer and have defined 2 temp tables as follows: DECLARE @MainTable DECLARE @JoinTable INSERT INTO @MainTable SELECT.... INSERT INTO @JoinTable SELECT.... SELECT FROM @MainTable JOIN ON @JoinTable... My problem is the field list does not recognize all th...more >>

Hello I am using Reporting Services within Visual Studio .Net 2003, connecting to a SQL Server 2000 database. I've been using RS for a while, but only for basic reports. Now I want to do something a bit more advanced. I'm not sure exactly how to put the question, so am going for the 'pla...more >>

I am real new to SQL. I need to find out how if possible- a way to pull info from a csv file into a table in SQL automatically. Can anyone tell me if this is or not possible. If it is possible could you also direct me to where I could find the information as to how to do it. Thanks in adva...more >>

I want to sort my matrix by the subtotals. Is this possible? Does anyone know how to do this? Thanks...more >>

Hi, In the executionlog table of ReportServer DB, I can get the ReportID, I want to get the ReportName for that particular ReportID. How do i get it? Thanks Balaji -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200511/1...more >>

Is it possible to add the SSRS 2000 Report Designer to VS 2005 or is the only choice to use it with VS 2003? I see that some people have sucessfully done side by side implementations but we have already migrated our code to ..NET 2.0 and don't need VS 2003 around for other development work oth...more >>

So when I run the report in the Report Manager, everything is all good. When I run it in a webform using report viewer for vs.net 2005 the view reports this error. "The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation(rsAccessDeni...more >>

Hi, What are our options for developing for 2000 and 2005 "at the same time" / on one computer. I upgraded my local sql2000 to sql2005 and installed Visual Studio 2005 side by side with Visual Studio 2003. Now Visual Studio 2003 cannot open Sql2000 report server projects anymore and 2005...more >>

I believe that I read somewhere in the past that there was a setting in IIS that you could change in order to have the Report Manager not recompile on first request. As we all know it takes an unusually long time for Report Manager to start up the first time you call the application. I would...more >>

Hi, Does anybody know how to show a SS2005 KPI image in reporting services? Thanks....more >>

can i jump from one table to other table like navigation other report...more >>

Hi, Do you know how I could publish my reports like a rss Feed ? (I would like insert my reports into a web application (Jahia) ) I haven't read anything about this subject Thanks....more >>

Hi, I am trying to find out if I can embed report builder into a Delphi 5 application. Does anyone know if this is possible? Thanks, SD...more >>