Hi, When you ran the query for particular supplier or party, whether the phone no displaying in you sql dev or toad ? Thanks & Regards Srikkanth M

Hi, 1.So in your xml tag, the phone no is coming and its displaying not displaying in output ? 2.Use the HZ Contact Point table, Check this query.. SELECT DISTINCT hcas.cust_acct_site_id cust_acct_site_id, h_contact.party_id contact_id, h_contact.party_name contact_name, hp.party_id party_id, hp.party_name party_name,…

Hi, Just check if there any syntax error with RTF first. Else take the xml from the program output and load it into rtf manually from desktop and check if any syntax error from local. Regards Srikkanth

Hi, could you please share the bursting control file if possible. Thanks & Regards Sri

Hi, Assume that you have hardcoded the product number in the query, Please try with If else statement in the RTF template. Thanks & Regards Sri

Hi, Hope you are working with cross tab matrix report, if correct only three columns should be in your query. Then only you can able to get the expected result. Here with I have attached the sample report for your reference. Thanks & Regards Srikkanth M