Sorting on Formatted Date 







sort:concat(substring(d2,8,2),string-length(substring-before('XXXJANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC',substring(d2,4,3))) div 3,substring(d2,1,2));'ascending';data-type='Number'

Comments

Anonymous said…
Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!
Mon Jan 11, 09:33:00 AM 2010
Post a Comment

Popular posts from this blog

Configure Concurrent Reports to be run

In BI Publisher Standalone, How many concurrent reports can be run ? By default, it is set to 3. in-order to change it to 'N'. following change is required. 1. Go to Admin/Scheduler/quartz-config.properties 2. identify the line org.quartz.threadPool.threadCount=N 3. Change this to N, in order to concurrent no of reports to be run at a time.
Read more

Repeat Table Header in all pages in BIP

how to repeat the column titles on a table in all pages if the table extends over several pages What you need to is: 1. Select and Highlight the table header row 2. Right click and select table properties 3. On the Row tab properties , specify that the header row should be repeated on every page 4. Save the RTF 5. BIP looks at the properties of the word settings for the table and will repeat the header row on every page the table needs. This works so well in PDF output, but RTF output seeems to have some issue with this header repeat functionality We all can beleive, In future releases this bug won't be there ;)
Read more