Grouping problem in RTC reports

julkifli33
julkifli33 Member Posts: 1,092
edited 2011-06-30 in NAV Three Tier
Hi all, i have a problem when using RTC reports
for example i have data like this :
record 1 grup 2
record 2 grup 1
record 3 grup 1
record 4 grup 2
record 5 grup 1
record 6 grup 2
what we have when we grouped is like this :
header group 1
record 2
record 3
record 5
footer group 1

header group 2
record 1
record 4
record 6
footer group 2

but can we do become like this
record 1 grup 2
record 2 grup 1
record 3 grup 1
record 4 grup 2
record 5 grup 1
record 6 grup 2

footer group 1
footer group 2

please help
thanks

Comments

  • Troubles_In_Paradise
    Troubles_In_Paradise Member Posts: 588
    julkifli33 wrote:
    Hi all, i have a problem when using RTC reports
    for example i have data like this :
    record 1 grup 2
    record 2 grup 1
    record 3 grup 1
    record 4 grup 2
    record 5 grup 1
    record 6 grup 2
    what we have when we grouped is like this :
    header group 1
    record 2
    record 3
    record 5
    footer group 1

    header group 2
    record 1
    record 4
    record 6
    footer group 2

    but can we do become like this
    record 1 grup 2
    record 2 grup 1
    record 3 grup 1
    record 4 grup 2
    record 5 grup 1
    record 6 grup 2

    footer group 1
    footer group 2

    please help
    thanks

    I think no because grouping is used to group records that belong to the same "father".
    ~Rik~
    It works as expected... More or Less...
  • Belias
    Belias Member Posts: 2,998
    make 2 tables in the rdlc: the first with the details only, the second with the 2 groups only.
    (you'll probably have to put the two tables in a list, but probably not...so i'll explain better only if you really need it -because im lazy-, give a try to my solution and feed us back if something is wrong)
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • julkifli33
    julkifli33 Member Posts: 1,092
    Belias wrote:
    make 2 tables in the rdlc: the first with the details only, the second with the 2 groups only.
    (you'll probably have to put the two tables in a list, but probably not...so i'll explain better only if you really need it -because im lazy-, give a try to my solution and feed us back if something is wrong)

    yes i tried it before
    so table 1 --> detail
    table 2 --> only for the grouping

    there is a problem
    1. when it changing page...
    the header which i pull from table 1, it will not appear in the last page (which is last page only showing from table 2)

    2. i want to put the table 2 in footer part
    reportitems cannot do looping, isn't it?
  • Belias
    Belias Member Posts: 2,998
    1. you have to use getdata/setdata functions to show the values in the header part of the report
    2. reportitems cannot loop, and body parts cannot be placed in bottom. I don't think you can achieve this (i need some time to think about it)
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • julkifli33
    julkifli33 Member Posts: 1,092
    Belias wrote:
    1. you have to use getdata/setdata functions to show the values in the header part of the report
    2. reportitems cannot loop, and body parts cannot be placed in bottom. I don't think you can achieve this (i need some time to think about it)

    for table 1, I also using getdata and setdata (but i just use from original NAV Standard)
    but for table 2... i'm not quite understand about setdata and getdata
    anyway thanks for your help

Categories