Crystal Reports to SQL Reporting Services Migration

Does anyone have any recommendations for the best approach to migrating
Crystal Reports to SQL Reporting Services?There isn't a "quick" convert option - Crystal being a proprietary report
format limits you from stripping out information about the report. You could
use the "report defintion" option to find out details about the report,
etc...but this is purely for informational purposes
The reality is you will have to re-build your reports. The only reusable
components would be the SQL statement, if optimized, or other source info
(stored proc's, etc...). The rest would be fresh.
--
MGM
"CaskeyRW" wrote:
> Does anyone have any recommendations for the best approach to migrating
> Crystal Reports to SQL Reporting Services?|||Thanks for the reply. That's what I expected, but thought it was worth asking.
"MGM" wrote:
> There isn't a "quick" convert option - Crystal being a proprietary report
> format limits you from stripping out information about the report. You could
> use the "report defintion" option to find out details about the report,
> etc...but this is purely for informational purposes
> The reality is you will have to re-build your reports. The only reusable
> components would be the SQL statement, if optimized, or other source info
> (stored proc's, etc...). The rest would be fresh.
> --
> MGM
>
> "CaskeyRW" wrote:
> > Does anyone have any recommendations for the best approach to migrating
> > Crystal Reports to SQL Reporting Services?|||There is help on the way. A Microsoft Partner Readiness seminar covers, in
part, migration from Crystal Reports to SQL RS
http://www.msreadiness.com/
http://www.msreadiness.com/WS_abstract.asp?eid=15003226
--
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"CaskeyRW" <CaskeyRW@.discussions.microsoft.com> wrote in message
news:CB4241D5-5972-46ED-A3D8-B84EEB72E3AD@.microsoft.com...
> Does anyone have any recommendations for the best approach to migrating
> Crystal Reports to SQL Reporting Services?|||Jeff,
Thanks for the reply. We've already moved forward doing it manually and
have actually completed the migration. Once we developed kind of a process
or pattern for doing the conversion, it wasn't too bad.
Regards,
Rick
"Jeff A. Stucker" wrote:
> There is help on the way. A Microsoft Partner Readiness seminar covers, in
> part, migration from Crystal Reports to SQL RS
> http://www.msreadiness.com/
> http://www.msreadiness.com/WS_abstract.asp?eid=15003226
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "CaskeyRW" <CaskeyRW@.discussions.microsoft.com> wrote in message
> news:CB4241D5-5972-46ED-A3D8-B84EEB72E3AD@.microsoft.com...
> > Does anyone have any recommendations for the best approach to migrating
> > Crystal Reports to SQL Reporting Services?
>
>

Crystal Reports join question

Hello all.

I am migrating an access report to crystal reports and having trouble. I have two tables that link each other, but they are different data types. This works fine in access because I can cast one of the fields using cstr(). See query below:

==============================================
SELECT Sum(Tax_Detail.Tax_Amt) AS SumOfTax_Amt, Taxer.Collection_Account

FROM Invoice_Header INNER JOIN (((Invoice_Detail LEFT JOIN Tax_Detail ON cstr(Invoice_Detail.Invoice_Detail) = Tax_Detail.Owner_ID) LEFT JOIN TaxCode ON Invoice_Detail.Tax_Code = TaxCode.TaxCode) LEFT JOIN Taxer ON Tax_Detail.Taxer = Taxer.Taxer) ON Invoice_Header.Document = Invoice_Detail.Document

WHERE (((Tax_Detail.Owner_Type)=0) AND ((Invoice_Header.Document_Date) Between '3/1/2007' And '3/31/2007'))

GROUP BY Taxer.Collection_Account;
==============================================

Does anyone know how I can create this join from Crystal?

Thanks,
bubutYou will need to use Crystals add command through the database expert. There you can paste your sql and it should work.
GJsql

Crystal Reports 8 User session expired error

Hi,
As we are migrating from NT server to Win 2003 server. web applications are moved over from nt as well. I am facing problem with one the web apps which uses crystal reports 8. "User Session expired" error msg is popping out when we try to export the report into any supported format such html, excel, word etc.. The report comes up no issues..however unable to use export option.

I went through the business objects .pdf for user session expired err msg...but nothing helped. i am still stuck with this problem.
can anybody help me here pls.

FYI...It's a ASP/VB web appl using crystal reports 8.0 on Win 2003 machine.

thanks
DRM.Hello,

Further to my earlier msg, after commenting out the default error msg "User Session expired" i got this error msg

"The Report was not Exported. The selected report format may be disabled on the server" actually this is common msg coming up for all export formats...available in crystal 8.0 version.

Therefore, any ideas how to check/verify and Enable/Disable this on server?

ur help on this will be greatly appreciated.

thanks a ton in adv.

Cheers,
muki