Skip to Content
May 10, 2017 at 03:33 AM

CrossTab Queries

381 Views Last edit Sep 01, 2017 at 02:00 PM 4 rev

I am using Crystal Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version CR Developer

I have certain queries w.r.t. cross-tab

a) When I export Cross-tab report to excel, then it doesn't exports borders of each row and column. How to get those?

b) If I want to merge two fields (e.g. Amount - USD) in one text box in column header, then how is it possible by using Concatenation function in formula?

c) What happens if the field is null? Will I be able to display "X" if value is returning Null?

d) How to suppress null rows