Ask Experts Questions for FREE Help !
Ask
    sejal_tank's Avatar
    sejal_tank Posts: 4, Reputation: 1
    New Member
    		  
    #1

    Mar 17, 2008, 08:22 AM
    crystal report and VB.
    Dim CN As New ADODB.Connection
    Dim rss As New Recordset
    Dim vcryapp New CRAXDDRT.Application
    Dim vrpt As New CRAXDDRT.Report

    cn = "ADO connection string with oledb provider for oracle,username,password etc"
    rss="select course_name,course_fees from course",cn

    set vrpt= vcryapp.OpenReport("E:\test\report2.rpt")

    vrpt.Database.SetDataSource rss
    [ it will give error like subscript out of range ]

    actully what will be the content of report2.rpt file. I want to select field dynamically not static. When I create a report with all fields of all then it will dispay total field I want to select any of them at per require.

    another problem I will add all field in report file but every time I run it from vb with placing CRViewer it will ask for connection i.e. connection dialog as we use for ado connection.

    when we are selecting field dynamically then what will be the content of report file.
    I'm using crystal report 8.5

    thanks in advance.

Check out some similar questions!

Crystal report with vb6 [ 1 Answers ]

I design a software with vb6, ms access 2000 and crystal report 8.5. but when I tried to make package through package & deployment wizards, it cannot make package and hangs. What's the problem? Anyone help me?

View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.