Groups in the Report

[saran26]

Hi All,

I have a Defect table with milestones and issues as reference lists. The sample values are

for Defect ID 001,

Milestones 01
02
03
04

Issues
0001
0002

How to display both referece lists with out repeating them.

I tried GroupBy , it works fine for the first group,since i cannot place the second group out side the first one

it displays like this

001
Milestones 01
issue 0001
Milestones 02
issue 0002 etc, how to avoid this .

Please help me out.

Thanks
Saran

 

[lbass]

I can't tell what your fields are. Please show what several detail rows look like, labelling each field with table and field name.

-LB

 

[saran26]

Thanks LB, here it is ...


Table -- defect
fieldnames

id -- 001

MilestonesReflist

IssuesReflist


Table - MileStone

Fieldname - id -- 01
-- 02
-- 03
-- 04

Table - Issues

FieldName - id - 0001
- 0002
- 0003
- 0004

Let me know if you need more details
Thanks
Saran

 

[lbass]

That's not what I meant. If you place these fields in the detail section after linking the tables, how do they display?

-LB

 

[saran26]

Sorry about that...

This is what I did

I created a group for the milestonesid and then a group for issues id.

it displays like

Row 1 - milestonesid - 001
Row 2 - issue id - 0001
Row 3 - milestoneid - 002
Row 4 - issue id - 00002


If I place them on the detail section, then it prints the same value for the number of rows in the defect table.

Let me know if you need any more details.

Thanks
Saran

 

[lbass]

I meant without grouping.

-LB

 

[saran26]

OK. with out grouping if I place them in the detail section, then the values are getting repeated for how many rows returned from the defect table query.

example

001
001
001
001
001
001
001
001

002
002
002
002
rows from the milestones table and the rows from the issues table are repeated for 8 times.

Thanks
Saran

 

[lbass]

You have said you have three tables. How are they linked to each other? Or aren't they linked at all? I meant for you to place each field in the detail section so I could see how they repeat in relation to each other, but first please answer the linking question.

-LB

 

[saran26]

Hi LB,

Thanks for taking your time in resolving my issue.

The defect table has a reference list to the other two tables.The dbid from milestone table and the dbid of the issues table will be referenced in the defect table.

i.e , a defect record with id - 01 will have multiple values for milestones and issueslists.

example :

Defect record id - 01

will have dbid -123231
dbid -123232
dbid -123233 added to it for milestone


and dbid -222221
-222222
-222223 added to it for issues.

Let me know if you need more details
Thanks

Saran

 

[lbass]

Did you link the tables in the database expert? What fields are you linking on for each table? Please try to answer my specific questions.

-LB

 

[lbass]

I think you should just link one table (milestones) to the defect table, and then insert a group on defect ID. Then add the second table (Issues) in a subreport that is placed in the group footer and linked to the main report on the defect ID.

-LB

 

[saran26]

OK will try and let you know.

Thanks
Saran