Set a line under every Data in Master-Detail
I want following:
I have a user list (UserDataList) and Departentlist (AllUsersToDepartmentList). I create a Master-Band for "UserDataList" and put name und firstname on my report. Then I add a Detail-Band for "AllUsersToDepartmentList" and connected with UserDataList.UserId to AllUsersToDepartmentList.UserId.
My report works fine - until here.
Now I want to add a line under every User/Department-List.
USER1
DEPT1
DEPT2
---------------------
USER2
DEPT1
DEPT2
-----------------------
But i dont find the rigt soultion. If i put a Child on the Master, then the line is beetwen user and departments
If a make footer on Detail, then it only print, when Details are available
This discussion has been closed.
Comments
Hello!
To ensure that the separator line is always displayed exactly once after the ‘User + all their departments’ block, even if the user has 0 records in the departments table (Detail), do the following:
On the parent DataBand (UserDataList), set the PrintIfDetailEmpty property to true.
Place the separator line not in the DataFooter of the departments table, but in a child DataBand (set to 1 blank row / DataSource = null, positioned on the same level after the Detail band within UserDataList) or wrap UserDataList in a GroupHeader + GroupFooter by UserId and place the line in the GroupFooter.
This ensures that the separator line is printed after each user and all their departments (or immediately after the user if there are no departments).