Mark Tabor

Mark Tabor

  • 590
  • 2k
  • 457.2k

When i am binding crystal report to stored procedure the pri

Jun 30 2016 6:18 AM
I have a web application in visual studio 2010 with crystal report 13.0.20.... version , i have some crystal reports into my web application some of the application works fine which are those to whom i directly databound them instead on using the stored procedure , but the reports which are binding from stored procedure does not provide the export functionality , in some of the pages if i remove the ispostback check from page load then it export correctly , but i cannot remove that line because i have dependent dropdown in my page and if i omit the post back from the page load then it did not sustain my posted value comming from  dropdown below is my page load event 
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
' FillDistrictsearch()
If Not Page.IsPostBack Then
FillDistrictsearch()
FillIndicators()
FillQuarter()
FillYEarSearch()
Dim crystalReport As New ReportDocument()
crystalReport.Load(Server.MapPath("~/CrystalReportDetailedMaster.rpt"))
Dim dsCustomers As AccumulatedDset = GetData()//get data bind the report
crystalReport.SetDataSource(dsCustomers)
crystalReport.SetDatabaseLogon("admin", "72.249.151.40", "planrbmedb2", "hg@3vdf43")
CrystalReportViewer1.ReportSource = crystalReport
End If
End Sub
 

Answers (1)