Grouping problem in RTC reports

Comments

• Options

  Troubles_In_Paradise Member Posts: 588

  2011-06-30

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

  0
• Options

  Belias Member Posts: 2,998

  2011-06-30

  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

  0
• Options

  julkifli33 Member Posts: 1,073

  2011-06-30

  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?

  0
• Options

  Belias Member Posts: 2,998

  2011-06-30

  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

  0
• Options

  julkifli33 Member Posts: 1,073

  2011-06-30

  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

  0