locked
Crystal Report With Dataset RRS feed

  • Question

  • User1109811461 posted

    hi all expertise

    currently i develop a report by using crystal report and dataset , what happen is that when i want to open the report  it appear varification they as me :

    The report you requested requires further information.

    then i need to put some information such as:

    such as server name, database name, user name and pasword,

    why this happen...? i really don't  have ideas why this occurs

    i also have other dataset and other crytal report in same project but not facing this problem

    need help regarding this from expertise hereCry

     

    Monday, December 17, 2012 2:46 AM

Answers

All replies

  • User614805505 posted

    Hi,

    Which data source that you are using at Crystal Report?

    Monday, December 17, 2012 4:09 AM
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, December 17, 2012 4:09 AM
  • User1109811461 posted

    hi gregaDro

    i need guidance from you regading this information, will try first

     

    Monday, December 17, 2012 11:49 PM
  • User1109811461 posted

    hi gregaDro,

    i still got the prompt any ideas..? below is my full code:

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    
    
            Dim connectionInfo = New CrystalDecisions.Shared.ConnectionInfo()
            connectionInfo.ServerName = "hacker"
            connectionInfo.DatabaseName = "Pelajar"
            connectionInfo.Password = "pokoksena"
            connectionInfo.UserID = "hacker\far"
            connectionInfo.Type = ConnectionInfoType.SQL
            connectionInfo.IntegratedSecurity = False
    
            For i As Integer = 0 To CrystalReportSenaraiMeritAll.LogOnInfo.Count - 1
                CrystalReportSenaraiMeritAll.LogOnInfo(i).ConnectionInfo = connectionInfo
            Next
    
            Dim rptDoc As New ReportDocument
    
            Dim getSessionKategoriMerit As Object
            Dim getSessionSubKategoriMerit As Object
    
            Dim getStartDateM As Object = Session("tarikhMulaM")
            Dim getEndDateM As Object = Session("tarikhTamatM")
    
            getSessionKategoriMerit = Session("drpMerit")
            getSessionSubKategoriMerit = Session("drpSubMerit")
    
    
            Dim ds As New MaklumatPelajar
            Dim mySQLConnection = New SqlConnection()
            Dim dt As New DataTable
            dt.TableName = "Senarai Merit All"
    
            mySQLConnection.ConnectionString = ConfigurationManager.ConnectionStrings("default").ConnectionString
    
    
            Dim strsql As String = "SELECT MaklumatPelajar.Nama, MaklumatPelajar.NoIc, MataMerit.JenisMerit, MataMerit.SubMerit, convert(varchar(10),MataMerit.TarikhMerit,103) as TarikhMerit, MataMerit.PengaduMerit" & _
                                   " FROM MaklumatPelajar INNER JOIN MataMerit ON MaklumatPelajar.IdPelajar = MataMerit.IdPelajar" & _
                                   " WHERE MataMerit.JenisMerit = '" & getSessionKategoriMerit & "' AND MataMerit.SubMerit = '" & getSessionSubKategoriMerit & "' AND MataMerit.TarikhMerit between convert(datetime, '" + getStartDateM + "',103) AND convert(datetime,'" + getEndDateM + "',103) "
    
    
            Dim da As New SqlDataAdapter(strsql, mySQLConnection)
    
            da.Fill(dt)
            ds.Tables(0).Merge(dt)
            rptDoc.Load(Server.MapPath("~/Laporan/MeritAdmin.rpt"))
            rptDoc.SetDataSource(ds)
            CrystalReportSenaraiMeritAll.ReportSource = rptDoc
            CrystalReportSenaraiMeritAll.RefreshReport()
    
    
        End Sub
    End Class
    

    Tuesday, December 18, 2012 1:21 AM
  • User1109811461 posted

    hi gregaDro,

    i got it, your link give me idea where is my current code mistake, thanks a lot glad to work with youCool 

    Wednesday, December 19, 2012 8:57 PM