Community
Participate
Working Groups
Created attachment 225847 [details] Example My "Enhancement" proposal: to create a "display filter" in addition to the already existing filter (filtering inputs data) of the crosstab. This "Display filter" could let the birt user have, for example, 2 years data into his crosstab, but only display 1 year data. From my point of view, this functionality became mandatory as soon as the Relative Time Period functionality was integrated into the crosstab object. This proposal comes from a difficulty i faced while i was building a report. What i wanted to do in my report : display monthly the number of tickets resolved during last 12 months - Example: for 08/2012 to display the total number of demands resolved from 09/2011 to 08/2012. To do so i used relative time period aggregation, and it worked perfectly....but... I want to display 12 months in my crosstab, but to calculate my relative time period aggregation i need 24 months data ( example: if i want to display the period from 09/2012 to 10/2011 in my crosstab: to calculate the number of resolved demands during the last 12 months for the month of 10/2011, i will need data from 11/2011 to 10/2010)- See screen shot attached for better understanding of the obtained result. Usually to limit the number of months in a crosstab, i use the filter property of my crosstab. As i need 24 months, i extended the filtered period to 24 months...but as a consequence, 24 months are displayed in my table...i found some ways to hide the columns (using scripts or highlights and the property display:none), but : - display:none is not working into internet explorer - my report needs to be exported properly in PDF and with this "workaround" the result is not good(see screen shot).
