Display in Crystal Report

Hi
Can you Tell me how to Use Crystal Report 6.0 for displaying an Array of data Genrated by VB at runtime.
Is it possible or not?

[Vlad Chapranov]

What about this scenario?
Create a table in a database with structure wich can hold estimated (from VB) data, create report using that table. At runtime in VB delete that table, create a new one with exact the same structure and name and fill that table with data from your array. Everything can be done with DAO, ADO or somehow else. Run your report. That's it.
Vlad Chapranov, MCP

Hi,
Thanks a lot.
Can you tell me any different way for displaying the array.
Suppose the tables are in Oracle 8 server and One of the table has huge amount of data ,say 70,000 rows. Then there will be a lot of network traffic.
What about VB Report Writer ? is it possible with it !
Bye,

[Vlad Chapranov]

If you are using data from your huge table to put them in an array and after that that data goes to new table it's a bad way. Use that data directly. If you produce a data in VB why you are talking about huge table? I'm sorry, but I do not understand what you want to display in CR. I've never worked with Report Writer, so I cannot tell you anything about this tool. I believe that all tools are similar.
Vlad

Hi
Actually I am asking for some conditional situaltions. I am going to generate A cashflow statement for my client ,then array will have the calculated statement depending on the data on the database .So I want print the Array into a report. Ok, I communicate with Oracle 8 through ADO 2.1 .
If you about any other report writer,can give me some solution in such situation.
Bye

[Vlad Chapranov]

You are performing some selection of data to use in your calculation on the server. Right? Retrieve all data you need, make some calculations or whatever, save it in a new table and run report using that table as a source for report. Where do you expect any traffic? I know nothing about Oracle, but I beleive it's great DB and allows to use it in client-server approach. If so you do not need to retreive all data to the client machine to make any manipulations. If temporary table is going to be huge in size I don't think you need to create report without any selection, otherwise who will read thousands of pages. I'm working sometimes with Crystal only and never worked with any other reporting tool.
Vlad