Creating reports and dashboards | Stimulsoft community forum

Hi

I'd like to know if there are recommendations for deploying Stimulsoft reports.

1) How many users can generate reports at the same time? Is it possible, for instance, 10 such users generate reports with tens of pages, at the same time?
2) Some reports we handle today have more than 100000 records per dataset and a thousand pages. How should we handle that?
3) We've nested data that we'd like to bring in the form of a business object with an IList as nested property. And this way create bands and subreports to generate the reports. Is this recommended? Or should we gather all data in only one business object and use groups?
4) How should we arrange machines to support this? Do we need a separate server exclusive for reports?

Thanks in advance

Hello.

Werlang wrote:1) How many users can generate reports at the same time? Is it possible, for instance, 10 such users generate reports with tens of pages, at the same time?

It depends on your server because all reports are remdered on the server side.

Werlang wrote:2) Some reports we handle today have more than 100000 records per dataset and a thousand pages. How should we handle that?

Maybe we don't understand your question. Could you rephrase it?

Werlang wrote:3) We've nested data that we'd like to bring in the form of a business object with an IList as nested property. And this way create bands and subreports to generate the reports. Is this recommended? Or should we gather all data in only one business object and use groups?

It's better to use nested business objects and master-detail report.

Werlang wrote:4) How should we arrange machines to support this? Do we need a separate server exclusive for reports?

It depends on power of your server.

Thank you.

Aleksey Andreyanov wrote:Hello.

Werlang wrote:2) Some reports we handle today have more than 100000 records per dataset and a thousand pages. How should we handle that?

Maybe we don't understand your question. Could you rephrase it?

Thank you.

Hello Aleksey.

Let me try to explain.

We need to build a report with these configurations:

• One business object list with 100.000 objects. Each object has 20 scalar properties
• Each object occupies a line inside data band, some like 50 records/objects per page
• We end up with a 2.000 pages report, more or less

Can I build that report this way? Would it hang or consume too much memory? The server is quite good, Intel quad-core 2Ghz, 64bits, 8GB RAM. In this server we also run the the whole application.

Thanks again.

Werlang wrote:Can I build that report this way? Would it hang or consume too much memory? The server is quite good, Intel quad-core 2Ghz, 64bits, 8GB RAM. In this server we also run the the whole application.

It's impossible to answer your question because the memory consumption depends on the report structure and data that is used.
It's possible to know empirically only.
You could try to build such report and let us know if there will be any problem.

Thank you.