Inconsistent number of rows in Dashboard exports

Stimulsoft Reports.JS discussion
LRHF
Posts: 13
Joined: Thu Apr 11, 2024 12:15 am

Inconsistent number of rows in Dashboard exports

Post by LRHF »

Hi there,
We created a couple of Dashboards and I'm investigating why the exporting is inconsistent. We have the "Missing Superbills" dashboard (see attached image), and all options (except Image) export the full amount of rows (2,930) which is what we expect.

On the other hand, as you can see in the "Workflow Status" attached image, the dashboard has thousand of rows, and the last item on screen is "Superbill Age (days)" 115 (highlighted). However, when exporting to:
  • Image: it exports 2 more rows than what is visible on screen.
  • Data: it exports 4 more rows than what is visible on screen.
  • Excel: it exports 3 less rows than what is visible on screen.
  • PDF: it export the exact number of rows on screen.
I had a look at the templates (JSON files) and didn't see any specific configuration about exporting, so I'm guessing this could be either a bug or something we didn't specified properly in the Designer.

Could you please let me know (if the issue is in our side) how to fix it, so that all rows are exported? Thanks,
Attachments
MissingSuperbills.jpg
MissingSuperbills.jpg (196.48 KiB) Viewed 8488 times
WorkflowStatus.jpg
WorkflowStatus.jpg (266.47 KiB) Viewed 8488 times
Lech Kulikowski
Posts: 7332
Joined: Tue Mar 20, 2018 5:34 am

Re: Inconsistent number of rows in Dashboard exports

Post by Lech Kulikowski »

Hello,

We need some additional time to investigate the issue.

Thank you.
#14835
LRHF
Posts: 13
Joined: Thu Apr 11, 2024 12:15 am

Re: Inconsistent number of rows in Dashboard exports

Post by LRHF »

Hi there,
Do you have any updates on this?
Lech Kulikowski
Posts: 7332
Joined: Tue Mar 20, 2018 5:34 am

Re: Inconsistent number of rows in Dashboard exports

Post by Lech Kulikowski »

Hello,

For now as it is, since PDF has clear page dimensions and excel does not.
However, we have taken this issue under consideration and will look for a solution.

Thank you.
LRHF
Posts: 13
Joined: Thu Apr 11, 2024 12:15 am

Re: Inconsistent number of rows in Dashboard exports

Post by LRHF »

Hello,

I just wanted to know if there is already a timeframe for fixing these issues, or any other updates you can provide me with.

Thank you.
Lech Kulikowski
Posts: 7332
Joined: Tue Mar 20, 2018 5:34 am

Re: Inconsistent number of rows in Dashboard exports

Post by Lech Kulikowski »

Hello,

We are still working on the task.

Thank you.
LRHF
Posts: 13
Joined: Thu Apr 11, 2024 12:15 am

Re: Inconsistent number of rows in Dashboard exports

Post by LRHF »

Hello,
Do you have any updates on this issue?
It's been a long wait... almost 3 months.

Thanks, Luis.
Lech Kulikowski
Posts: 7332
Joined: Tue Mar 20, 2018 5:34 am

Re: Inconsistent number of rows in Dashboard exports

Post by Lech Kulikowski »

Hello,

We have added new options for exports. It will be available in the release 2024.4.1 within two weeks.

Thank you.
LRHF
Posts: 13
Joined: Thu Apr 11, 2024 12:15 am

Re: Inconsistent number of rows in Dashboard exports

Post by LRHF »

Hello,
I installed 2024.4.1 but unfortunately I don't see any changes.

Just to confirm this is part of our API response:
"adapterVersion": "2024.4.1",
"handlerVersion": "2024.4.1",

The "Missing Superbill" dashboard exports 3.828 rows in the CSV file, whereas "Workflow Status" exports only 15 rows in the CSV file, 1 row less that what is shown on screen, although it has thousand of rows.

I have attached the template for you to review. Is there anything wrong that you can see in our template? I had a look and I don't see any setting that can be affecting the number of rows to be exported.

Thanks for your help, Luis.
Attachments
Workflow Status.json
(39.99 KiB) Downloaded 463 times
Lech Kulikowski
Posts: 7332
Joined: Tue Mar 20, 2018 5:34 am

Re: Inconsistent number of rows in Dashboard exports

Post by Lech Kulikowski »

Hello,

If you export the entire dashboard, it only exports what is shown on the viewer.
If there is a table with 1000 records and the viewer shows 10 records, if you export the entire dashboard, only 10 records will be exported. If you need all 1000 records, you need to export only the table.

Thank you.
Post Reply