Pass a dataset to report in ActiveReports 10

Pass a dataset to report in ActiveReports 10

Posted by: luca on 20 January 2023, 7:02 am EST

• 

  luca

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 January 2023, 7:02 am EST - Updated 20 January 2023, 7:44 am EST

  I use this code to set datasource in report Load

    Private Sub _Report1_Load(sender As Object, e As EventArgs) Handles Me.Load
          Dim rpt As GrapeCity.ActiveReports.SectionReport = New GrapeCity.ActiveReports.SectionReport()
          Dim xtr As System.Xml.XmlTextReader = New System.Xml.XmlTextReader(Server.MapPath("~\Reports\Rpt_Offerta_PND.rpx"))
          rpt.LoadLayout(xtr)
          xtr.Close()
  
          rpt.DataSource = Session("MYDATASET").Tables("MYTABLE")
          WebViewer1.Report = rpt

  i’d like pass also MYDATASET in rpt so in the script i can use it.
  
  Can i do it ?

• 

  luca

  • Post Options:
  • Link
    Copy

  Posted 20 January 2023, 8:11 am EST

  i resolved with :
  
  rpt.AddNamedItem(“Mydataset”, Session(“DSDATI”))

  and in the script of my report in START i convert the object to dataset
  
  _ds = CType(mydataset, dataset)

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 23 January 2023, 5:00 am EST

  Hi Luca,

  We’re glad you were able to resolve this issue! Thanks for sharing the solution with us, this will help others facing a similar issue.

  Regards,
  
  Anand