Cross tab

TkalpetisTkalpetis
edited June 2018 in FastReport 4.0
Hello i face a problem with the DB cross tab object. I want to put to master data codes like 21001,21002,21003 and to detail data to DB Cross Tab rows with colour, and columns with size.
But each code to appear each DB cross - tab .EG code 21001 master data then detail band with the colour and the size of this code in cross tab object then again the next code then again the db cross tab . Each master with only one cross tab object per detail band. Not all together. is it possible?

Comments

  • gpigpi
    edited 6:53PM
    Use Master dataset for MasterData band, Detail dataset - for DBCrosstab
  • TkalpetisTkalpetis
    edited June 2018
    gpi wrote: »
    Use Master dataset for MasterData band, Detail dataset - for DBCrosstab
    I did it already this test.And i get if i have 2 codes ,
    this result
    10001
    colour extrasmall small medium large etxra large
    10001 1 10 10
    10002 2 30 20

    10002
    colour extrasmall small medium large etxra large
    10001 1 10 10
    10002 2 30 20


    intead of this result
    10001
    colour extrasmall small medium large etxra large
    10001 1 10 10

    10002
    colour extrasmall small medium large etxra large
    10002 2 30 20
  • TkalpetisTkalpetis
    edited 6:53PM
    Tkalpetis wrote: »
    Tkalpetis wrote: »
    Use Master dataset for MasterData band, Detail dataset - for DBCrosstab
    I did it already this test.And i get if i have 2 codes ,one per line each lines the Crosstab brongw me two coes to each line.
    It doesn't break one code to each crosstab .
    Eg Codes 10001 and code 10002
    I get this result
    10001
    colour extrasmall small medium large etxra large
    10001 1 10 10
    10002 2 30 20

    10002
    colour extrasmall small medium large etxra large
    10001 1 10 10
    10002 2 30 20


    intead of this result
    10001
    colour extrasmall small medium large etxra large
    10001 1 10 10

    10002
    colour extrasmall small medium large etxra large
    10002 2 30 20

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 2024