locked
Is it possible to make a crystal report using csv file RRS feed

  • Question

  • User2074777333 posted

    Hi,

    Can anybody tell me please if it is possible to make a crystal report in asp.net using the data from a csv file?

    Thanks

    Sunday, July 13, 2014 3:51 PM

All replies

  • User-1353043493 posted
    Design the report based on CSV column.
    
    Read the csv file
    
    Dim txtConn as New OleDb.OleDbConnection 
    txtConn.ConnectionString = "Provider=miscrosoft.jet.oledb.4.0;Data Source=Directory Name;Extended Properties=Text;" 
     
    Dim txtCmd as New OleDb.OleDbCommand 
    txtCmd.Connection = txtConn 
    txtCmd.CommandText = "SELECT * FROM [filename.csv];" 
     
    Dim txtAdpt as New OleDb.OleDbDataAdpater 
    txtAdpt.SelectCommand = txtCmd 
     
    Dim ds as New Dataset 
    txtAdpt.Fill(ds) 
    
    and pass the datasoure to crystal report
    
    dim crp_MyReport= new crp_ReportTest
    Dim frm_Viewer=new frm_ViewerTest
    If u want to pass parameter
    dim parameter system.crystaldecision.shared.parameter
    dim parameters system.crystaldecision.shared.parameters
    dim parameters=crp_myreport.parameters
    for each parameter in parameters
      select .parameterfieldname
           case "parametername1"
              .currentvalue.addvalue(value)
       end case
    next
    frm_viewer.crv_viewer.refresh()
    frm_viewer.crv_viewer.reportsource=crp_Myreport
    frm_viewer.show()

    Monday, July 14, 2014 12:27 AM
  • User2074777333 posted

    Thank you Dharmesh, I have seen exactly the same site and example, but I need a code in c#, not In vb. However I will try this as well, trying to make it in c#

    Monday, July 14, 2014 8:11 AM
  • User-1353043493 posted

    please use this converter for convert vb to C#

    http://converter.telerik.com/

    Thursday, July 17, 2014 1:17 AM