search

rainforestnet / CrystalReportsNinja

A small Windows Console App that loads external Crystal Reports file, takes parameter inputs and export to various format or even print to printer
http://www.rainforestnet.com
93 stars 77 forks source link

how to execute crexport with sql script shell #52

Open harshitjain1 opened 4 years ago

harshitjain1 commented 4 years ago

using command EXEC master..xp_cmdshell

mhertzfeld commented 4 years ago

I have never tried running ninja with a sql script.

From what I am reading in the link below, it shouldn't be much different than calling through the normal command line. I would suggest getting it working through the command line then once you have a working command copy and paste it into you SQL script. Also, pay attention to the user account that will be executing the sql script and make sure that all the necessary permissions are granted.

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-cmdshell-transact-sql?view=sql-server-ver15

aj1432 commented 2 years ago

Please share example SQL Query Step by step