I have a DB that has as structure like this:
valLow
valHigh
valAvg
SectionName
ID
The sectionName field desribes different groups of expenses for each person (ie rent, taxes, etc.) and is a string (this is a compound primary key of ID and SectionName). I want the user to pick a person to view the report for, and then, in the details of the report, show the three values for each 'SectionName' for that person. There is also a lot of other data not grouped liek this which needs to be displayed. I just can't seem to get this to work. I am fairly new to Crystal Reports, so I may be missing something obvious. Thanks for any help.
valLow
valHigh
valAvg
SectionName
ID
The sectionName field desribes different groups of expenses for each person (ie rent, taxes, etc.) and is a string (this is a compound primary key of ID and SectionName). I want the user to pick a person to view the report for, and then, in the details of the report, show the three values for each 'SectionName' for that person. There is also a lot of other data not grouped liek this which needs to be displayed. I just can't seem to get this to work. I am fairly new to Crystal Reports, so I may be missing something obvious. Thanks for any help.