Load report data at the beginning of report render phase

[christian.selic]

Hi,

Is it possible, that the ReportViewer/Designer loads report data according to the configured data sources, that means that I don't have to register data by myself (use regData())?

Use case is as follows
* Client is creating a new empty report
* Client adds a new custom data source (defined by us)
** Client provides credentials and filters for the data source
* Client is using the new custom data source to design a report
* Client saves the report template
* Client renders report as a PDF
** Stimulsoft Report Framework uses the configured data sources from the template to load AND register reportdata
** Report is rendered by using the loaded report data

Thank you in advance for your response.

Best regards,
Christian Selic

[HighAley]

Hello, Christian.

If you add a data connection to SQL database or any other data source it will be loaded by our engine before rendering the report.
The data for used data sources will be requested only.
Also it's possible to get information of used data sources.
Let us know if you need additional help.

Thank you.

[christian.selic]

Thank you. That solves the loading question.

We have a REST API that returns JSON data. Now we want to create a custom connection to our REST API and hide all the other connetion types.
Is it possible to create such a connection? If yes, is it also possible to define a custom configuration screen for that connection?

Please adivce how to achieve this.

Best regards,
Christian Selic

[christian.selic]

Additionally to my question above, I have one more.

Is it possible that Stimulsoft makes additional data load requests in the render phase? Imaging thins.

* I load data from an API endpoint /api/assets
* I want now to list all assets AND
** For every asset, I want to load some tickets from the API endpoint /api/assets/{asset-id}/tickets

Best solution for us would be, that I can register a data load function on a databand, which consumes the current databand item (contains the id to load further data) and a target databand identifier (this is the databand where to render the result).

Can this be solved with the help of Stimulsoft? Do you have a solution proposal to solve such a data loading scenario with Stimulsoft without loading and registring the data (no regData()) outside of Stimulsoft?

Best regrads,
Christian Selic

[christian.selic]

Hi Stimulsoft-Team,

Any news about my last questions?

Thanks in advance.

Best regards,
Christian Selic

[Edward]

Hi Christian,

The standard approach here would be to do all the required requests before rendering the report, then to combine them all into one dataset and to render as a simple report.
If there are many API calls, let's say 1 per databand row, then the report rendering might be quite slow as well.

It looks to me like a new features request, could you please send the request to support[at]stimulsoft.com, we will review that and come back to you.

Thank you,
Edward