General information
Category:
Reports & Report designer
Title:
How can I print 2 detail bands one after one
Environment versions
Network:
Windows 2008 Server
HI All
I want to print a report that displays all the patients for a doctor with the code of each patient's disease.
After this part I want to print a cumulative of each code of disease for patients of this doctor.
I have a table that contains all patients of the doctor and another that contains the cumulative codes, these two tables are linked by a relation with the medical code.
it look like this
First table Alias
Nom Med Code1 Code 2 Code 3
Mr xxxxx 123 8800 8802 8803
Mr. YYY 123 8800
Mr. AAA 123 8802 8804
Second Table
Med Code Qty
123 8800 2
123 8802 2
123 8803 1
How can i print the first table informatyion and after that the second one
I have Try to put the fields of the second table in the 2 second detail band and i have write the name of the second table in the taget Alias expression but the best i have got is something like this.
Mr xxxxx 123 8800 8802 8803
123 8800 2
123 8802 2
123 8803 1
Mr. YYY 123 8800
123 8800 2
123 8802 2
123 8803 1
Mr. AAA 123 8802 8804
123 8800 2
123 8802 2
123 8803 1
Can you help me
TIA
Ben.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only