Dev, Member
Hi,
I am trying to display a friendly message on a white screen that appears after clicking 'Run Report' and before the report results load. Ideally, the message would say something like, "Please wait, this may take a few more seconds."
We've tried using CSS and AJAX, but these only seem to apply during the report loading process, not on the blank screen that shows before the results appear. Could you help us find a solution for displaying this message during that interim period/screen?
Thanks
myDBR Team, Key Master
Is the problem with the report being slow (i.e., the load time), or is it the amount of data in the report (affecting page rendering)?
--
myDBR Team
Dev, Member
The amount of data in the report is large, so it happens. For smaller data ranges, it does not happen.
myDBR Team, Key Master
That means the browser is receiving the data and rendering the content, and you cannot intercept this process. If you have a large report, consider adding a warning to the user in the parameter screen.
Always assess whether you truly need such a large report or if it could be more effectively handled through linked reports.
--
myDBR Team
Dev, Member
Hi,
Is there any way to display the first 100 results immediately, while the rest of the data loads as the user scrolls down? Is it possible to implement pagination in this scenario?
myDBR Team, Key Master
Reports taking a long time may be caused by two primary reasons:
1) The queries are slow, and it will take time for the server to produce the result.
2) The amount of data returned is so large that the user's browser will take its time to lay out the page.
Which one is your issue?
--
myDBR Team
Dev, Member
Hi,
Number 2 is our issue. The time it takes for the browser is long so it displays a white screen while it loads. Is there anything we can show there 'Please wait' in that screen using js or any other code?
myDBR Team, Key Master
There is not much you can do when your browser has the data and is rendering it.
How muc data are you showing in the report or is it some other complexity in the report that it causing it to be slow?
--
myDBR Team
Dev, Member
Basically, the report has many columns, and due to the date range, it takes time to load. I have created suitable indexing and optimized the reports. I have also applied notable CSS for the reports, such as showing a loading spinner when clicking "Run Report." However, the issue still persists.
I want to ensure that during the loading time, the screen displays appropriate messages or indicators. So I just want to make sure i've tried everything before stop trying on the rendering time.
myDBR Team, Key Master
How many rows and columns do you have in the report i.e. what is the amount of work the browser has to do?
How long does it take to execute the report before rendering?
--
myDBR Team
You must log in to post.