Exception: Fehler in der Datei Bericht1 10828_8852_{3FA216C5-228E-41C1-AC1E-D3BECFBA20B2}.rpt:
Fehler beim Laden der Datenbankinformationen
Inner Exception: System.Runtime.InteropServices.COMException (0x800002CD): Fehler in der Datei Bericht1 10828_8852_{3FA216C5-228E-41C1-AC1E-D3BECFBA20B2}.rpt:
Fehler beim Laden der Datenbankinformationen
bei CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
bei CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

Any help

First try

25-08-2022 16:58:04 Report loaded successfully
25-08-2022 16:58:04 Output Filename : test.pdf
25-08-2022 16:58:04 Output format : pdf
25-08-2022 16:58:04 Exception: Database logon failed.
25-08-2022 16:58:04 Inner Exception: System.Runtime.InteropServices.COMException (0x8004100F): Database logon failed.
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

second try

25-08-2022 18:09:34 ================== LoadReport, Output File and DB logion ===========
25-08-2022 18:09:34 Report news.rpt loaded successfully
25-08-2022 18:09:34 Output Filename : test.pdf
25-08-2022 18:09:34 Output Format : pdf
25-08-2022 18:09:34 Logging into SQLDBNAME Database on SQLSERVERNAME with User id: REPORTUSERNAME with Integrated Security = False
25-08-2022 18:09:34
25-08-2022 18:09:34 ================== ProcessParameters ===============================
25-08-2022 18:09:34 Number of Parameters detected in the report = 0
25-08-2022 18:09:34
25-08-2022 18:09:34 ================== STEP = PerformOutput ============================
25-08-2022 18:09:34
25-08-2022 18:09:34 ===================Logs and Errors =================================
25-08-2022 18:09:34 Message: Failed to open the connection.
news 12900_5760_{57B50DE2-FB79-4D16-B43C-F47FE03B5111}.rpt
25-08-2022 18:09:34 HResult: -2147221760
25-08-2022 18:09:34 Data: System.Collections.ListDictionaryInternal
25-08-2022 18:09:34 Inner Exception: System.Runtime.InteropServices.COMException (0x800002F4): Failed to open the connection.
news 12900_5760_{57B50DE2-FB79-4D16-B43C-F47FE03B5111}.rpt
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
25-08-2022 18:09:34 StackTrace: at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
at CrystalReportsNinja.ReportProcessor.PerformOutput()
at CrystalReportsNinja.ReportProcessor.Run()
25-08-2022 18:09:34 ====================================================================

when I try to run with 32bit OS the report is working successfully, but try to run with 64Bit OS, the following error occurred Exception: Database logon failed...................., similarly I cannot deploy on remotely window server 2019 64Bit OS, same problem facing.... here try to connect with MYSQL database
my parameters in Command Line are:
D:\Web\xampp\htdocs\cr>CrystalReportsNinja -U"dw01_wit" -P"_khan&&bro" -F news.rpt -S"localhost" -D"dw01_wifaq" -O test.pdf -E pdf
OR
also try as given below
D:\Web\xampp\htdocs\cr>CrystalReportsNinja.exe -U dw01_wit -P password -F news.rpt -S localhost -D dw01_wifaq -O test.pdf -E pdf

I try to connect with mysql database through ODBC 32bit drivers .......

When I try to run simple report without adding any table into the report ..... it connected successfully.
parameters in Command Line are:
CrystalReportsNinja -F r6.rpt -O test.pdf -E pdf
Report loaded successfully
Database Login done
Completed

ninja-20220825165802.log

any one can help me, to solve this problem how connect with CrystalReportsNinja, with credentials parameters , adding tables into the report through MYSQL odbc deriver.. ?

This is a known issue already:

https://apps.support.sap.com/sap/support/knowledge/public/en/1817212

How can this issue be remedied with this incredible tool? How can I programmatically "check the box" to "Isolate Report/Page sections"

We are in the process of migrating to the cloud, new servers etc
I don't want to modify all the existing reports and update SQL Driver - SQL Server Native Client 10.0 and new server is 11.0
I have tested without modifying the report and it fails login, even though it feeds back the correct info.
If I update the DB details in the report it works ok.

Need to be able to change the setting on Runtime.

I have updated the CRExport code to respond with the ACTUAL log on info, rather then what is set in the Parameters
I moved the "_logger.Write..." line into the Loop and changed the returned values to the variable being set.
It now returns the INTERNAL Report DB info if no parameters supplied, or the set info if supplied, see attached snip!
PerformDBLogin .txt

Been working on the code you have released in this branch as its the closest to whet we need.
However Printing is only ever printig to the default printer

CrystalReportsNinja.exe -LC -S SERVER -U USER -P PASS-D Database-E print -N test -F report.rpt " -a Year:2019 -a Month:09 "

Output is Report printed to : (BLANK) and prints to the default printer.

Been working on the code you have released in this branch as its the closest to whet we need.
However Printing is only ever printig to the default printer

CrystalReportsNinja.exe -LC -S SERVER -U USER -P PASS-D Database-E print -N test -F report.rpt " -a Year:2019 -a Month:09 "

Output is Report printed to : (BLANK) and prints to the default printer.

Hi !! how can I compile or get the .exe file? thanks a lot!!

I think it would be good if an external XML file be used for the default parameters
That way a default could be set for each environment i.e DB Server, DB, UN, PW, Mail settings etc

End result could be a command line to run the script to be easy and short
i.e. export.exe -M -MT [email protected] -E PDF -O "TestOut.PDF" -F "Test.rpt" " -a par1:10 -a par2:2019 -a par3:09 "
which would send email with PDF attachment to specific person, or printer etc

This would mean you wouldn't have to have to set all the basics for every script
wouldn't have to store your password etc and several batch files etc

My setup is as follows:

I have CRN running on my main server, I use this to run reports from both my main server (SQL) and a secondary server (MySQL). Both servers work fine when the reports are run directly from the command line.

The application, calls CRN from PHP, exports the report, and then returns the exported report to the user. This works fine for my Primary Server, however, I get an error when doing this for the ODBC connection (MySQL).

Error / Log is as follows:
[0] => Report loaded successfully
[1] => Database Login done
[2] => Exception: Failed to open the connection. Failed to open the connection.
[3] => invoice 10792_7268_{E38FD6C4-0736-4785-A8B7-347E4D13105A}.rpt
[4] => Inner Exception: System.Runtime.InteropServices.COMException (0x800002F4): Failed to open the connection. Failed to open the connection.
[5] => invoice 10792_7268_{E38FD6C4-0736-4785-A8B7-347E4D13105A}.rpt
[6] => at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
[7] => at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) )

An empty .tmp file is written to C:/Windows/Temp, without any content. It looks to me like a permissions issue that the 'user' which executes the PHP script, doesn't have the correct permissions somewhere - I've opened Temp up to everyone temporarily, but without any joy.

Can someone advise where CRN needs permissions to write to? Or if they've come across the same issue and can advise?

Thanks,

I am wondering (and perhaps this could go into some kind of FAQ in the readme file, does this application create one connection to your database server or does it create a one for each table or one for each sub report) I ask because I used crystal decisions recently and it created a bunch of connections to the database.

When I attempt to call the application from Powershell I get a Database Logon failed exception, System.Runtime.InteropServices.COMException (0x8004100F). I'm trying to run the report from Powershell as if from the command line; I'm providing the path to the .exe and .rpt, providing a parameter then running:
& $crystalNinjaPath @('-F', $RPT, '-O', $reportOutput, '-A', "RunDate:$dateParam", '-LC')

The only time this works is when I first open the report in Crystal and run it with the same day parameter that will be used in PowerShell with the Save Data with Report toggled on, and run the PowerShell script. Otherwise, it fails, giving the exception mentioned above, when I don't have the Save Data with Report toggled, or if I previously ran it in Crystal with a different day chosen as a parameter. I have tried passing credentials in the script and specifying the server and database and every permutation, but it seems to not be reading or using them.
I am using the 32-bit .exe with the 32-bit runtime installed version 13.0.25, and using a 32-bit ODBC to connect to an Oracle database.

Change logging so that the user can configure the file path and file name where the log should be written.

Crystal Reports Ninja works with Hana database?
I'm having mistakes. Apparently it doesn't connect to the database. Any suggestion?

Thank's

Error:

Exception: Referência de objeto não definida para uma instância de um objeto.

ninja-20210816142228.log

I have run into the same issue on both your fork and the original project. I am trying to print use this app to print some old crystal reports. I have tested on two development environment and neither have worked. I am getting the following error:

===================Logs and Errors =================================
16-08-2021 14:22:29 Message: Error in File Statement 6348_25456_{944C4770-1299-4A96-81B8-22BBBF56031F}.rpt:
Failed to load database information.
16-08-2021 14:22:29 HResult: -2147215616
16-08-2021 14:22:29 Data: System.Collections.ListDictionaryInternal
16-08-2021 14:22:29 Inner Exception: System.Runtime.InteropServices.COMException (0x800002CD): Error in File Statement 6348_25456_{944C4770-1299-4A96-81B8-22BBBF56031F}.rpt:
Failed to load database information.
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
16-08-2021 14:22:29 StackTrace: at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
at CrystalReportsNinja.ReportProcessor.PerformOutput() in D:\Development\Crystal Exporters\CrystalReportsNinja-master\Source\CrystalReportsNinja\ReportProcessor.cs:line 340
at CrystalReportsNinja.ReportProcessor.Run() in D:\Development\Crystal Exporters\CrystalReportsNinja-master\Source\CrystalReportsNinja\ReportProcessor.cs:line 415
16-08-2021 14:22:29 ====================================================================
Exception: Error in File Statement 6348_25456_{944C4770-1299-4A96-81B8-22BBBF56031F}.rpt:
Failed to load database information.
Inner Exception: System.Runtime.InteropServices.COMException (0x800002CD): Error in File Statement 6348_25456_{944C4770-1299-4A96-81B8-22BBBF56031F}.rpt:
Failed to load database information.
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

Crystal reports version is version 7 though I have tried with 11 as well
DB is a dataflex database. We use the crystal reports dataflex connectivity kit.
Do you have any idea what might be causing the issue?

Hello,
The reader of my state works as well as the connection to the database Oracle. I change the password or the user and I have a connection error.
I do tests with or without parameters and by modifying my printing state and in any case no data is read in the Oracle database.
Thank you for your help, cordially.

Is it possible With a SQL Server connection to either use the -S option and change the ODBC DSN at runtime or use the -D and use a different database at runtime? I need to run the same crystal report against different databases. (They all have the same structure). It seems no matter what I do, it uses what is defined in the Crystal Report. Any ideas how to make this work?

Tried your solution. Installed Crystal Runtime 32 bit build 13.0.22 and your 32 bit version of the Ninja App. Sadly, it did not work. Got an exception: Object Reference not set to an instance of an object. Any idea what would cause this? Running Windows 10 64 bit

How do you use an ODBC connection in the command line call?
I've tried: CrystalReportsNinja -U username -P password -S ODBC.

When the the script runs, it comes back with Database logon failed.

Hello guys,
When I passed multiple parameters to a report following the format I put in the documentation
Method A:
"C:\Users\itcon2\workspaceRadius\******\war\pdf\CrystalNinja\CrystalReportsNinja.exe" -F "C:\Users\itcon2\workspaceRadius\******\war\pdf\Quote-Standard.rpt" -E pdf -O "C:\Users\itcon2\workspaceRadius\******\war\pdf\S03668401.pdf" -a "compnum:10" -a "Estimate:S036684/01" -a "Version:(1)|(2)|(3)|(4)|(5)|(6)|(7)|(8)|(9)|(10)|(11)|(12)|(13)|(14)|(15)|(16)|(17)|(18)|(19)|(20)|(21)|(22)|(23)|(24)|(25)|(26)|(27)|(28)|(29)|(30)|(33)|(35)|(36)|(37)|(38)|(48)"

Method B
However when I ran it this way it worked. Can someone confirm method B is the correct way to run this? How would I handle text parameters? I'd be happy to update the readme.md following confirmation
"C:\Users\itcon2\workspaceRadius\******\war\pdf\CrystalNinja\CrystalReportsNinja.exe" -F "C:\Users\itcon2\workspaceRadius\******\war\pdf\Quote-Standard.rpt" -E pdf -O "C:\Users\itcon2\workspaceRadius\******\war\pdf\S03668401.pdf" -a "compnum:10" -a "Estimate:S036684/01" -a "Version:1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|33|35|36|37|38|48"

To make it a bit more dynamic and secure, would it be possible to pull data from formulas from the crystal reports itself? Have you looked at bursting capabilities? This means you generate a separate file for each Group level 1.

I have a crystal report that runs a stored procedure. When running the report through CR 2008 (v.12.0.0.683) the each parameter prompt has the option for "Set to Null". However, when I leave out the value when passing parameters to Crystal Reports Ninja, it returns the error:

Message: Length cannot be less than zero.
Parameter name: length
HResult: -2146233086
Data: System.Collections.ListDictionaryInternal
Inner Exception:
StackTrace:    at System.String.Substring(Int32startIndex, Int32 length)
   at CrystalReportsNinja.ParameterCore.ProcessRawParameters()
   at CrystalReportsNinja.ReportProcessor.ProcessParameters()
   at CrystalReportsNinja.ReportProcessor.Run()

Additional information: Database is SQL Anywhere v16 and the parameters are type LONG VARCHAR DEFAULT NULL. An empty string '' value is treated differently than value NULL passed to the stored procedure. For example, calling myProc('','','') will return a database error, however, when 'Set to Null' is checked in Crystal Reports it calls using myProc(NULL,NULL,NULL) and that works.

Is there anyway to pass null values to the required parameters?

Receiving error "Exception: Invalid Crystal Reports File Inner Exception:"

-F Reports\OR Surgery Schedule_Tomorrow.rpt

Windows Server 2012 R2
.NET 4.8
Crystal Reports runtime engine .NET 13.0.5

Crystal report path and name is correct. This is working on one of our legacy systems.

Add the ability to specify file path for log.

rainforestnet#28

Hi,
Im running into a lot of missing parameters error when trying to run and execute these reports, is their any way we can get a log of which params are missing? that would help ALOT

Invoked with the following cmd call
CrystalReportsNinja.exe -U user1 -P password -S server -F C:\CrystalReportsNinja\64-bit \test.rpt -O C:\CrystalReportsNinja\64-bit\test1.pdf -E pdf -a "filter_id:80742"

producing the following log
ninja-20200204171133.log

Using SAP Runtime 64 bit build v13.0.26.3348

Hi,
i use CrystalReportsNinja v1.8.0.0.x64 on my pc, and i have some problems to use the reports with subreports; if i don't link the subreport with main reports CrystalReportsNinja reads and exports correctly the pdf, but when i set the parameters for link the subreport with main report CrystalReportsNinja return me Error 0x800002C3.
Can you help me to understand where i mistake ?

P.S
reports work correctly in Crystal Report XI

attached are the logs of the two cases I have described:
ninja-20210113163409_Success.log
ninja-20210113164310_Error.log

When I clone and download the application I get the following error . Each time I've had to comment out these lines. I pulled all of the CrystalDecisions references. Is there something else I am missing?

Severity Code Description Project File Line Suppression State Error CS1061 'PrintOptions' does not contain a definition for 'NoPrinter' and no accessible extension method 'NoPrinter' accepting a first argument of type 'PrintOptions' could be found (are you missing a using directive or an assembly reference?) CrystalReportsNinja C:\Users\itcon2\Documents\vandatatickets\1613\matthertfeld\1.9latest\CrystalReportsNinja\Source\CrystalReportsNinja\ReportProcessor.cs 226 Active

The build error occurs on line 226, 233, and 243 of ReportProcessor. this is out of version 1.9

I have a report that works fine if a value is set to be a single value. However, I change the value to a Multivalue, CR Ninja gives an error. I tried installing 1.0.7 and the error is still there.

First, the command I am trying to use: C:\CrystalReportNinja\CrystalReportsNinja.exe -U <user> -P <pw> -S <server> -F V:\HCCLibraryLoad.rpt -a "Term:20204|20203" -O W:\LibraryUserlist\LibraryUser-<date> -E tab

This is the error I am getting (Also looks like you have a typo below?: DB logion):
04-09-2020 16:01:36 04-09-2020 16:01:36 ================== LoadReport, Output File and DB logion =========== 04-09-2020 16:01:37 Report HCCLibraryLoad.rpt loaded successfully 04-09-2020 16:01:37 Output Filename : W:\LibraryUserlist\HCCLibrary-20200904.txt 04-09-2020 16:01:37 Output Format : tab 04-09-2020 16:01:40 Logged into Database on <SERVER> successfully with User id: <USERID> 04-09-2020 16:01:40 04-09-2020 16:01:40 ================== ProcessParameters =============================== 04-09-2020 16:01:40 Number of Parameters detected in the report = 1 04-09-2020 16:01:40 Number of Parameters passed by the users script = 1 04-09-2020 16:01:40 04-09-2020 16:01:40 Applied Parameter 'Term' as MultiValue 'True' 04-09-2020 16:01:40 Discrete Parameter : Term = 20203 04-09-2020 16:01:40 Multiple Value Parameter - Prompt = Please select a term - Term = 20203|20204 04-09-2020 16:01:40 Discrete Parameter : Term = 20204 04-09-2020 16:01:40 Multiple Value Parameter - Prompt = Please select a term - Term = 20203|20204 04-09-2020 16:01:40 04-09-2020 16:01:40 04-09-2020 16:01:40 ================== STEP = PerformOutput ============================ 04-09-2020 16:01:41 04-09-2020 16:01:41 ===================Logs and Errors ================================= 04-09-2020 16:01:41 Message: Failed to open the connection. HCCLibraryLoad 10660_5060_{CBEBB704-741C-442B-A692-10AC6E7764AA}.rpt 04-09-2020 16:01:41 HResult: -2147221760 04-09-2020 16:01:41 Data: System.Collections.ListDictionaryInternal 04-09-2020 16:01:41 Inner Exception: System.Runtime.InteropServices.COMException (0x800002F4): Failed to open the connection. HCCLibraryLoad 10660_5060_{CBEBB704-741C-442B-A692-10AC6E7764AA}.rpt at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) 04-09-2020 16:01:41 StackTrace: at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export() at CrystalReportsNinja.ReportProcessor.PerformOutput() at CrystalReportsNinja.ReportProcessor.Run() 04-09-2020 16:01:41 ====================================================================
I have unchecked the option to save data with report.
Let me know if you need more information.
Thanks!

Hi there,

I've been banging my head on the wall trying to figure this out. Below is the log for a very simple output job. Authentication works fine, it sees the report, I elected no output select (so it defaults to text). I've verified the report runs in the studio environment without error. I'm at a loss as to what's going on. Anything you could do to help would be amazing!

Running Crystal Runtime 13.0.27 64-bit on Windows 10 64-bit.

--

04-08-2020 16:13:28 ===================Logs and Errors =================================
04-08-2020 16:13:28 Message: Object reference not set to an instance of an object.
04-08-2020 16:13:28 HResult: -2147467261
04-08-2020 16:13:28 Data: System.Collections.ListDictionaryInternal
04-08-2020 16:13:28 Inner Exception:
04-08-2020 16:13:28 StackTrace: at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
at CrystalReportsNinja.ReportProcessor.PerformOutput()
at CrystalReportsNinja.ReportProcessor.Run()
04-08-2020 16:13:28 ====================================================================

Issue from @fabian-sta on the commit below.

c166eaa#commitcomment-35657528

Without this fix i get this error:
25-10-2019 11:40:22 Exception: Error in File Reportname 5288_13804_{C0ED7AED-FD83-487A-82B3-F79C18719535}.rpt:
Operation illegal on linked parameter.
25-10-2019 11:40:22 Inner Exception: System.Runtime.InteropServices.COMException (0x80000290): Error in File Reportname 5288_13804_{C0ED7AED-FD83-487A-82B3-F79C18719535}.rpt:
Operation illegal on linked parameter.
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
Exception: Error in File Reportname 5288_13804_{C0ED7AED-FD83-487A-82B3-F79C18719535}.rpt:
Operation illegal on linked parameter.
Inner Exception: System.Runtime.InteropServices.COMException (0x80000290): Error in File Reportname 5288_13804_{C0ED7AED-FD83-487A-82B3-F79C18719535}.rpt:
Operation illegal on linked parameter.
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

If i apply this fix i get error:
25-10-2019 11:39:12 Exception: Not enough memory for operation.
25-10-2019 11:39:12 Inner Exception:
Exception: Not enough memory for operation.
Inner Exception:

Hi. Is it possible to refresh the data before exporting? RPTs which parameters are programmatically set (needs refresh in crystal report viewers) are yielding outdated data when ran with CrystalReportNinja. Any thoughts about this highly appreciated.

I have been trying for days to get this to work and I finally made some progress today. There is something I am missing to make this work as expected though. I have Crystal Reports 2016 (v14.2) running on the development computer and running crystalreportsninja on a different computer.
As for the details:
Downloaded CrystalReportsNinja v1.8.0.0
Downloaded "SAP Crystal Reports for Visual Studio (SP28) runtime (32-bit)" from the first link you provided in the PreRequisites.

The problem:
I have simple report that when I enter a serial number (as shown in cmd line below) that it will grab a model number from the database (using pgAdmin with an ODBC connection). Everything works fine in the Crystal reports software. When I run the command line statement:

"C:\Crystal Reports\downloads\CRN v1.8.0.0.x86\CrystalReportsNinja.exe" -F "C:\Crystal Reports\downloads\CRN v1.8.0.0.x86\Print Trial.rpt" -O "C:\Crystal Reports\Output\test4.pdf" -E pdf -a "serial_number:20090246" -l

I get a failed to open connection message. This only happens when I try and change the serial number. I have tried this multiple different ways.
(1) The report (.rpt file) has a checkbox that says "Save Data with Report". When I do this as long as I enter the serial number that was saved it works fine and creates the report. When I change the serial number, I get the "failed to open the connection" message.
(2) I have tried having the report in its own folder and tried it in the same folder as the CrystalReportsNinja.exe file with identical results.
(3) I have unchecked the "Save Data with Report" and saved a new version of the .rpt file and every time I run the command I get the failed to open connection message.
(4) Added the database name, user and password to the command line prompt. That also fails to open connection.

If there is anything that you can suggest changing on my end or something that I may have done incorrectly please let me know. I have included the log file from one that fails.

ninja-20200914154507.log

I have the following problem. I will describe what worked and what didn't.
If it matters, the crystal reports connect to a Progress OpenEdge Database.
The reports by themselves in the application SAP Crystal Reports 2016 natively works just fine.
I have organized the error I am facing in the following spreadsheet.
the main error message is as follows:
`

08-04-2021 07:14:55 Message: Failed to retrieve data from the database.

Error in File Invoice 5276_11324_{E0F1808B-40FA-41B2-87B2-535B32E0849D}.rpt:
Failed to retrieve data from the database.
Details: [Database Vendor Code: -210083 ]
08-04-2021 07:14:55 HResult: -2147221760
08-04-2021 07:14:55 Data: System.Collections.ListDictionaryInternal
08-04-2021 07:14:55 Inner Exception: System.Runtime.InteropServices.COMException (0x800002D3): Failed to retrieve data from the database.

`

https://drive.google.com/file/d/19VptgfVy83J65tdPfuEd7T9IriQwq-nD/view?usp=sharing

Add functionality so that users can use a file for parameters.

rainforestnet#26