BI Publisher - Bursting issue after converting rtf template to excel template
Existing process creates one xml file with 2 .rtf templates that creates excel output. Bursting template takes the one XML file --- and based on a field in the xml, creates 2 files (ADDITIONS or UPDATES). Both of these two files have 4 rows per 'Award Number', with each row containing different Award information.
From the same bursting template, a third file is created that uses only 'ADDITIONS' and only selects 1 'Award' row out of the 4 to create 'AWARD_NUMBERS' file. This selection of only 1 award number happens in the layout template (rtf) of the third file, using an IF statement.
We have converted the .rtf layout templates to EXCEL layout templates. The bursting command that creates the ADDITIONS and UPDATES files is working as before. However, I am unable to filter out only 1 of the 4 rows for the third burst file. The third file (AWARD_NUMBERS) is being created, but it has all 4 rows for each Award Number, and it needs only 1.