HELP: Crystal Report

Question

Hello, I have a few questions regarding crystal reports using VB.net. What is the best way to get your data into the crystal report? 1. Lets say that I might want to have a standard report layout... 2. and take 10 columns from any report that I want... (database table name is not fixed) 3. CAn the crystal report set by itself (the field objects) if i pass any tablename(from the database) to it? I have tried the "create a temporary table in the database" and trying to transfer data to that table but could not be done. I have problems with the datatype.... the columns created in the temporary tables are all set to text..whereas the table that I want to import from may have integer or date datatype. So the question: 4. how to change the datatype to allow the insert between the two tables? 5. if i have a table with 15 columns.. how to reduce it to10 columns by taking the first 10 columns only. This is because the column names might not be known to me most of the time.. Thanks. Hope someone can help me!