Need help creating side-by-side columns (Kanban style)

More
7 months 4 days ago - 7 months 4 days ago #25880 by Onkar2002
 I am trying to create a specific layout in FastReport and hitting a wall. I need a "Dashboard" style report for employee tasks.The Goal:
Page Layout: Standard portrait page (0 columns).
Top: Employee Name & Photo (Full width).
Bottom: A list of tasks grouped by Frequency (Daily, Weekly, Monthly).The Requirement: I need the task groups to appear side-by-side in vertical columns (like a Kanban board).
Column 1: Daily Tasks
Column 2: Weekly Tasks (Must start at the top of Col 2)
Column 3: Monthly Tasks (Must start at the top of Col 3)What I have tried:
I set the MasterData band to 3 Columns.
I wrote a custom SQL sort so the data comes in strictly ordered: Daily -> Weekly -> Monthly.
I tried using StartNewPage = True on the GroupHeader, but this forces a completely new sheet of paper, not just a column break.
I tried using Engine.NewColumn in the OnBeforePrint script of the GroupHeader, but it doesn't seem to trigger the jump correctly inside the band.

The Problem: I cannot get the "Weekly" header to snap to the top of the next column. It either flows right underneath "Daily" (like a normal list) or breaks to a new page entirely.
My Question: How do I configure the GroupHeader + MasterData band so that when the Group changes (e.g., from Daily to Weekly), it forces a Column Break only, keeping everything on the same page?

this is how it looks right now 
 
 

The following img is my expected output
 

and this the fast reports 
 

I would be very grateful for any advice or script examples.
Last edit: 7 months 4 days ago by Onkar2002.

Please Log in or Create an account to join the conversation.

More
7 months 4 days ago - 7 months 4 days ago #25883 by admin
I am struggling to understand the issue to be honest.

We need an example from you.

Actual database and actual report pointing to this database.

You can use ms access as the database 

Mike
ETL Architect
Last edit: 7 months 4 days ago by admin.

Please Log in or Create an account to join the conversation.

More
7 months 3 days ago #25884 by Peter.Jonson
Perhaps the solution here is to use side by side subreports


Peter Jonson
ETL Developer
The following user(s) said Thank You: Onkar2002

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save