Or by unchecking the option save data with crystal report File menu option, still I need to click on RefreshBtn. While this is not a pure Xojo solution, you can run Crystal Reports from Xojo. (Embedded image moved to file: pic16282.jpg) Thanks for the help. Other than my time, Eclipse, Crystal Report add in for Eclipse, JDBC MS SQL drivers are all freely available for download. When I called SAP about what I was trying to do, Tech Support said we basically give you a ton of wood to build a birdhouse. I’m working on passing parameters from Xojo to the jar right now.Īll of this requires a tremendous amount of work to get the Eclipse environment working just right with the Crystal Report Add-in. It opens up my jar file which has the Crystal Report Viewer in it which then opens the report just fine. S.Execute('java -jar ' + f1.NativePath + ' TERM' ) #If TargetMacOS dim f as folderitemį =getfolderitem( 'Documents/Eclipse/CRJava1/CRJava4.jar')į1 = ('Eclipse').child('CRJava1').child('CRJava4.jar') I’m able to launch the Java jar file from Xojo on OS X or Windows like this: (It’s the same jar file) Eclipse lets you create/modify CR reports on the Mac also. and then loaded it into my Java Crystal Report Eclipse project which is running on my Mac.Įclipse lets you build an Executable Java jar file which can have embedded reports in it. I actually created the report in Windows first with the JDBC connection to my MSSQL Server.

Setting up JDBC’s connection string in Crystal was a real challenge. It has a Crystal Report addin (everything is in Java including the database connection - JDBC - I have limited knowledge of Java). However I stumbled across The Eclipse environment while Googling around. You can get the the Crystal report viewer, but the report has to CONTAIN the data in order to use it. Without the SAP Crystal Server / BO products it seemed like a dead end. I really wanted to run a Crystal Report from Xojo on my Mac and/or Windows and one that I could change parameters on the fly. While not a perfect solution, it is a solution. Alternatively you can choose Turn on DEP for essential Windows programs and services.

I know this is an old thread and its Windows, but I thought I’d post these comments to pique anyones interest who may be interested in working with Crystal Reports and integrating it in with Xojo. Browse to the Program Files folder, find the executable file crw32.exe (for example C:Program Files (x86)Crystal DecisionsCrystal Reports 9), and then click Open.

Crystal report viewer for windows 8