Micros 5.0 Custom Reports Issue 1

[POSINSAM]

I am wondering why my 4.X custom reports won't seem to run in report viewer in 5.X. Is it a different version of Crystal Reports?

 

[POSINSAM]

Im getting Code 20: Incorrect template datasource. BTW…. Thanks in advance

 

[Moregelen]

Do you have crystal reports installed? You can open it up and do a verify database.

Is your custom report using any kind of custom procedure? Make sure the permissions didn't get blown when you upgraded.

 

[POSINSAM]

I thought having crystal Installed on the server would cause Micros to fail. Has that changed in 5.0? Can I have Crystal installed on this server? What version should I have installed for 5.0?
I think I figured out a bit of it… I am specifically having problems with TCTipsAndSales w rate.rpt , TCAndTips9AndPayrRate.rpt , TCDetail.rpt , TCTipsAndSales_New.rpt , TCTipsAndSales.rpt . None of those come up in 5.0 .
Do you have any of those reports for 5.0 you could post?

Thank you so much!!!

 

[Moregelen]

Don't install crystal reports on a Micros box. Crystal reports has to be installed before you install micros if you want it on a Micros server.

Those aren't standard reports so I wouldn't have a copy sorry.

 

[POSINSAM]

No prob. I figured I wouldn't get that lucky Thanks. So you think starting with a box with Crystal installed, installing 5.0, then doing a verify database is the way to go?

 

[Moregelen]

Shouldn't have to do that much. On another computer on the same network hopefully with crystal already installed, copy the SQL Anywhere 11 folder from Micros to that computer. Register the DLL, setup a DSN, and just remote connect. If you really want crystal on the same box that you have RES on I think installing Crystal and then running either the most recent patch or the RES 5 repair will find things, so you don't have to completely uninstall. I just tend to not install directly to my Micros lab.

ODBC setup info:

https://www.dropbox.com/s/ssc1yy254z1uty7/Setting up the Micros connection on a remote computer.pdf

 

[POSINSAM]

Thank you very much!