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!

Adam Erstelle · Answer

The table should be permanent but emptied after each time used. I'm not familiar with the SQLOleDb but I have a feeling its the two ## that is giving the problem in your statement? If you made the table pomoc permanent perhaps that would help?

huber · Answer

I have problem with temporary table. When I try map temptable into CO I receive error: Table '##pomoc' could not be found. Can you help me? Code: Set CPProperties = DBTable.ConnectionProperties CPProperties.DeleteAll CPProperties.Add Provider SQLOLEDB CPProperties.Add Data Source XXX CPProperties.Add Initial catalog XXX CPProperties.Add User ID XXX CPProperties.Add Password XXX DBTable.Location = ##pomoc 'error

blackdevil1979 · Answer

I create a temporary table and use this table to map into crystal report. so when the program runs all i have to do is to insert the desired table into the temporary table.

tyrone.smith · Answer

Hi Do you mind posting the solution to the problem as I am curious to see what it is? Thanks!

blackdevil1979 · Answer

Thanks I have solve the problem thanks.

Adam Erstelle · Answer

1) I'm very sure you will have to insert by SQL statement to ensure the correct data type is inserted. 2) I use many reports in my app and do not use a datatable in any of them. I have the reports pull straight from the database. There may be a datatable created at run time by VS....but its not one that I specify. 3) I have tried to modify these fields but received nothing but run-time errors. I would like to know how to do this as well as it would reduce the number of Reports I have to deploy in my App but I am not counting on seeing a solution.

blackdevil1979 · Answer

Thank you for your reply. 1. SO if by string i have to insert using SQL statement addressing to the database table?? 2. Anyways lets say I still wish to use the temporary table. Is there a need for Datatable? Sorry I am a bit confused. The other day when I was playing with the CR (crystal report) designer I found like in VB they have objects called itextobject and iFieldObject. 3. Can the vb.net pass any value to this itextObject and iFieldObject? or any other objects in the crystal report? If this can be done can someone show a bit of an example?

Adam Erstelle · Answer

I do not belive you can dynamically create Crystal Report files at run time. You will have to create a seperate report file for each report you wish to produce. If you still wish to use the temporary table when you insert the data you will have to convert the inserted values into a string as you do the insert this is not done with crystal reports. However the column headers with remain static.