converting reports

Hello.
Any one know of a utility to convert reports from Access and Crystal into
SRS?
Thanks in advance for any input
Regards
HSYou can import Access reports directly in the dev environment... Crystal you
will have to do manually... However I think HItachi has developed a
conversion tool ( not for sale ) , but one their consultants use on their
gigs...It might be cheaper to hire them...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"HSalim[MVP]" wrote:
> Hello.
> Any one know of a utility to convert reports from Access and Crystal into
> SRS?
> Thanks in advance for any input
> Regards
> HS
>
>

Converting Query Files in Crystal Reports 11

Hi All,
I was developing custom reports using crystal 8.5.Most the report have Query files attached to them. Now we have plans to migrate all those reports to crystal 11.Is this possible without any major changes? if yes how. I am very much used to creating Query Files in Crystal 8.5.I am confused how I can generate similar reports without using the query files in Crystal 11.
I think we can create business views similar to query files and develop the reports using those business views. Is this correct?
Can any please give more information on this regard.

I appreciate your help.

Thanks,
Sree.See if you get these informations here
www.businessobjects.com

Converting old Reports to Crystal 10

Hi you all,

When I try to open some reports (that were created using Crystal 5) in Crystal 10 I get the following warning as a pop-up window:

THE DATABASE FILE "XXX" HAS CHANGED. PROCEEDING TO FIX UP THE REPORT

After that, the report brings wrong data (different from the data that was brought by the original report).

Is this error common ? Should I have to re-write the queries ?

Thanks
Herr BurnierHy,

Your database design has maybe changed ?
What's happen if you "Verify database" on cr10 ?
Try to verify to database location.|||I get the same message even when I run "Verify Database". Crystal 10 tells me that tables have changed and it will fix them up.

The message even says that it cannot find a certain table and asks me if they should remove it from the report...

I have confirmed the location of the database and these tables.

The reports do work OK though if I do not make any suggested changes to the tables.

Strange.|||I found the answer.

In version 10 I had to Set database Location and update the tables, even though the names and locations were exactly the same as in my 8.5 reports...

Now I can verify the database with no errors or problems!

Converting numeric to non-numeric?

I'm a beginner to Crystal. Honestly, I had no intention of learning it beyond a user level but our developer is MIA and we need to tweak our template. We have a field that use to be a number (a "MapID" in this case), it would be 1, 2, 3, 4, etc. Now we want it to reflect a different ID that is going to look like 1a, 1b, 1c, 2, 3a, etc. I've changed the RPT query in access to populate with the new ID, keeping the column the same, but of course nothing in life is that simple. When trying to export the Crystal Template to PDF I get this error almost immediately:

"The string is non-numeric"

The Formula Workshop pops up and says this:

CDbl({RPT_Detailed_Findings.MAPID})

By going to the subreport and right clicking on the specific field and going to Edit Formula the Formula Workshop says this:

If {?Pm-RPT_Detailed_Findings.source} = "mapped" then
{?Pm-RPT_Executive_Summary.MAPID}
else "Unmapped";

I am so new to this I can't really see why it would only accept a number, my only guess is that the restriction has to do with "CDbl" or "?PM". Am I even close?

I'm in a jam here as there is nobody else to go to in the company, I'm it. And the developer is non-responsive.

Thanks for the help.remove cDbl,

as 1a ur new id is already string, u cannot convert it to a double numeric value

Hope it helps|||Now they are all out of order and the letters still did not come in, also I believe only the records that did not have letters made it into the report. The report exported though.