Forum Discussion

Aartibhilare's avatar
Aartibhilare
Helper III
1 year ago

Page break in multi column report

Hi, I have created a multicolumn paginated report, which includes a subreport that I want to break at the group level (based on the "Date" field). Currently, the report is breaking at the column lev...
Pagebreak
divyed's avatar
divyed
Super User
1 year ago

Hello Aartibhilare ,

 

This can be achieved using list :

1. Take a list 

2. Add date column to act as a group (add this as group)

3. Add your base report

4. Attach subreport

5. Select list => go to properties => Add page break between each instance of group and you are done

 

Cheers

Neeraj Kumar

Aartibhilare's avatar
Aartibhilare
Helper III
1 year ago

hello divyed 

I have tried this if you mention the no of columns 3 in report and you break at page level it won't work it breaks at column level .

  • divyed's avatar
    divyed
    Super User
    1 year ago

    Hello Aartibhilare ,

    It should work. It looks like below :

    Outer box is a listbox. Then I have added a textbox with column I want as group. Next is a table , you can add fileds you want to show in the table except date.

    3rd one is again a table, you can replace this with your subreport which will take date as input and breaks accordingly.

     

     

    • Aartibhilare's avatar
      Aartibhilare
      Helper III
      1 year ago

      Hello divyed 

      i want like below in 3 columns

      if i kept column as 3 it wont work but column 1 works completely fine

       

      at the end my report end goal is as below and break at at date level