How to display data in 3*3 grid with specific order

Comments

• gordk St.Catherines On. Canada.

  October 2013 edited 9:16AM

  set the columns on the master data band.
• ninadgac

  October 2013 edited October 2013

  I got one .fr3 grid template which a subreport is used as follows
  
  
  
  Here actually creator wants to display ID and corresponding Description from the particular table then how he would have declared multiple variable like
  
  ID1, ID2, ID3 & DESC1, DESC2, DESC3 etc..
  
  What it stands for ?
  
  I also have attached .fr3 for reference.
• gordk St.Catherines On. Canada.

  October 2013 edited 9:16AM

  i am just guessing it appears they are possinbly variables.
  they could be linked to datafields in the table
  or they could be given values using the onget value event.
• ninadgac

  October 2013 edited 9:16AM

  gordk wrote: »

  i am just guessing it appears they are possinbly variables.
  they could be linked to datafields in the table
  or they could be given values using the onget value event.

  
  I am using subreport at main page inside MasterData1 band. At subreport MasterData band is as follows
  
  MasterData1 band
  
  TfrxReportPage1 - Columns 2
  
  
  
  SubReport - MasterData2 properties Columns 3 , RowCount 9
  
  
  
  
  But when I previewed fast report it is just repeating same data in each grid on page as follows. I am getting repeated data like this, it is repeating id's 1 to 9 again in each masterband.
  
  
  
  I am using frxDBDataSet1 to display data (Number Of Records set to 9). There are in total 28 records so it is expected to show four 3*3 grids on page with 27 IDs. but rather it is repeating first 9 ID's in each 3*3 grid as shown above.
  
  
  Any idea how to avoid repetition of same data in each band?
  
  
• ninadgac

  October 2013 edited 9:16AM

  Is there any more tutorial topics and sample codes/ demos explaining use of multiple pages and subreport at Fast Report. How to use multiple pages at Fast Report?
• gordk St.Catherines On. Canada.

  October 2013 edited 9:16AM

  1 The band must be connected to the dataset to iterate through its records or you must write code to move the dataset.
  2 your subreport object should not be on the page but in a band, probably a detailband
  set to stretch
  3 you are stating that there is a posibility of 36 detail records for each master1 record so you may find that you cannot work using the column approach but need to write code to track and alter the report engines curx and cury settings in the obp event and oap event of the masterdata2 band.
  
• ninadgac

  October 2013 edited 9:16AM

  gordk wrote: »

  1 The band must be connected to the dataset to iterate through its records or you must write code to move the dataset.
  2 your subreport object should not be on the page but in a band, probably a detailband
  set to stretch
  3 you are stating that there is a posibility of 36 detail records for each master1 record so you may find that you cannot work using the column approach but need to write code to track and alter the report engines curx and cury settings in the obp event and oap event of the masterdata2 band.

  
  
  Is there any way to set new range for frxDBDataset dynamically? i.e suppose if we set frxDBDataset range for first 9 records then after printing first 9 records can we set next range dynamically in code as 10 to 18 ?
• gordk St.Catherines On. Canada.

  October 2013 edited 9:16AM

  no you cannot, when you reaxh the end of the detaildataset the first master is moved to the next record
• gpi

  November 2013 edited 9:16AM

  Try to use Masterdata2 from subreport instead of MasterData1