+ Start a Discussion
Sourav PSourav P 

Report Building Issue while using the Cross filter

Hi,
I have the below report requirement,
- Below is the ways my objects are related , which have taken in teh report.
"Contract" is related to "Claim",
Claim to Damage
Damage to Payment 

Now , i want a report of the records, where the Payment in Damage object is not present. I tried the below filter but its not giving the proper result, If anyone suggest plz, where i went wrong. Thnx

User-added image
Best Answer chosen by Sourav P
RD@SFRD@SF
Hi Sourav,

Try creating a new report type and and create a report of that type. You would be able to set the new report type such that you get the records where all the payment information is present.

Please follow the link (https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=12&ved=0ahUKEwjF14m-4rjWAhUlSY8KHQJ2BmQQFghfMAs&url=https%3A%2F%2Fhelp.salesforce.com%2FHTViewHelpDoc%3Fid%3Dreports_defining_report_types.htm&usg=AFQjCNE5x0gj-pS_QgxwLzJJBv-DBJHCvA)for the salesforce reference

Hope it helps
RD

All Answers

Sourav PSourav P
sorry, where all the payment records are present. ( Dont want the contract records where payment in the Damage are not present). Thnx
RD@SFRD@SF
Hi Sourav,

Try creating a new report type and and create a report of that type. You would be able to set the new report type such that you get the records where all the payment information is present.

Please follow the link (https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=12&ved=0ahUKEwjF14m-4rjWAhUlSY8KHQJ2BmQQFghfMAs&url=https%3A%2F%2Fhelp.salesforce.com%2FHTViewHelpDoc%3Fid%3Dreports_defining_report_types.htm&usg=AFQjCNE5x0gj-pS_QgxwLzJJBv-DBJHCvA)for the salesforce reference

Hope it helps
RD
This was selected as the best answer
Sourav PSourav P
Thanks RD, It helped.