Hi, I am trying to build a custom PDF report using Apex 5 report queries and report layout with XSL-FO layout. I am trying to use the shared components >> Report queries to build a query and download the XML file and style it using XSL FO. I found there is a restriction within the report query where when my query has more than 68 columns then the XML is spit out with empty values within the xml elements. if anyone else is facing this issue. is this a limitation in the current apex 5.0. you can use the below sample query to reproduce the issue.
select
1 column_1,
2 column_2,
3 column_3,
4 column_4,
5 column_5,
6 column_6,
7 column_7,
8 column_8,
9 column_9,
10 column_10,
11 column_11,
12 column_12,
13 column_13,
14 column_14,
15 column_15,
16 column_16,
17 column_17,
18 column_18,
19 column_19,
20 column_20,
21 column_21,
22 column_22,
23 column_23,
24 column_24,
25 column_25,
26 column_26,
27 column_27,
28 column_28,
29 column_29,
30 column_30,
31 column_31,
32 column_32,
33 column_33,
34 column_34,
35 column_35,
36 column_36,
37 column_37,
38 column_38,
39 column_39,
40 column_40,
41 column_41,
42 column_42,
43 column_43,
44 column_44,
45 column_45,
46 column_46,
47 column_47,
48 column_48,
49 column_49,
50 column_50,
51 column_51,
52 column_52,
53 column_53,
54 column_54,
55 column_55,
56 column_56,
57 column_57,
58 column_58,
59 column_59,
60 column_60,
61 column_61,
62 column_62,
63 column_63,
64 column_64,
65 column_65,
66 column_66,
67 column_67,
68 column_68,
69 column_69,
70 column_70 from dual