RDD and Crystal

Yahoo Archive
1
Ken,
We just recently moved from 9.04 to 9.05.700 and most of our reports moved fine. The one issue I had was 9.04 allows you to modify the some items of the system data definitions. The reports that had modified system data definitions obviously didn't work.

Carson




--- In vantage@yahoogroups.com, Ken Taylor <ktaylorv@...> wrote:
>
> Hi Epicor Report Gurus,
>
> I am running Epicor 9.05 in a test environment from vs 9.04. Can I use all my custom crystal reports? They tell
> me that I have to recreate the Report Data Definitions, is that accurate? about 100 custom reports, some from
> RDD and others from BAQ and Report Designer. Can't believe the conversion missed this step. I understand
> that Crystal XI has been replaced with Crystal 2008. Any thoughts or shortcuts? Appreciate your help.
>
> Ken
>
> [Non-text portions of this message have been removed]
>
2
Hi Epicor Report Gurus,

I am running Epicor 9.05 in a test environment from vs 9.04. Can I use all my custom crystal reports? They tell
me that I have to recreate the Report Data Definitions, is that accurate? about 100 custom reports, some from
RDD and others from BAQ and Report Designer. Can't believe the conversion missed this step. I understand
that Crystal XI has been replaced with Crystal 2008. Any thoughts or shortcuts? Appreciate your help.

Ken

[Non-text portions of this message have been removed]
3
--- In vantage@yahoogroups.com, Ken Taylor <ktaylorv@...> wrote:
>
> Hi Epicor Report Gurus,
>
> I am running Epicor 9.05 in a test environment from vs 9.04. Can I use all my custom crystal reports? They tell
> me that I have to recreate the Report Data Definitions, is that accurate? about 100 custom reports, some from
> RDD and others from BAQ and Report Designer. Can't believe the conversion missed this step. I understand
> that Crystal XI has been replaced with Crystal 2008. Any thoughts or shortcuts? Appreciate your help.
>
> Ken
>
> [Non-text portions of this message have been removed]
>

Hi Ken,

If the tables didn't change between versions then I cant see why you cant use your custom crystal reports. RRD's where converted for us but we come from 8.0 so due to the large table changes I re-created, didn't take me too long. Some of our BAQ's needed changes but that was due to field names changing, 95% of the time they were fine..... run the analysis buttom to check the syntax and save it. If you dont have an issues with your baq and you dont save it then the column headings done come through is all. You will have some work to do but I dont think you will have to start again.

cheers
4
We were able to bring most of our custom reports (custom RDDs and BAQ reports) all the way from Vista 8.03 without too much of a problem. There were some that I had to recreate from scratch, but most came through fine, maybe with a column change here or there. Test out each report and verify the database inside the Crystal Reports developer to relink any changed columns.

I believe we exported the BAQs from our 9.05 test environment for the final move and made copies of our fixed report files.

I recently figured out a way to export my RDDs out of 9.05 so I can have external backups of those as well.

My (unsupported) suggestion if you print labels from Crystal is to run Crystal Reports 2008 SP4 rather than SP3, as it's fixed some formatting errors for us.

--- In vantage@yahoogroups.com, "Paul Morgan" <paul.morgan@...> wrote:
>
>
>
> --- In vantage@yahoogroups.com, Ken Taylor <ktaylorv@> wrote:
> >
> > Hi Epicor Report Gurus,
> >
> > I am running Epicor 9.05 in a test environment from vs 9.04. Can I use all my custom crystal reports? They tell
> > me that I have to recreate the Report Data Definitions, is that accurate? about 100 custom reports, some from
> > RDD and others from BAQ and Report Designer. Can't believe the conversion missed this step. I understand
> > that Crystal XI has been replaced with Crystal 2008. Any thoughts or shortcuts? Appreciate your help.
> >
> > Ken
> >
> > [Non-text portions of this message have been removed]
> >
>
> Hi Ken,
>
> If the tables didn't change between versions then I cant see why you cant use your custom crystal reports. RRD's where converted for us but we come from 8.0 so due to the large table changes I re-created, didn't take me too long. Some of our BAQ's needed changes but that was due to field names changing, 95% of the time they were fine..... run the analysis buttom to check the syntax and save it. If you dont have an issues with your baq and you dont save it then the column headings done come through is all. You will have some work to do but I dont think you will have to start again.
>
> cheers
>
5
Sorry Ken - I hear your pain! Fortunately we try to do a lot with SQL so I only had a few RDD reports. In each one of them I opened up the RDD in v8 and did a side-by-side comparison to create them in e9.

Once I got them all working in my test environment I used the Solution Manager to try to move them live. BIG mess! The solution manager was creating child keys but not the parent entry in the tables the data is stored in. You couldn't create the parent record (e.g. report definition name) because it registered as a duplicate even though you got a record not found trying to look it up. As of 9.05.607 the bug in the solution manager has not been fixed.

I remember there was some dance with using a different name when you reimported the definitions but guess trauma has made the memory fuzzy.... Maybe someone in the user group has gotten these moved over by going at the data in the tables - I took the long road.

Good Luck!
Jenn


[Non-text portions of this message have been removed]