✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com

Trends

Friday, 22 September 2017


Creating a RTF Template for building Pivot Table in BI Publisher


By on September 22, 2017




Create a new template design to view details in Pie Chart.

(If not already opened) Open the BI Publisher report or else log in to BI Publisher.

In MS Word, select the BI Publisher> Open Template option. Open the report from the path My Folders>BI_Publisher_LabGuide.

In the Word document that loads this report, select Insert> Cross Tab on the BI Publisher toolbar to define a format for the table data in the query.






Drag and drop the Row values into the Layout region as shown below and click OK. 




The created template looks like as shown below: 




Change the word properties for all fields by double clicking on the field.

Change the aggregate function in the code from sum to count.

Click on the Properties tab and change the format and click OK.






Similarly change the properties for every field.

Include headers and footers as shown below.




After making the necessary changes, upload the template. 






View the output in different formats. 



Kashif
mkashu: Creating a RTF Template for building Pivot Table in BI Publisher
Review : Kashif | Kashif
Update: September 22, 2017 | Rating: 4.5

Comment for "Creating a RTF Template for building Pivot Table in BI Publisher"

0 comments

Post a Comment

Blog Archive

Labels