How to group just one table? 1

[zhenyulu]

Hi, everyone.

Here is my dilemma..I have a CR 9 report with c#.net 2003. that I need to operate 4 tables in my report. The 4 tables are linked by the same ID field. What I want is just group the content of one table using another ID in that table. But the CR seems to group the 4 tables together.

What I need is:

section1: some fields in table1
section2: some fields in table2
section3: (only group in this section)
ID1 fileds for ID1 in table3
ID2 fileds for ID2 in table3
ID3 fileds for ID3 in table3
.......
section4: some fields in table4

But the report created by CR is:


Group ID1:
section1: some fields in table1
section2: some fields in table2
section3: (only group in this section)
ID1 fileds for ID1 in table3
.......
section4: some fields in table4

Group ID2:
section1: some fields in table1
section2: some fields in table2
section3: (only group in this section)
ID2 fileds for ID2 in table3
.......
section4: some fields in table4

Group ID3:
section1: some fields in table1
section2: some fields in table2
section3: (only group in this section)
ID3 fileds for ID3 in table3
.......
section4: some fields in table4
..................

Anyone have any ideas how I can make this easier?

Thanks for your help!

 

[Turkbear]

Hi,
Please only post in one forum..Most folks who frequent this one also frequent the other Business Objects forums..

Multiple postings can lead to confusing and incomplete answers..