How to show out the vertical data

foonmodfoonmod
edited 4:12AM in FastReport 4.0
Suppose that I have the data like ETADate around 4 or 5 EtaDate .

Normally the report would show the result like below

ETADate
02/06/2011
05/06/2011
15/06/2011
25/06/2011


But, If I would like to have the report output like below ....

ETADate1 ETADate2 ETADate3 ETADate4 More??¦..
02/06/2011 05/06/2011 15/06/2011 25/06/2011 -- >

How to do that ?

Help me please


Comments

  • Mick.plMick.pl
    edited 4:12AM
    Have a look at compiled FR Demo and see how DBCrossTab works.
    You can get similiar result using DBCross.

    Mick
  • gpigpi
    edited 4:12AM
    Or try to use vertical bands
  • technisofttechnisoft
    edited 4:12AM
    Or use a query

    SELECT A.VALUE
    ,(SELECT FIRST 1 B.ETADATE FROM TABLE B WHERE B.ID = A.ID ORDER BY B.ETADATE) AS ETA1
    ,(SELECT FIRST 1 SKIP 1 B1.ETADATE FROM TABLE B1 WHERE B1.ID = A.ID ORDER BY B1.ETADATE) AS ETA2
    ,(SELECT FIRST 1 SKIP 2 B2.ETADATE FROM TABLE B2 WHERE B2.ID = A.ID ORDER BY B2.ETADATE) AS ETA3
    //etc.
    FROM TABLE A
    WHERE A.CONDITION = :SOMETHING
  • foonmodfoonmod
    edited 4:12AM
    Thank very much.
    I don't know that there is the vertical band before till you told me. How to work on that ?

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2025