Stack Overflow
Stack Overflow

Questions tagged [ssrs-2000]

SQL Server Reporting Services is Microsoft's server-based reporting generator. SSRS 2000 was its first version accompanying SQL Server 2000.

SQL Server Reporting Services is Microsoft's server-based reporting generator. SSRS 2000 was its first version accompanying SQL Server 2000. More info can be found in the general tag.

3 questions
1
vote
0 answers

Download RDS & Image files from SSRS Server with PowerShell

We have a SQL Server 2000 SSRS Server which cannot run many of the scripts I have found on the internet to retrieve Report Data Sources (RDS File) and Image Files (PNG, GIF). I have used PowerShell to download all the relevant RDL files as a batch…
Ryan Gillooly
  • 315
  • 1
  • 5
  • 20
0
votes
1 answer

SQL Subquery w/LEFT JOIN causing Invalid Object Error

I have a query with the following structure: EDIT Original structure of the query wasn't quite representative. SELECT A ,B ,C ,D FROM ( SELECT id,A FROM myTable WHERE conditions GROUP BY id,A)…
tmoore82
  • 1,857
  • 1
  • 27
  • 48
0
votes
1 answer

SQL Subquery Syntax Error Near ')' -- Not missing alias

I have a similar problem to this one, but the solution in that case was to add an alias to the subquery. In my case, each of my subqueries has an alias, but I'm getting the message Incorrect syntax near ')' at the end of each of my subqueries. I'm…
tmoore82
  • 1,857
  • 1
  • 27
  • 48