Auto Sum Table Print View Bug

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
User avatar
ronwill
Veteran Member
Posts: 228
Joined: 2015-08-08 10:12
Location: Cheltenham UK +Weatherford USA

Auto Sum Table Print View Bug

Post by ronwill » 2018-03-22 01:47

Hi All,

Just noticed that when I view table with auto sum it gives correct sum figure when viewing and also when selecting print preview (table) without using checkbox to select various records.
However when selecting some records (checkbox) and doing print preview it shows some totally unrelated figures in sum columns and there is no sum symbol on left either - happens regardless of selecting all records or just a few!
Don't remember ever having this problem before (earlier versions).
Anyone else having or noticed same issue?
Cheers, Ron

Cap1 = Normal view
Cap2 = Table print view all records (not using selection check box)
Cap3 = Table print view all records when using check box to select all (same issue if only selecting 1,2 records etc.)
Cap1.JPG
Cap1.JPG (25.25 KiB) Viewed 2286 times
Cap2.JPG
Cap2.JPG (25.7 KiB) Viewed 2286 times
Cap3.JPG
Cap3.JPG (25.56 KiB) Viewed 2286 times
Ron - Gloucestershire, UK: AppGini Pro V 23.15 Rev 1484 - LOVING IT!
Plugins: Mass Update + Search Page Maker + Summary Reports + Calendar + Messages
Bizzworxx: AppGiniHelper + Inline Detail View
Alejandro Landini: To-Do List + MPI + TV Field Editor
Other: Udemy Course

User avatar
ronwill
Veteran Member
Posts: 228
Joined: 2015-08-08 10:12
Location: Cheltenham UK +Weatherford USA

Re: Auto Sum Table Print View Bug

Post by ronwill » 2018-03-22 22:06

Discovered scenario where above happens:

1. When User has ALL view permissions of the table, has filter applied (table hooks) with filtered result only showing in table = Sum result Table View & Print View Table (selected records or all) = OK works fine

2. When user has OWNER or GROUP records view permissions of table, has filter applied (table hooks) with filtered result only showing in table = Sum result Table View = OK works, BUT PRINT VIEW (either random selected records and or all) = Strange sum results (as images)!

Summary:
If you have filters applied in table hooks, then ensure user has full view permissions of table = correct result
If no filters in table hooks = no issues (works according to permissions/selections)

Hope that makes sense!?
Cheers, Ron
Ron - Gloucestershire, UK: AppGini Pro V 23.15 Rev 1484 - LOVING IT!
Plugins: Mass Update + Search Page Maker + Summary Reports + Calendar + Messages
Bizzworxx: AppGiniHelper + Inline Detail View
Alejandro Landini: To-Do List + MPI + TV Field Editor
Other: Udemy Course

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: Auto Sum Table Print View Bug

Post by a.gneady » 2018-04-03 08:13

Thanks for reporting this bug, Ron. We'll investigate it and make a fix in future releases.
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply