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

  • Question

  • User2074777333 posted


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


    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 
    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"
       end case

    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#


    Thursday, July 17, 2014 1:17 AM