Skip to Content
0
Former Member
Jun 25, 2016 at 09:23 PM

Creating a report from a dynamically created table

34 Views

I have the following code:

Dim con As New SqlCeConnection

Dim cmd As New SqlCeCommand

con.ConnectionString = "Data Source=C:\VS 2012\Projects\Create Fields\Create Fields\TestDatabase.sdf"

con.Open()

cmd.Connection = con

cmd.CommandText = "Create table tblTabTest2 (ID bigint Identity, Companies bigint);"

cmd.ExecuteNonQuery()

con.Close()

This adds the table to the database, but how do I use tblTabTest2 to create a Crystal Report?

Thanks,

Ralph