Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR8 compiled isues!!!!!

Status
Not open for further replies.

TopKatz

MIS
May 9, 2000
69
US
Hello... I have some reports that were initaly developed in cr6.. they are part of a payroll billing system.. some reports print paychecks and others print bills. I compiled these reports using 6 and call them (the .exe) from a paradox program. They all worked fine untill.... I installed cr8. I upgraded to 8, and installed teh cr8 report compiler. I then opened all the reports in 8 and saved them in the as cr8 reports... then I ran the compiler. The paycheck .exe's all work fine... however the billing ones do nto work...they pop-up the little control panel, and when I press print I get the hour glas, then nothing..no errror... no report..nothing! Now all of my reports are saved in 8 format, so i cant go back to six... anyone have any ideas for me here?

Katz
 
Do the reports run OK in the V8 design environment?
Can they run from the EXE on the design environment PC?
Did you bring all 3 files for each report to the new PC (EXE, CRF, RPT) after compiling?
Are the Billing reports reading a different database?
What else is different about the billing reports?
Do they require other dll's that need to also be updated to V8?
Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
The reports all work fine in the v8 develepoment enviorment.

I can not run the exe created from the compiler from any pc... weitehr it has cr8 installed or not.

I saved the report to a remote dir (on my server) and then compiled it to the same spot... this is exactly how I did the payroll stuff...

They read from diferent db's then the payroll one.

the odd thing is that all the payroll ones work, and all the billing ones dont... they bills are all diferent, for our difernet contracts... the only thing that is identical accross all of the bills is the tables(maybe this is were I should be looking?,... why would they work fine in dev, but not after compiled?)

how would I know if they needed more dlls? wouldn't I have needed them with cr6?

thanx

Katz
 
If they don't run compiled in the same directory where they are compiled on the development PC, then dlls probably arent the problem.

If you double click the exe from explorer, on the dev PC, can you run the compiled billing reports? This eliminates the app as part of the problem.

What is the database platform behind these two systems? Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
If you are using DSNs be sure the DSN is in the SYSTEM DSN and not just the USER DSN. I had a customer who had situation similar to yours and by placing the DSN in the SYSTEM DSN this resolved the issue.

Rick
 
The exe's and rpt files are in the same place..they are shared in a programs dir, teh exe is called from my paradox app... weither I use paradox, or just brows to teh exe and click it, it does not matter...they do not work.

the db platform is paradox.... using bde... I have done nothing speciel with the bde stuff... the bde cfg is setup as it was when I developed the report... and is the same on all pcs on my network.... the bde.cfg that I use alows me to run the report just fine in development, and used to let me run the report in cr6.

Im not realy sure about DSN..is that for ODBC? Im not using that...
 
DSN is for ODBC, and it appears that you are connecting directly to the data.

I am stumped. It must have something to do with the billing database, but the fact that the report runs fine in design is the puzzle.

You are sure you aren't just reading saved data in design env? Make sure you can hit refresh and get new data. Sorry I can't think of anything else. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
one more thing.
Try creating a new simple billing report, then compiling it and see if it will run. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Thanx for your help....

I can refresh fine...

I guess I will have to start rebuilding teh billing stuff fromt eh ground up in v8... there must be some thing that I did in 6 that 8 just does not like

katz
 
Hi Guys.
I just went through this after designiong reports for client and moving them to his envirment. One of the issues was that the Application or design machine was a Windows 200 NT operating system. The 2000 Win NT for some reason does not seem to give the compiled icons general permissions and the Registry must be tweeked to let all users have the access to the icons. Our IT guy were out the exact details but try the access and registry of the Version 8 dlls.

Good Luck
Kit Sullivan
 
Well... I fixed the issue... It did not like one of the tables... we realy dont know why... I basicly removed stuff untill I found the isue... we thought it was because it was a older table..but after a rebuild, we still had problems. So we ended up creating a smaller table with just the information we needed, and every thing is now working...

thanx for all of your input

katz
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top