index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Master-Detail Report not working :: (2)Post a New Message | Post a Reply
Feb 21 2005, 7:43 PM
 Master-Detail Report not workingPost a Reply
 digitald2

View this author's profile Send this author a private message

since: Feb 21, 2005
from: Hawaii

I have 2 tables SVSLS and COEMP.  SVSLS has all the detail about the service we have done on each Repair Order.  This table only has the Employee ID or the person who sold the service.  The other table COEMP has the employee ID and the Employee Name.

I am trying to create a drill down report that show our service advisors and when you click on them, it show all the repair orders done by them.

The issue I have is that it shows some of the service advisors multiple times?  I can't figure out why?  In the Join area I put [COEMP].[EmpId]=[SVSLS].[EmpId].

I also set COEMP as the master table.  It still shows multiple Employee (service advisors) of the same Id and name?!

Help.

Thanks,

Feb 22 2005, 12:18 PM
 Re: Master-Detail Report not workingPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Can you please send us some sample data or url so that we can test this bug!



-------------------------
Ghost
Pages: (1)   [1]

search this forum: