Current Position:Home > Migrate from Crystal Reports to XMLP?

Migrate from Crystal Reports to XMLP?

Update:11-30Source: network consolidation
Advertisement
We have a bunch of reports implemented with Crystal Reports and we are planning to migrate those reports to XMLP. Is that possible? Dose anyone has the same problem? What is the general process? I have no experience about XMLP before.
Thanks in advance

The Best Answer

Advertisement
Hi Tim,
Thanks for your reply, Yes, for the data we can utilize the query from the Crystal report. But after Crystal Reports get the data, it can do extra things on the data, such as applying some functions on the raw data. It can also define some Formula Fields out of the data. the Formula Fields can be placed in the reports too. The defination of Formula Fields can be very complicated involves a lots of operators include +, *, IF/THEN/ELSE, SELECT CASE, AND/OR, and so on, there could be some pre-defined function in also, here is one example of Formula Field definition(Notice that the definition can contain other Formula Field):
Dim EndDateCounted As DateTime
Dim StartDateCounted As DateTime
Dim Diff As Number
Dim EndDateParam As DateTime
Dim SummaryField As Number
If {@OnlineTime} <> 0 then
EndDateParam = DateAdd("s", 86399,{?EndDate})
EndDateCounted = dateadd("s",{timeDim.SECONDOFDAY} + {agentEvent.EVENTDURATION}, {dateDim.FULLDATE})
If {dateDim.FULLDATE}>= {?StartDate} and EndDateCounted <= EndDateParam then
SummaryField = {@OnlineTime}
Else
If EndDateCounted > EndDateParam Then
EndDateCounted = EndDateParam
Else
EndDateCounted = EndDateCounted
End If
If {dateDim.FULLDATE} < {?StartDate} Then
StartDateCounted = CDateTime({?StartDate})
Else
StartDateCounted = dateadd ("s",{timeDim.SECONDOFDAY},{dateDim.FULLDATE})
End If
SummaryField = datediff ("s", StartDateCounted, EndDateCounted)
End If
Formula = SummaryField
End If
How can we achive the same thing using XMLP? Since Formula Fields are widely used in our reports. You said the data should be the simplest, dose it mean we calulate whatever we need in the query/extraction and feed the RTF with the final result using XML?
Thanks,
  • Migrate from Crystal Reports to XMLP? Update:11-30

    We have a bunch of reports implemented with Crystal Reports and we are planning to migrate those reports to XMLP. Is that possible? Dose anyone has the same problem? What is the general process? I have no experience about XMLP before. Thanks in advan

  • Migrating from Crystal Reports Charts using TopN and "Other" to Reporting Services Update:10-11

    I am currently migrating several Crystal Reports that have charts.  The chart series is set to use the TopN values in a count, and combine the rest of the series into one series titled "Other".  I see how to filter the chart using TopN, however

  • Migrating from crystal report 8.5 to 10.0 giving error Update:10-11

    migrating from crystal report 8.5 to 10.0 giving error I am working in migrating my cr application to 10th ver from the existing 8.5 where we have to explicitly make a query in query builder and then attach it. I was using dsn in ms odbc for oracle d

  • Migrating from crystal report 8.5 to 10.0 giving error 01S00:error Update:10-11

    migrating from crystal report 8.5 to 10.0 giving error I am working in migrating my cr application to 10th ver from the existing 8.5 where we have to explicitly make a query in query builder and then attach it. I was using dsn in ms odbc for oracle d

  • Migrate from Crystal Report XI R2 to Business Objects XI R2 Update:10-11

    Hello friends, As per end of licence life cycle for Crystal report, we need to migrate our 30 crystal reports to BO xi r2. First thing i need to ask is that ...is this possible to migrate from Crystal report XI R2 to BO xi R2 ? If yes than where i ca

  • Migration from crystal reports 8  to 11 - Formatting Issue(Criticial) Update:11-30

    Post Author: DJ Gaba CA Forum: General I have migrated my crystal report version from version 8 to version 11 (evaluation version) but I am seeing some formattiong issue My entire report data has moved little bit toward right so my rightmost line (ta

  • Error after migration to Crystal Reports 12 for existing reports Update:11-30

    Hi, We had reports written using Crystal Reports Version 8.5. These reports were not modified for a long time. Recently, we had migrated to Crystal Reports 12 (2008). Some of the these existing reports were modified using the Crystal Reports 2008 des

  • Migration from Crystal Reports 2008 to Crystal reports Enterprise(BOE 4.0) Update:11-30

    Dear all , I m currently doing a project on Crystal reports 2008 where datasource is mostly SAP BW queries.  Our customer will have BOE 4.0 in coming months .  I have heard that in BOE 4.0 Crystal reports for Enterprise will be a better option for BW

  • Migrate from Crystal Report Server XI R2 to new Eclipse RAS SDK Question Update:11-30

    Hi, I am migrating Crystal Report Server XI R2 RAS SDK to Eclipse RAS SDK which seems to be quite easy. I have the following old code which basicly programmaticly creates a Report from scratch adds a Table and then populates the Report with a Pojo Co

  • Migration from crystal report 8.5 to 10.2 Update:11-30

    Dear Sir/Madam, I have an application written by vb .net 2005 with crystal report 8.5. Do you know how I can upgrade the crystal report from 8.5 to 10.2? Are they totally different? Or there are some references about this migration. Thank you for you