ReportServer Forum

iamcarolek

Member

Registered: 2023-06-09

Dashboard Rolling

Hi I have a dynamic list variant of 50 records (Top 50 report based on Rownum<=50).  While all 50 show on page 1, the dashboard shows 2 pages with the 50th record repeating on page 2.  It is an issue as clicking to page 2 requires the query to run again.  Is there a way to stop it from duplicating the last record on page 2?

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Rolling

Hi iamcarolek,

which RS version exactly are you using? And what database exactly is your dynamic list based on?

Regards,
Eduardo

iamcarolek

Member

Registered: 2023-06-09

Re: Dashboard Rolling

We are on RS4.6.1-6092 (2023-05-26-13-10-32)
Oracle ATP

Thank you for your help!

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Rolling

Hi iamcarolek,

we raised ticket RS-7563 for looking into this issue.

Regards,
Eduardo

iamcarolek

Member

Registered: 2023-06-09

Re: Dashboard Rolling

Thank you for investigating. I appreciate you very much.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Rolling

Hi iamcarolek,

we fixed this bug for Oracle. The fix will be available in the next 4.6.1-PATCH and 4.5.0-LTS versions.

We will also check if this happens in other DBs as well.

Regards,
Eduardo

iamcarolek

Member

Registered: 2023-06-09

Re: Dashboard Rolling

You are awesome! thank you very much!

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Rolling

Hi iamcarolek,

this has been fixed in 4.6.1-6096 and 4.5.0-6095, both released today.

Regards,
Eduardo