That table base on the user's selection .It has dynamic
Column.I write a Stored Procedure to generate the table.
and use "select * from #temp_table" return the
data to a recordset.
Dim adoRS As ADODB.Recordset
Dim cmd As ADODB.Command
Set cmd = New ADODB.Command
Set...
I said say " ...can't pass a recordset to a report, unless it was created based on a recordset. Usually that means using the Active Driver to create the report. "
I create a SP ,and make it return a recordset by
a temp table .(use "select * from #temptable")
the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.