List Different Values of One Field In Detail Footer

[ed333]

If anyone can help me with this problem, I would be most appreciative. I have been working on a series of reports that are attorney bills. Each client can have more than one attorney work on a file(case). In the "Detail" Section, I must list each service performed for each file. I have arranged grouping levels in order to display the information correctly. However, in the detail footer, I need to be able to list which attornies worked on the file, along with a sum of the hours that each attorney contributed. When only one attorney contributes to a file, everything is fine. I cannot figure out how to get a line that reads (for example):

(MPC 5.5, DEL 7.25)


Any suggestions?

Thanks in advance,
Ed

 

[ed333]

Well, thanks, but I really was looking for a way to do this programmatically. Perhaps my first message wasn't clear enough. The grouping levels are client (displays client info), file (displays file info), and disbursement type (determines if AttorneyTime or Disbursement). In the detail under DisbursementType, I have conditionals that display appropriate info depending on type. All I need is a way to list the attorneys in the detail footer, along with their time totals, BUT ONLY IF DisbursementType = AttorneyTime. I had a similar problem a while back where I needed to carry down the total AttorneyTime and TotalDisbursements to the Client Footer. I used the On Format event for the Detail Section to run a VB sub that assigned a running total of each type to a global variable. I then made the globals the sources for two unbound text boxes in the Client footer. So far, though, I have been unable to modify this to work for listing the attorneys and their time. (We have about 12 attorneys at my firm.) Any thoughts?

 

[Rich]

As Pat suggested use a subreport, just set it's criteria to your condition

 

[ed333]

I have never used a subreport. Can I create one in the middle of my report and still retain my formatting? How do I do this, please?