VBA Crystal 8.5 SQL temp Table

[lovalles]

Public rsBM As New ADODB.Recordset
Public SQL As String
Public conn As New ADODB.Connection

Private Sub Command1_Click()
conn.Open ("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=ClientUser;Initial Catalog=DATA_90;Data Source=SERVIDOR4&quot
SQL = "CREATE TABLE #t(x INT PRIMARY KEY) INSERT INTO #t VALUES (2) INSERT INTO #t VALUES (3)"
Set rsBM = conn.Execute(SQL)
End Sub

i have here created a temp table in SQL and added some values, now i want to generate a crystal report on vb based on this temp table. how can i do this?
when i create the table i know i have to specified some SPII or SPID in order to crystal to se the temp table.
Any help?

 

[synapsevampire]

Perhaps you can just create a recordset and pass the recordset to the report?

Have you read this?

http://support.crystaldecisions.com/library/kbase/articles/c2002390.asp

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[lovalles]

The thing is i make multiples recordsets and differente calculations so all this info i want to create a temp database and then generate the report from the temp database. i am actually workin but with a User table not a temp table. So if 2 users generate at the same time i have a problem so thats why i need the temp table.
Also i dont want to have that user table.

 

[lovalles]

In that case i how can i create a recorset in VB with a previus temp table create with the code i just type before?
anyone?

thanks