Grouping problem in RTC reports

julkifli33

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

Troubles_In_Paradise

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".

Belias

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)

julkifli33

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

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)

julkifli33

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