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
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
afastars
Member
52 Points
221 Posts
Crystal Report With Dataset
Dec 17, 2012 06:46 AM|LINK
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 here
CruzerB
Contributor
5399 Points
1098 Posts
Re: Crystal Report With Dataset
Dec 17, 2012 08:09 AM|LINK
Hi,
Which data source that you are using at Crystal Report?
My Technical Blog
gregaDro
Member
318 Points
65 Posts
Re: Crystal Report With Dataset
Dec 17, 2012 08:09 AM|LINK
Check this if it's helpful ...
http://stackoverflow.com/questions/1186048/crystal-reports-the-report-you-requested-requires-further-information
afastars
Member
52 Points
221 Posts
Re: Crystal Report With Dataset
Dec 18, 2012 03:49 AM|LINK
hi gregaDro
i need guidance from you regading this information, will try first
afastars
Member
52 Points
221 Posts
Re: Crystal Report With Dataset
Dec 18, 2012 05:21 AM|LINK
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 Classafastars
Member
52 Points
221 Posts
Re: Crystal Report With Dataset
Dec 20, 2012 12:57 AM|LINK
hi gregaDro,
i got it, your link give me idea where is my current code mistake, thanks a lot glad to work with you