Skip to Content
0
Former Member
Feb 25, 2009 at 11:28 AM

crystal reports problem

21 Views

Hi,

My query is thus,

I have two database tables linked together by a single field called 'ID'. In the design view in the details section I have placed a few fields from the first table(table1) and a field from the second table(table2). However, since there can be many second tables for each first table (one-to-many relationship), the ID's that I placed in the details section are repeated more than once.

i.e

ID magoo

== =====

356 yes

356 no

356 maybe

356 yes

21 no

21 no

21 maybe

How can I get it so that just one ID of whichever number is displayed?

ie (like this)

ID

==

356

21

...

...and so on

I also have a bar chart set up that is based on some of the values displayed in the table. I have total values displayed at the top of each bar on the chart.

when there isnt a field from table2 in the details section, the values on the bars in the chart would be:

4, 7, 6, 3, 5

but when i do place a field from table2 in the details section, the values on the bars in the chart would be:

9, 16, 12,9,11.

Cheers,

J