AnsweredAssumed Answered

Sub-Summary issue?

Question asked by davidallen on Jan 23, 2012
Latest reply on Jan 26, 2012 by davidallen

Hi everyone, thanks for the help for my last issue.

Guess what, I have another.

 

I am trying to build a report that will list multipule items for an employee.

My desired report should look like this:

 

---------

Department A:

Employee Name, Employee Number, License, License Expiration Date

License, License Expiraton Date

etc (if applicable)

 

Employee Name, Employee Number, License, License Expiration Date

License, License Expiraton Date

etc (if applicable)

 

Department B:

Employee Name, Employee Number, License, License Expiration Date

License, License Expiraton Date

etc (if applicable)

----------

 

The department name, employee name and number are on my main table,

the License info is in Credentialing Table. The two are related by Employee Number.

 

Issue:

Some employees have multipule licenses, some have none.

I need to have the report show ALL licenses for those that have them, and then sort by date.

 

I have tried using Sub-Summaries on the layout and in the script, to sort by department and employee,

but how can I get the Licenses to show up? Another Sub-Summary and sort doesn't do it.

Only one will show, how can I make that field repeat when there are more to display?

 

Help Please,

Thanks

Outcomes