Without Database (All data from frontend in Arrays)

[Guest_imported]

I need to build a report without using any database.
I have a bulk data and has arrays in the front end.
I can either send arrays or a comma seperated string.

Also i dont know have fixed number of elements everytime i call it from the front end. So fields in the report are also dynamically created.

Any Solution???

 

[synapsevampire]

When you say you have strings or an array, how do you propose *sending* this?

If it's by selecting a report and passing data from a command line, you can't do that.

If you intend to call a report from within an application, then pursue the RDC or using one of the SDK's associated with Crystal deployment.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Ngolem]

Crystal needs a record set of some kind to work with. I am not experienced enough with VB to know if an ADO record set can be created from arrays themselves

BUT I DO KNOW THAT Crystal can read a comma delimited text file using an ODBC Text driver with no problem.

the first line of the text file contains the headers for the values that follows the next line contains the data that falls under each column

a simple example might be

data.txt

"Product","Quantity","Amount"
"Carrots",5,1.50
"Potatoes",100,2.69

You would show string nulls as "" as in:

"",2,1.30

You would show numeric nulls by just putting the 2 commas together as in:

"Beets",,2.50

Note there is no comma at the end of each row

once you create the file, select an ODBC text driver, I would put the file in the same folder as the report...Crystal uses this file as if it were a database. Jim Broadbent