Good day.When trying to build a report, it gives an error:"Report design not valid : 1. Field not found : start_time 2. Field not found : created_time 3. Field not found : callee_login_id 4. Field not found : fcr 5. Field not found : nps 6. Field not found : in_service_level 7. Field not found : service_name 8. Field not found : disposition 9. Field not found : comment_url" <![CDATA[select a.global_interaction_id, b.start_time, a.created_time,b.callee_login_id,b.from_phone, a.fcr, a.nps,a.cs, b.in_service_level, b.original_destination_phone,b.service_name, b.disposition,a.comment_url from tsum_hostedcc_ru.surveys a inner join tsum_hostedcc_ru.call_detail b on a.global_interaction_id = b.global_interaction_id where b.media_type ='CHAT' and b.start_time >= $P{start_time} and b.start_time < < $P{end_time} group by b.service_name]]> </queryString> <field name="a.global_interaction_id" class="java.lang.Integer"/> <field name="b.start_time" class="java.sql.Timestamp"/> <field name="a.created_time" class="java.sql.Timestamp"/> <field name="b.callee_login_id" class="java.lang.String"/> <field name="from_phone" class="java.math.BigDecimal"/> <field name="a.fcr" class="java.lang.Integer"/> <field name="a.nps" class="java.lang.Integer"/> <field name="a.cs" class="java.lang.Integer"/> <field name="b.in_service_level" class="java.lang.Long"/> <field name="b.original_destination_phone" class="java.lang.String"/> <field name="b.service_name" class="java.lang.String"/> <field name="b.disposition" class="java.lang.String"/> <field name="a.comment_url" class="java.lang.Long"/> </subDataset>[/code]
