Calc Report Template - Graphs

[Eugene]

Hi all!

I have been trying to find a solution for the following problem for days now, but no luck so far. Maybe some of you have an idea?

My template has two pages, each with a print band (page 1, page 2). The table I'm printing the report for has multiple users with multiselect enabled, so I can create the report for any number of them.

I'm trying to use the normal built-in graph function in my report template on the second page. I set the value range for the bar to my placeholder cells that get filled out on the report creation, and everything works great when I'm just creating a report from ONE entry in my database. The problems start when I try to generate anything above that. The formatting and everything work just fine; the only problem is the graph. It stays stuck on the cells I entered in the template (for example $Sheet1.$E$65:$E$66), so it never changes on the subsequent pages I generate because they get placed below the original one.

If anyone has any ideas or suggestions on how to work around it, I would very much appreciate hearing from you =)

Best regards, Eugene

[Eugene]

Or is it somehow possible to change the serverside report code to create a new pdf file for every table entry i selected for a report?

[Dean D. Babic]

Hi and welcome,

Pls search here for both, ie:

https://groups.google.com/g/jam-py/c/rTokOWqyZHM/m/_tn5831EAwAJ

https://groups.google.com/g/jam-py/c/fQGPnWA9nGo/m/0vqx4C4CCQAJ

etc.

Hope this helps. The LO is a bit awkward to work with, to be fair.

D.

[Dean D. Babic]

Yes.

https://groups.google.com/g/jam-py/c/6sj0Ek4TOFA/m/xZmDKrZEAQAJ

On Friday, April 19, 2024 at 4:54:47 PM UTC+8 Eugene wrote:

[Eugene]

Hey, thanks for your help! 

I managed to loop through the records on the client side like suggested.