Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. suman123

    Ado Sql Help

    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...
  2. suman123

    runtime report

    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...
  3. suman123

    help urgently

    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...
  4. suman123

    SQL server stored procedure date parameter & crystal report

    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...

Part and Inventory Search

Back
Top