Automated or on-demand CR report generation

[marfsplat]

I believe I have access to MS SQL Server 2000 Reporting Services - I was hoping I could use this to let my users view/generate the CR 10 reports I've already put together. I'm not sure exactly how to accomplish this, do I need a Visual Studio project? Is part of Reporting Services not installed? From the server, I basically have a link to the help file and the (empty) report manager web-based interface.

Does anyone have some good resources, links, tutorials that could give me a feel for what I need to be looking for in order to get this going? (or to let me in on the news that I'm barking up the wrong tree)

Thanks for your advice!

 

[IdoMillet]

Wrong tree (
Crystal Reports is not part of MS Reporting Services.

However, there are many alternatives in terms of BO's tools (such as Crystal Reports Server or Crystal Enterprise) as well as 3rd-party tools (see

http://www.kenhamady.com/bookmarks.html).

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[marfsplat]

I take it that means I can't export my CR report to XML and then find someone with Visual Studio to create a project to push it to Reporting Services?

That stinks, but thanks very much for the info!

 

[synapsevampire]

You might execute Crystal from within Reporting Servceis by writing code, depending upon your edition of Crystal.

I don't know of any clean migration path from Crystal to Reporting Services, which it now appears to be what you want.

-k

 

[IdoMillet]

Exporting from Crystal to XML is easy. This was not your original question.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Well, exporting to XML doesn't give them the report design and formulas though, just the data.

-k

 

[IdoMillet]

I think there's confusion here between RDL & XML. I'll stay out of the discussion... )

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[marfsplat]

Let me apologize straight off... I'm sure all the confusion here originates with me.

I'd like to use Reporting Services strictly because I believe it's already running (around here, somewhere, I'm new to this company) - but I'm really just after whatever's going to work - hopefully without my telling new bosses that I can't do this without spending a heap of cash...

I thought the XML export gave you a report specification, seems that's not true... There's also a report definition export - I was wondering if that equated to the report definition file that SSRS talks about...

My problem is that I'm trying to connect in-place existing systems, without actually knowing too much about any of them (save Crystal Reports and SQL Server).

Sorry I'm so unclear, it's all based in n00bishness.

 

[synapsevampire]

If you have the developer edition, you might execute reports using ASP or some such.

Anyway, they are competing products and aren't intended to play nice.

-k

 

[marfsplat]

*shudder* Tried that before. I'll never try to make MS play nice with a competitor again. Definitely been an educational experience here. Thanks, everybody.