Crystal with VS2005 Dataset NO field explorer
Have ASP.NET web app using VS 2005 and Crystal. I am using typed dataset and having issue with seeing filed in field explorer
did following in seperate class
-created dB connection
-cretaed typed dataset
-added Crystal Report to project
now, in report when go to database expert I see following
/project data /ADO.NET DataSets
...no items found
/project data / .Net Objects
populateDataset 'class name
populateDataset
here are my questions
1.) Should I be seeing item under /project data /ADO.NET DataSets ? anything wrong ?
2.) if I select populateDataset as my data source, I do not see any fields that I can select from.
Any help would be deeply appreciated.
thanks,
Shyam
please find code below
report.aspx
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Private SCAReport As ReportDocument
Private Sub ConfigureCrystalReports()
SCAReport = New ReportDocument()
Dim reportPath As String = Server.MapPath("SCAReport.rpt")
SCAReport.Load(reportPath)
Dim myDataS As DataSet = populateDataset.SCADataset
SCAReport.SetDataSource(myDataS)
myCrystalReportViewer.ReportSource = SCAReport
'gv.DataSource = myDataS.Copy()
'gv.DataBind()
End Sub
Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
ConfigureCrystalReports()
End Sub
End Class
/App_code/populateDataset.vb
Imports Microsoft.VisualBasic
Imports System
Imports System.Data
Imports System.Configuration
Imports System.Web
Imports System.Web.Security
Imports System.Data.SqlClient
Public Class populateDataset
Public Shared ReadOnly Property SCADataset() As DataSet
Get
Dim ds As DataSet = New DataSet()
ds.ReadXmlSchema("C:\Inetpub\wwwroot\Reports\SCAXMLSchema.xsd")
Dim connString As String = ConfigurationManager.ConnectionStrings("SCA").ConnectionString
Dim conn As SqlConnection = New SqlConnection(connString)
Dim ad As SqlDataAdapter = New SqlDataAdapter("select [database],sca_item , total_conversion_rcount, data_load_id from stats", conn)
ad.Fill(ds, "SCA_CCC")
Return ds
End Get
End Property
End Class