Grouping in BIP :)



Another query from Netherlands user Mr."Remco"
He was trying to create template which he wanted to have group-left of one column,
i gave him another solution of re-grouping again,

?for-each-group:ROW[(_saw_0_='Realisatie EHS')]; _saw_0_?
?_saw_0_?

?for-each-group:current-group()[ (_saw_2_='n.v.t.')]; _saw_1_?
?_saw_1_? - ?_saw_3_? - ?sum(current-group()/_saw_4_[.!=’’])?
?end for-each-group?

?end for-each-group?

he could have used that in table in table , so that it would have solved it neatly.

But he was not ready to add another table.
He wanted to do that in single table itself.

n a single table we can do it,
but we have to first find , how many rows it will be there in the group,
then divide them by 2 and get the ceil of that number.
then add a if condition checking for position of the row = this number. if so , display the value you want to display.

?xdoxslt:set_variable($_XDOCTX, 'TYTEST', (count(xdoxslt:distinct_values(/ROWSET/ROW[(_saw_0_='Realisatie EHS') and (_saw_2_='n.v.t.')]/_saw_1_))))?

then
?if:xdoxslt:get_variable($_XDOCTX,'TYTEST')=position()? ?_saw_0_? ?end if?

you can display it at last row by using this.
you can position that in first row or any other place by building the logic accordingly.

Comments

Anonymous said…
Haha thanks again ;)
Fri Dec 21, 11:43:00 AM 2007
Anonymous said…

Dünyanın en güzel ve en yeni sex videolarını hd porno izle formatında izleme şansını sunuyoruz
Sat Jan 25, 06:58:00 PM 2020
Post a Comment

Popular posts from this blog

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

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

Limit rows per page

Image
Solution to have fixed number of rows in each page. This solution is not a perfect solution considering the line size increases due to text in each line. But this solution gives you how to fix no of rows per page. In the forum Heated discussion Users are arguing for having a placeholder in same fixed place on all pages, irrespective of no of lines , increased line size due to word-wrap. Here i am not going to discuss anything related to that. But a simple logic of , how to fix number of rows. Step 1: Loop through the records and display them Step 2: Have a condition for MOD of position(), then insert a page-break on the result of Zero Step 3. Blank row has to be filled, a condition has to be added, to find how many blank rows ROWLIMIT - (count of row mod ROWLIMIT) will gives us the rows to be filled. Step 4: use foreach_number function to simulate the iteration. Refer the images below
Read more