hello,
I have create a report (DSMAIN) that could pre-filtering accounts (DSAccount) and contacts (DSContact)(picklist) (by using parameters)
SELECT FilteredAccount.name, FilteredContact.lastname |
FROM FilteredAccount INNER JOIN |
FilteredContact ON FilteredAccount.name = FilteredContact.parentcustomeridname |
WHERE (FilteredAccount.name = @parentcustomeridname) AND (FilteredContact.lastname = @lastname) |
works fine, but all contacts display if a account is chosen. only the related contacts to this account should display.
ive try something with CRM_ but it doesnt work. can it be done with stored procedures? anyone got a solution for me? thanks