cancel
Showing results for 
Search instead for 
Did you mean: 

Batch reporting with Excel to CR 2020

MarcFien
Discoverer
0 Kudos
102

I am new to crystal 2020 having previously used CR9 with VB6 many years ago. I am wondering if the following is possible. Right now we create RMA documents from a single rma number from our online database. We copy and past the # into the cr 2020 editor and it spits out a report from that number.  The questions I have are 1. Can we batch these reports by passing all the individual RMS #s in our list (could be 1, could be 5, or could be to 20 or any number) and have CR 2020 spit out all the reports at once? 2. Is there a way to connect to an excel document with the list of rma's and have CR 2020 batch all the reports in the connected database based on the list in Excel?  3.  Is there a way to automate all this form excel? That is to say, we have excel open, with a list of rma #s. We click a button, CR 2020 pops open batches the rma #s either through ODBC or though the api? and spits out our individual reports?

View Entire Topic
ido_millet
Active Contributor
0 Kudos

You can write your own application for doing this (not trivial).

An easier solution is to use a 3rd-party Crystal Report automation tools. Ken Hamady maintain a list of such tools here. Several of the tools on that list can handle your use case.

MarcFien
Discoverer
0 Kudos
Hi ido. I'm looking through these and I dont' see which one(s) meet my needs. I have a list generated in Excel of the ids that I need run then I need to pass that bulk to the report query and run it/save it then move on to the next one.