How to put group element on the header/footer?


Ex: there are four departments, each department have some employees.
Requirement:
1)Each department is on the header and the employees correspond that department is on the detail.
2)Each page display page number of the report on the footer.


Comments

Anonymous said…
How about when the employees in each department display over 1 page?
Thu Aug 14, 02:13:00 AM 2008
Vetriselvan said…
It doesn't matter,
data will span accross pages.. as you expected.
Thu Aug 14, 04:22:00 AM 2008
Unknown said…
what i want to display dept name in page header and each depart details on separat page ?

thanks.
Sun Mar 29, 05:52:00 AM 2009
Cecilia said…
Hello all,

I am very new in siebel CRM, hope you can give me the solutions about how to definning date parameter in .rtf, so that report could be upload in siebel BI publisher report.

I have the syntax like this (in .rtf that i build in microsoft word)

Header section:
?param@begin:START_DATE?
?format-date: START_DATE;’02-03-2011’,'DD-MM-YYYY'?

Body Section:
?StartDate;'DD-MM-YYYY'?
?for-each:Campaign[StartDate=$START_DATE]?

My goal is to filter data that the date= 02/03/2011 07:18:09
and my syntaxs above failed to filter...
I use Siebel 8.1.1.3 and BI Publisher Report 10.1.3.4

Do you familiar with the problem like above?there is some expert of .rtf here?please help me..

My other answer are:
1. In the for each section in .rtf is limited word, how we declare many parameter in there?
2. If i use group in .rtf then declare <@param...> then occured error when preview
3. How to declare syntax in group(if i want to filter group)
4. How to declare from & to date in for each, >=from date and <=to date in for each

Thank you in advance
Thu Feb 10, 05:03:00 PM 2011
Post a Comment

Popular posts from this blog

BIP Formatting

Image
Adding formatting is easier in BIP. It can be done manually or automated through menu. How to add the BIP formatting manually,  here is an example. Just add the logic and the formatting you needed. How to add the BIP formatting through menu,  here is an example. use the Menu and choose conditional formatting You have to select the data filed and choose the menu option conditional format
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

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