Posts

Showing posts with the label RTF template

No data found

Image
No data found, dynamically based on the data in xml. here is the sample , if you have row, show the data in table. use count() function to identify whether the row exists or not. I just used this this function, but you can very well use any expression to evaluate this condition to be true.

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

E-Text Template

Image
How to generate E-text from Bi-Publisher ? 1. Generate XML using any method like sql,pl/sql,Datatemplate.... 2. Create a RTF template for the above generated XML 3. Deploy it. Generation of xml can be done using any one of the method, if its from Ebiz , then mostly the payment report would be the one , which requires EFT output. So, probably the concurrent program based on RDF is alreaddy generating the XML we wanted. I am gonna take a sample XML file and create the E-text rtf template for that. The Output of the report would be I would discuss different template format to generate the same EFT report in another post. wait for it :).

How to put group element on the header/footer?

Image
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.