RDL ActiveReports WebViewer VB.Net Integration

Posted by: cemsanal on 3 August 2017, 3:23 pm EST

  • Posted 3 August 2017, 3:23 pm EST

    We have nearly a thousand RDL reports. We want to integrate, test to understand whether your RDL Report Viewer is fast and reliable or not with our Framework. We execute RDL reports without a report server. Reports work within our Framework. We don’t want to rebuild our reports as rdlx or using any other technology. If your report viewer work as expected with our RDLs, we will buy it for our customers. Our Framework and modules are built with using standard VB.Net 4 technologies.

    We tried to test ActiveReports RDL report viewer and tried to integrate pageReports with WebViewer.

    We used WebViewer like that:



    We used your example ‘AR_RunTime_DataSource’ as reference. That example is similar to our Framework structure.

    The Problem:
    I couldn’t use many DataSets without a DataSource. I want to give only one DataSource and use at least 15 DataSet from that DataSource. We want to use queries with parameters. However, when we use these codes fetch these DataSets, our report could not be shown. We did debug and saw that we can fetch only one DataSet. Even our test report is very small, it includes only one DataSet and only one table, the report could not be shown.


    What we see in browser (Report could not be shown):



    I gave our vb part about ActiveReports execution:

    Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load

    If Page.IsPostBack Then
    Exit Sub
    End If


    Dim report1 As New GrapeCity.ActiveReports.PageReport(New System.IO.FileInfo(Server.MapPath("PageReport1.rdlx")))
    AddHandler report1.Document.LocateDataSource, AddressOf pageDocument_LocateDataSource
    WebViewer1.PdfExportOptions.FitWindow = False
    WebViewer1.Report = report1

    End Sub

    Private Sub pageDocument_LocateDataSource(ByVal sender As Object, ByVal args As GrapeCity.ActiveReports.LocateDataSourceEventArgs)

    If (args.DataSourceName = "DataSource1") Then
    If (args.DataSetName = "DataSet1") Then
    args.Data = GetData()
    End If
    End If

    End Sub
  • Replied 3 August 2017, 3:23 pm EST

    What are your solutions for that problem?
    Sorry, that issue should be inside of ActiveReports 10 topic.

    What we see in browser (Report could not be shown):



  • Replied 3 August 2017, 3:23 pm EST

    Hello,

    Page Reports do not allow for multiple data sets/data sources, so if you’re working with this type, it is not doable.

    If you’re working with RDL reports, it is possible.

    Another take on using multiple datasources in PageReport type is that you can design a page report with datasource as “DataSet provider”.

    When you do that, you will need to specify the dataset at runtime using LocateDataSource api. At runtime, you can connect to multiple datasources and then get data into one dataset and then pass that one dataset to the PageReport.

    So, essentially the limitation with PageReport is that it only uses one dataset, however that dataset can have data from multiple datasources, which can be accomplished at runtime as mentioned above.

    Here is a link on how to go about doing it. See the dataset provider section here :

    http://arhelp.grapecity.com/webhelp/AR10/index.html#Bind%20Page%20Reports%20to%20a%20Data%20Source.html

    In order to use multiple datasources, you will need to use subreport control. Please check the following link for more information on this:

    http://arhelp.grapecity.com/webhelp/AR10/index.html#SubreportReportItem.html

    http://arhelp.grapecity.com/webhelp/AR10/SubreportinRDLReport.html

    However, if you create multiple datasets from the same datasource, you should be able to use them using different data regions. But, [u]please make sure that you are currently using RDLReports since PageReports do not support multiple datasets.[/u]

    Refer to the following links wherein similar issues have been answered :

    http://our.componentone.com/groups/topic/unable-to-bind-to-multiple-datasources/

    http://arhelp.grapecity.com/groups/topic/putting-multiple-data-regions-on-page-report/

    http://stackoverflow.com/questions/20555438/active-reports-page-reports-multiple-tables

    http://arhelp.grapecity.com/groups/topic/multiple-datasets-in-a-fpl/

    Let me know if you still face any issues.

    Regards,
    Reema
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels