How to create a one to many report?
Posted: Fri Sep 25, 2009 11:00 am
This is result I am trying to achive:
So basically my datasource has a one to many relationship in the database. My report is coming out like this:
I only want John's name to print once.
I tried messing with the Hierarchial band, child bands and can't get this to work. Is this possible?
Thanks!
Code: Select all
Name Departments
John IT
Human Resources
Cafeteria
Mary Administration
Mail Room
Code: Select all
John IT
John Human Resources
John Cafeteria
etc....
I tried messing with the Hierarchial band, child bands and can't get this to work. Is this possible?
Thanks!