I have Prefereedemail,PreferredPhone, homephone, officephone,mobilephone, officeemail and home emails fields in a table.

I want to select only one phone and email from based on the  Prefereedemail and PreferredPhone in report definition source column.

Can somone please help me how to achieve this in 7.2. Thanks in advance

Source table coulmn names :

in the below 2 fields i have to display values based on Preferedemail and prepferedphone columns from the above  table.

Please advice me how to acgieve this using RD in 7.2

You could use Phone and Email in Edit columns section and in Filter conditions use Preferedemail and prepferedphone.

P.S: Provided screenshots are not visible.

Here a link to the FAQ document that you help! 

Product Support Community Frequently Asked Questions

Additionally, you could upload your image by adding it as an Attachment to your reply.

Hope this helps!

Regards,

Lochan  |  Community Moderator  |  Pegasystems Inc.

While what @Gangababu suggests is correct, it would be good to understand exactly what you are trying to achieve with this report.