I have a crystal report based on Ado and SQL (select field1,field2 from table1).
In my VB program I am using RDC and creating ado recordset on the fly (ex select field1,field2 from table1 where field1=3) and passing this recordset to crystal report. Report does not show the new recordset. it...
Here is the code in VB that will bind the recordset field during run time. Create CRC designer called crUnboundReport with two unbound fields UnboundField1(number type) and UnboundString1 string type. Create two text boxes Text1 and Text2 that will hold the fieldnames in the unbound report...
Here is the code that will bind the sql during run time in VB
Dim rs As New ADODB.Recordset
Dim crReport1 As New crUnboundReport 'bind your own RDC
Dim cnn1 As New ADODB.Connection
Dim strCnn As String
sSQL = "Select * From Table1" 'put your own SQL statement
Set cnn1 = New...
I have a stored procedure (let's call testdate) that takes two dates as parameters and returns a result set. I want to have crystal report with this procedure testdate with parameters. And I want to call this report from my VB application passing the parameters from VB control. I am having...
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.