Is this possible with SSRS?

Hi. We currently have about a 100 Crystal Reports with embedded images and text in the *.rpt files. If we were to switch to SSRS 2005,
Can we do a global search-and-replace of images and text within the SSRS reports? We have some letterheads that have names of people who might change every year or two.
Are there any tools to convert Crystal Reports *.rpt files to SSRS reports? These 100 reports would be time-consuming trying to convert to SSRS.
Thank you much
Alex

1. Yes.

2.

I’ve been asked many times if Microsoft provide a tool for converting legacy Crystal Reports to SQL Server Reporting Services. The answer is no. However I do know someone who does.

Hitachi Consulting has an RDL generator that will generate RDL from Crystal Report formats. They’re in the States but I’m sure they’ll be able to help UK customers.

You can find a link to their site from this list of all our Reporting Services consulting partners: http://www.microsoft.com/sql/reporting/partners/consulting.asp[/quote]

http://blogs.technet.com/mat_stephen/archive/2005/02/01/convert-crystal-reports-to-sql-server-reporting-services.aspx

|||

1. Unlike Crystal, SSRS has an open XML-based report definition language. So, you can either use a file utility to search and replace or programaitcally load the report definition, e.g. in XMLDOM, with more involved requirements.

2. To my understanding, Business Objects doesn't currently let third-party vendors to offer migration tools. Instead, most companies do this as a service where you pay the company to convert the reports for you. This is actually a good possibility for outsourcing. Greg provided links to some vendors.

Is there such a thing as creating an unbound report with Crystal Reports?

I am using Crystal Reports in the .NET 2005 environment. Let's say I want to create a simple one page report (like a memo) and I want one field on the report (this is not exactly what I need to do but this example addresses the concept I am looking for). Let's say I have no database and my data is in a string variable. how the heck can I dynamically set the value of the field on the report to that variable without implementing some crazy pseudo-binding strategy?

To me, it seems as though this is the most basic report possible and yet from all of my reading and searching it seems that this cannot be done with some simple syntax such as:

ReportSource.ReportObjects("Field1").Text = stringVariable;

Did Crystal leave that most basic and fundamental property out of their data model for a reason?

Should I look at alternative reporting products that are less database centric?

I used to use DataDynamics ActiveReports and it worked just like that above, however I would prefer to use Crystal as it is more industry standard.

Any help would be appeciated. Thanks.

-KevinI always love it when people answer their own questions! Well here is the answer to mine. I found it indirectly on another thread! Go dev-archive!

JournalMemo journal = new JournalMemo();
journal.DataDefinition.FormulaFields["UnboundString1"].Text = "\"It Worked\"";

That is easy enough although it would have been more intuitive if I could have done that from the ReportObjects collection.

JournalMemo is a Crystal Report that I created with the designer in the IDE. The actual JournalMemo.cs class is created by Crystal Reports when creating an embedded report in the designer and it inherits the ReportClass class.

Is there ANY way to display "recurrent" data in Crystal?

I wonder if it is possible to somehow display self-recurrent data in Crystal reports.

Say, I have a "Department" table that contains link to itself. Since the department structure of a company can be complicated, I don't know how many levels of department will be in any "root" department. I want user to "drill in" via some kind of a tree until the final department level is reached. Ideally, it should be possible to display other data (such as names of employees) for each department.

I realize that each step down in department tree will require a separate SQL query to be sent to the server. And I also want the data to appear in the same window, just like an ordinary drill-down feature of Crystal. Is there any way to something like this via RDC and VB?

Thanks in advanceGroup it by DepartId and goto Report-->Hierarchical Grouping Options and set the child

Is there any option to create a formula object by copy paste

Friends,
crystal report 8.0
I really fed with creating formulas in crystal report. there have hundreds of formula. and almost same formula is there but I couldn't copy this to new.
please help me. thanks in advance.Can you give more information on where you are having problem?

Is There Any Body To Help Me....?

hi
I am having 120 crystal reports of 9 and when ever I want to change the DBuser I am facing problem and i have to change for all the 120 reports
IS THERE ANY EASY SOLUTION FOR ME..?
:thumb:I think there is nothing in crystal reports that you can't automate with Visual Basic. There is a lot of help around on the internet on this. You might want to have a look at this to start with...
http://www.codesforall.com/cr/articles.htm|||poor u. u can customize 1 CR to handle all 120, providing that they r all columner reports. u can change the DB user, location, etc at run time using Vb code.
u can find answers if u check other answers on this forum, so i'm not repeating the same stuff