HELP: Crystal Report

blackdevil1979

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!

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Adam Erstelle22y ago
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?
0
huber22y ago
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
0
blackdevil197922y ago
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.
0
tyrone.smith22y ago
Hi, Do you mind posting the solution to the problem as I am curious to see what it is? Thanks!
0
blackdevil197922y ago
Thanks, I have solve the problem, thanks.
0
Adam Erstelle22y ago
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.
0
blackdevil197922y ago
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?
0
Adam Erstelle22y ago
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.
0