Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>EDIT</strong> since the previous* answer does not work with newer versions</p> <p>Set rowcount to 9 for your masterdata band of the subreport.<br> In your mainreport, copy the masterdata band containing the subreport and insert it twice.<br> Put a headerband between the masterbands with property StartNewPage set to true.<br> Add OnBeforePrint events to the second and the third subreport to change the filter for the dataset.</p> <pre><code>procedure Subreport2OnBeforePrint(Sender: TfrxComponent); begin TfrxDBDataSet(Report.GetDataset('frxDBDataset1')).Dataset.Filter := 'ID&gt;9'; TfrxDBDataSet(Report.GetDataset('frxDBDataset1')).Dataset.Filtered := true; end; procedure Subreport3OnBeforePrint(Sender: TfrxComponent); begin TfrxDBDataSet(Report.GetDataset('frxDBDataset1')).Dataset.Filter := 'ID&gt;18'; TfrxDBDataSet(Report.GetDataset('frxDBDataset1')).Dataset.Filtered := true; end; </code></pre> <p><img src="https://i.stack.imgur.com/PKd1S.png" alt="enter image description here"> </p> <p><strong>(*) for older report versions</strong>, you can use an other approach, which stopped working between the versions 4.10.01 and 4.12.14.</p> <p>Add an <em>OnAfterPrint</em> event to your memo on the subreport. Set the property <em>StartNewPage</em> to true after printing 9 "lines", Rowcount of the Masterband has to set to 1.</p> <pre><code>procedure YourMemoFromTheSubReportToRepeat9TimesPerPageOnAfterPrint(Sender: TfrxComponent); begin MasterDataBandFromSubReport.StartNewPage := &lt;Line#&gt; mod 9 = 0 end; </code></pre> <p><img src="https://i.stack.imgur.com/ZxK9Q.png" alt="enter image description here"></p>
    singulars
    1. This table or related slice is empty.
    1. POHow to show data at Fast Report in 3*3 grid format?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USbummi
    1. USbummi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUndeletion
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO@ bummi, it is printing 3*3 grid on new page with same lines i.e Line 1 to Line 9. Actually I want to print four 3*3 grid on single page with not repetition of records i.e means after printing Line 1 to Line 9 in first grid it will print Line 10 to Line 18 in second grid, Line 19 to Lione 27 in 3rd Grid, Line 28 to Line 36 in 4th Grid on first page..... Line 37 to 45 on first grid of second page etc.. so on..It would print continuous record as they are in database table.
      singulars
      1. PO
      1. USNinad Avasare
    2. COAfter printing first 9 records in first grid it is moving frxDBDataSet1 back to first record again and printing same first 9 records in next grid..Thus way it is printing same first 9 records in all grids by ignoring records after count 9...How to avoid this repetition so it would not move frxDBDataset to first record after printing records in first grid?
      singulars
      1. PO
      1. USNinad Avasare
    3. CO1) Your first solution with 3 subreports works. But it work only when there are only less than 27 record in the table and we know the number. IS there anything like this can be done dynamically in case if we not aware about how many records are there in table. 2) Other issue I am getting `Undeclared Identifier - TfrxDBDataset` error.
      singulars
      1. PO
      1. USNinad Avasare
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload