Running CrystalReportsNinja in Php

[abnertole]

Hi,

Thanks for sharing the tool. I have tried it and encountered the error below.

When I run in windows CMD, the crystal report is generated. But when I execute via Php exec(), I am getting the error below. Anything I missed out?

Exception: Unknown Database Connector Error Error in File OPRJ 9496_9704_{1CA7AD4F-AFE6-4FA9-8840-B945674BF453}.rpt: Unknown Database Connector Error Inner Exception: System.Runtime.InteropServices.COMException (0x800002C2): Unknown Database Connector Error Error in File OPRJ 9496_9704_{1CA7AD4F-AFE6-4FA9-8840-B945674BF453}.rpt: Unknown Database Connector Error at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

Thanks.

Abner

[rainforestnet]

@abnertole I have never tried to use php to run a .net executable before. I am not sure of that.
I did have a asp.net project that call this and it works.

[fmartiner]

@abnertole
Set the correct ORACLE_HOME and TNS_ADMIN path in environment variable before launch cmd of CrystalReportsNinja.exe from PHP
Example create a .bat file with:

SET ORACLE_HOME=C:...
SET TNS_ADMIN=C:...
CrystalReportsNinja.exe -F ...

and exec(file.bat)

This solve for me.

[mikecrf121]

@rainforestnet curious, how did you run this from another .net application?? did your app open a command line and then pass strings to the console, im considering doing something simular ??

[mharned73]

Opened from a exe statement is SQL Server Stored Procedure…. The command is passed as a string Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

…

________________________________ From: mikecrf121 <[email protected]> Sent: Thursday, August 29, 2019 6:52:49 AM To: rainforestnet/CrystalReportsNinja <[email protected]> Cc: Subscribed <[email protected]> Subject: Re: [rainforestnet/CrystalReportsNinja] Running CrystalReportsNinja in Php (#2) @rainforestnet<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Frainforestnet&data=02%7C01%7C%7C3365a096a66e46f93f8608d72c7fcc58%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637026799701597168&sdata=VgDtxa4VOdOOdNrN45TXCnR%2BA2Cl2LgDDGuTao3NdtE%3D&reserved=0> curious, how did you run this from another .net application?? did your app open a command line and then pass strings to the console, im considering doing something simular ?? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Frainforestnet%2FCrystalReportsNinja%2Fissues%2F2%3Femail_source%3Dnotifications%26email_token%3DAHU7HXOIP6WJXMXSJR4KT33QG7BCBA5CNFSM4DZFT67KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5OLWPQ%23issuecomment-526170942&data=02%7C01%7C%7C3365a096a66e46f93f8608d72c7fcc58%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637026799701607173&sdata=uesJnAkhI84BjktJ34zf03uPBV%2FOCUggyMfvh7UMQ8w%3D&reserved=0>, or mute the thread<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAHU7HXOGY235ETFB3DOREG3QG7BCBANCNFSM4DZFT67A&data=02%7C01%7C%7C3365a096a66e46f93f8608d72c7fcc58%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637026799701617190&sdata=xNBd9rp6YgNPTNMECtx6XK9eBmobJXwvycsI4%2FmSSr8%3D&reserved=0>.

[rainforestnet]

@mikecrf121 check this out
https://stackoverflow.com/questions/9679375/run-an-exe-from-c-sharp-code

[mikecrf121]

appreciate it thank you! what im trying to do is receive a json object, parse it with a node app and feed it to CRN. very useful library good job!

[mikecrf121]

@rainforestnet hey quick question, just now running into this issue, is this able to work with generating reports that contain sub reports?

Thanks!

[mharned73]

Yes.... from the point of executing runtime it is just crystal reports Get Outlook for Android<https://aka.ms/ghei36>

…

________________________________ From: mikecrf121 <[email protected]> Sent: Wednesday, September 4, 2019 6:22:42 AM To: rainforestnet/CrystalReportsNinja <[email protected]> Cc: mharned73 <[email protected]>; Comment <[email protected]> Subject: Re: [rainforestnet/CrystalReportsNinja] Running CrystalReportsNinja in Php (#2) @rainforestnet<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Frainforestnet&data=02%7C01%7C%7C7c726bdd914f4f154d0008d7313295c4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637031965631478143&sdata=JN%2FfYwmX5uGqimTIEIl%2FCrFga2VxZ4dtvP%2BTbsPT0JI%3D&reserved=0> hey quick question, just now running into this issue, is this able to work with generating reports that contain sub reports? Thanks! — You are receiving this because you commented. Reply to this email directly, view it on GitHub<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Frainforestnet%2FCrystalReportsNinja%2Fissues%2F2%3Femail_source%3Dnotifications%26email_token%3DAHU7HXISMB2KGJHJHLLCLBTQH6SBFA5CNFSM4DZFT67KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD53MDPY%23issuecomment-527876543&data=02%7C01%7C%7C7c726bdd914f4f154d0008d7313295c4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637031965631488154&sdata=ypvt%2FhQEUlRdgTucW0QbussNz3aMtJp66eld1FsKoDI%3D&reserved=0>, or mute the thread<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAHU7HXMUQXLYEHYHVMYX5GTQH6SBFANCNFSM4DZFT67A&data=02%7C01%7C%7C7c726bdd914f4f154d0008d7313295c4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637031965631498159&sdata=zJoglxzQdFOV%2FlZEw1dkSNH8tDssiSsRCxIMJ04%2F4Jo%3D&reserved=0>.

[aj1432]

hello team Please Explain Step by Step Please
I do not understand Command.

please check attachment, I got error

[mikecrf121]

@aj1432
What do you mean you don't understand command? Like you can't run CRN at all or you don't understand the parameters? I haven't worked with CRN in years... but this is an amazing amazing program, especially to save money if your facing the same problem my company did at the time. You need to compile it first, what are you using to do that?? If you dont know what im talking about or how to even do that to make code changes if needed then id suggest hiring someone who knows what they are doing, like me haha. Your also trying to run ,from your screen shot the first time with no required param "-F"... If you want I can show you on a one on one with a zoom call? I may charge you to refresh myself though. What are you trying to use crystal report ninja to do? I remember when I did it for the company I was working for a few years ago, we built a custom angular app, with a node backend that executed CRN from the node app and returned the generated crystal reports to AWS S3, and we utilized sqs, sns, lambdas, etc... but anyways we built this app to avoid ridiculous licensing costs associated with generating crystal reports from some program, it was like a per user cost that our company was trying to save money by avoiding the high costs of multiple licenses. I'm also able to build out an app for you if your hiring or interested in contracting me. Can be part time or for a few hours, depending on your needs. Thanks and good luck.