Extensive mineral database containing crystallography, chemical composition, physical and optical properties, Dana classification, Strunz classification, mineral name. Crystal. Reports. Ninja A small Windows Console App that loads external Crystal Reports file, takes parameter inputs and export to various format or even print to printer. This is a complete rewritten based on Crystal Reports Exporter in order to enhance code readability and maintainability. Crystal Reports Ninja is an open source Windows Console program runs on. NET Framework 4. 5. It loads external Crystal Report file. Since it is a console command line app, it can be invoked by Task Scheduler, batch file. Web API or Web Applications. Directory structure. Deployment. CRfor. Crystal Report To Pdf New Window' title='Crystal Report To Pdf New Window' />
A widespread epidemic of Zika virus ZIKV infection was reported in 2015 in South and Central America and the Caribbean. A major concern associated with this. VSredistinstall3. Windows machineCRfor. VSredistinstall6. Windows machineCrystal. Reports. Ninja. exe Executable compiled by Visual Studio 2. NET Framework 4. 5Installation. Copy Crystal. Reports. Ninja. exe and install the right CRfor. VS runtime of your platform and it should work. How to use. Locate the folder of Crystal. Reports. Ninja. exe and run Crystal. Reports. Ninja The only mandatory argument is F, in which is for user to specify a Crystal Reports file. List of arguments F Crystal Reports filename to be loaded i. C Report SourceReport. O Crystal Reports Output filename i. C Reports OutputReport. Optional E Intended file format to be exported. If you wish to print Crystal Reports to a printer, simply E print instead of specifying file format. N Printer Name. If printer name is not specified, it looks for default printer in the computer. If network printer, N computer. C Number of copy to be printed any integer value i. S Server Name for server where data resides. Only one server per Crystal Reports is allowed. D Database Name. U Data source server login username. Do not specify username and password for Integrated Security connection. P Data source server login password. Do not specify username and password for Integrated Security connection. Pass Crystal Reports file parameter set on run time l Create a log file into Crystal. Reports. Ninja. exe directory F, Crystal Reports source file. This is the only mandatory must specify argument, it allows your to specify the Crystal Reports filename to be exported. O, Crystal Reports output file. If O is not specified, Crystal Reports Exporter will just export the Crystal Reports into the same directory when Crystal Reports source file is resided. The filename of the exported file is the same as Crystal Report source file and ending with timestamp yyyy. MMdd. HHmmss. E, Crystal Reports Export File Type. There are 1. 3 file formats that you can export a Crystal Reports file. Use E to specify desired file format. If E argument is not supplied, Crystal. Reports. Ninja will look into the output file extension. Adobe PDF format. If file extension cannot be mapped into supported file format, Crystal. Reports. Ninja will export your Crystal Reports into plain text file. File type. Descriptionstxt. Plain text filepdf. Adobe Portable Document format pdfdoc. Microsoft Word xls. Microsoft Excel xlsdata. Microsoft Excel with Data Onlyrtf. Rich Text formatertf. Editable Rich Text formattab. Tab delimited text file csv. Comma delimited text filecsv. Comma delimited text file xmlxml file htm. HTML file rpt. Crystal Reports file print. Print Crystal Report to a printer S, Server name or Data Source name. Most of the time, you need not specify the server name or data source name of your Crystal Reports file as every Crystal Reports file saves data source information during design time. Therefore, you only specify a server name when you want Crystal Reports to retrieve data from another data source that is different from what it is saved in Crystal Reports file during design time. If your crystal Reports data source is one of the ODBC DSN regardless of User DSN or System DSN, the DSN will be your Server Name S. D, Database name. Similarly to Server Name. Database Name is completely optional. You only specify a Database Name when you intend to retrieve data from another database that is different from default database name that is saved in Crystal Reports file. U and P, Username and Password to login to Data source. If you are using database like Microsoft SQL server, My. SQL or Oracle, you are most likely required to supply a username and password to login to database. If you are using trusted connection to your SQL server, you wouldnt need to supply username and password when you run Crystal. Reports. Ninja. If you are using a password protected Microsoft Access database, you need only to specify password and not username. Passing in Parameters of Crystal Reports. We can have as many Parameters as we want in one Crystal Reports file. When we refresh a report, it prompts user to input the value of parameter in runtime in order to produce the result that user wants. You can pass parameter value to Crystal. Reports. Ninja. exe when it is executed. Example 1. Lets take an example of a Crystal Reports file test. C root directory. The Crystal Reports file has two parameters, namely Supplier and Date Range. Crystal. Reports. Ninja U user. 1 P mypass S server. D Demo. F c test. O d test. pdf E pdf a Supplier Active Outdoors. Garage Door Opener Liftmaster Manual. Date Range 1. 2 0. Rule to pass parameters. Use double quote to enclose the parameter string parameter name and parameter value. A colon must be placed between parameter name and parameter value. Use comma, to separate start value and end value of a Range parameter. Use pipe to pass multiple values into the same parameter. Parameter name is case sensitiveExample 2. The following crystal Reports test. Training. rpt has 5 discrete parameters and 2 range parameters. Discrete parameters are Range parameters are Example of Single value parameters c Crystal. Reports. Ninja U user. P secret F C CreportStatement. O D OutputStatement. E pdf SAny. System DB. The One Computer,Inc a customer My. Books Store. a branch Malaysia a daterange 1. AFD0. 01,AFD0. 05. Example of Multiple values parameters c Crystal. Reports. Ninja F testreport. O test. Output. xls. E xlsdata S order. Client Ace Soft Inc,Best Computer IncXtreme Bike Inc,Zebra Design Inc. Example to print Crystal Reports output to printerc Crystal. Reports. Ninja F report. E print N HP Laser. Jet 1. 20. 0 C 3.