Solid Crystal Report XI resources for a SSRS Report Writer

Hi Experts,
I’ve been charged with converting 3 complex Crystal Reports XI rpt to SSRS 2008 rdl.

Whilst I’m familiar with SSRS, I haven’t used Crystal Reports in almost 10 years and I’m struggling!

I’ve done a quick search on the web for Crystal Report tutorials so I can better understand the current reports but they are either too deep or too basic.

Can anyone provide good weblinks to Crystal reports resources / books that will suit an SSRS developer so I can better convert these reports?

I’ve got a mere TWO WEEKS to complete the project!!! Typical. :)

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

There is a commercial tool that claims to convert from Crystal to SSRS

What are you struggling with?
The 2 technologies are very different in the way reports are created.  As such it may be easier to use a preview of the report in Crystal and produce the SSRS version from scratch.

The reference I like best is the series by Peck Crystal Reports XX - The Complete Reference.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnDiddy77Author Commented:
At present I'm stuck on Cascading Parameters. Crystal Reports seems to manage this by referencing a view. I've tried implementing said view in a SSRS cascading parameter and it just fails everytime!

Any thoughts?

Furthermore, since Crystal Reports and SSRS have different methods of creating reports shall I assume that I may need to rewrite sprocs etc... to get it all working?
I don't use SSRS.  I had a project at one point where they suggested moving to SSRS so we tried to build some sample reports.  Before we got very far in the development they called off the effort.  

I don't know how to do cascading parameters in SSRS or what the requirements are for the data source.
I would think if you are using stored procedures then they should work as the source for either.

Hi John - I inherited some SSRS reports that use Cascading parameters (which, on these reports anyway, work WAY better in SSRS than they do in Crystal!!)

The person who built them in SSRS had actually created stored procedures to populate both the report and the prompts, but I'm not 100% sure how he did it. I could see the select statements  for the parameter values inside the stores procedure.

I know this doesn't answer your question, but it might help to get you in the right direction. Maybe do some googling on Stored Procedures, Parameters, Available Options, SSRS.
Oh also - regarding the stored procs. As long as the procs are built in SQL Server, where the final section/output is a SELECT statement of some kind, Crystal and SSRS can both understand this without issue. I have had a lot of difficulty with Oracle stored procs in SSRS (still haven't figured it out... Crystal required a cursor return, and perhaps SSRS does not).
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.