Crystal Report problem

[pritesh2010]

hello everyone i had created 5-6 crystal report in my vb.net project with back end sql server 2005 and i had given my path for crystal report. after this i had creted setup and deployed at customer machine but there it dosn't shows any report instead of it gives an error. for viewing report so how to come up with this probelm. help me .

[kvprajapati]

I would like to suggest you to use Push model to design crystal reports.

[pritesh2010]

thank you for replay but i don't how to push can you give me one example on this.

[kvprajapati]

See the links in post #2.

[pritesh2010]

yes i got tahnks

[pritesh2010]

can we insert many table and view in dataset.xsd file without any relation between them. how many table i can insert in one dataset.xsd file.

[pritesh2010]

as per you told i had tried Push model but it gives error while i'm creating Purchase report

Private Sub btncrt_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btncrt.Click
        getconnect()
        vbstr = "Select * from [vw_rptsales] WHERE CustomerNo like 'C1'"
        cmd = New SqlCommand(vbstr, con)
        Dim da As New SqlDataAdapter
        da.SelectCommand = cmd
        Dim ds As New DataSet1
        da.Fill(ds, "vw_rptsales")
        On Error GoTo 0
        Dim rpt1 As New rptsales
        rpt1.SetDataSource(ds)
        Me.CrystalReportViewer1.ReportSource = rpt1
        ds.Dispose()
    End Sub

but while cursor go to at

da.Fill(ds, "vw_rptsales")
''gives an error of failed to enable constraints. one or more rows contain values violating non-nulls,
unique, or foreign key constraints.

how to solve this please help me

[kvprajapati]

>how to solve this please help me

Open .xsd (DataSet), right click on table (vw_rptsales), choose delete key, save & close .xsd.