report from run time generated data table

[lhuang2]

Help Please!!!!!!!!!!

My data table will be generated through ADO.net according to user selection. So the fields of the table can not be known untill table is generated at run time.

I cannot specify data fields for data extraction at design time.

How do I generate a report of data from this table at run time?

I am using Crystal report V10 in VS.net 2003.

 

[Turkbear]

Hi,
I'm not sure you can...How can you ask a report to retreive
some or all fields in a table if the fields are not specified.
What are you going to place on your report?

You may be able to write code that will read the field names after the code creates them ( assuming it names them somehow) and pass that info to the report object creation stage ( Maybe...)

 

[lhuang2]

I think so too.

How do I write code behind to pass the field names to the report. I probaly can use CrystalReport Engine, but not sure how, can anyone advice please.

I think also if I can use command like: SELECT * from tablename to get all the data from it without speicifying the fields name. Will that work?

 

[Turkbear]

HI,
The select probably will work, but how will you then specify which fields to have on the report?

 

[lhuang2]

I dont know. That is the real problem.

Do you have any idea where I can find help on that?