Reporting Service interoperability

Hi,

I'm evaluating Sql Server 2005 for my company. Here we also use AS400 DB2 for our ERP. Could I use Reporting Service to create report on DB2 in the same way as someone could use MS access?
TIA

Marco Paci

Yes. You need to go to the IBM web site and download the db2 drivers. I think the package is IBM DB2 Client Access Enabler (CAE).

You then need to write your DB2 SQL in the report which can get kind of hairy. If I can get away with it, I write SSIS packages and write the reports using SQL Server.

Reporting Server - Crystal Conversion Utility

the company is evaluating using SQL Server 2000 Report Server - the biggest question as you might anticipate is whether Microsoft has, or plans to develop a utility to convert crystal reports to the RDL. Any news'?
Thank you!!!-- ralpheherts wrote: --
>the company is evaluating using SQL Server 2000 Report Server - the biggest
>question as you might anticipate is whether Microsoft has, or plans to develop
>a utility to convert crystal reports to the RDL. Any news'
--
Hi
I asked this very same question to the Tech-Ed 2003 Reporting Services speaker. The answer was NO.
But this is a great opportunity for third parties
Hope this helps
-Eric Cárdena
SQL Server suppor