Crosstab with data duplication!
27 July, 2015
Hi,
I have three data columns grouped by month and showed using sections (Section Style = "Tabbed").
Please see image 1 (expected scenario):
However, each section (years) process, the crosstab report duplicate my columns
Please see image 2 and 3 (the current scenario):
The more sections, more duplicate columns!
Detail: My report use one subquery and each column belongs to a query. The situation happens when I use data of the subquery
What is the reason of this? Error? Can I use "Sections" with "Crosstab"?
Regards,
Anderson
Yellowfin 7 - build 20150615
I have three data columns grouped by month and showed using sections (Section Style = "Tabbed").
Please see image 1 (expected scenario):
However, each section (years) process, the crosstab report duplicate my columns
Please see image 2 and 3 (the current scenario):
The more sections, more duplicate columns!
Detail: My report use one subquery and each column belongs to a query. The situation happens when I use data of the subquery
What is the reason of this? Error? Can I use "Sections" with "Crosstab"?
Regards,
Anderson
Yellowfin 7 - build 20150615
Hi! I think the problem is the subquery. I did the test without subqueries and it works. See the image below.
Anderson, can you try without subqueries?
Hi Arthur,
It is working fine now. The problem was solved.
Thanks for the prompt reply.
Regards,
Anderson
It is working fine now. The problem was solved.
Thanks for the prompt reply.
Regards,
Anderson