Γ Create a new report ‘Emp_GrpBy_Function’. (Refer Section 4 for detailed steps for creating the Report)
Γ Using Query builder generate the below query.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMlB2YU-JJG1YoA7ltw6gckSiq_ppM1G-Tc9_W427rYrd31cCvdufCYso_vP0P1aodOcdw4OqBmnPdthA8ZghKZb81SOnazzMAzdNxqzr8vhShLsI6G3WXpSB8IHgbyngplwLeihIGJAs/s320/clip_image002-732412.jpg)
Γ Now save the work done.
Γ Using Query builder generate the below query.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMlB2YU-JJG1YoA7ltw6gckSiq_ppM1G-Tc9_W427rYrd31cCvdufCYso_vP0P1aodOcdw4OqBmnPdthA8ZghKZb81SOnazzMAzdNxqzr8vhShLsI6G3WXpSB8IHgbyngplwLeihIGJAs/s320/clip_image002-732412.jpg)
Γ Now save the work done.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0_iy4E7vcaUvmqu64f02eHrCtz1wv4kUC9WI-y8j4O_xNo47uJ84sYg2bjRFZ4EeGrmph9aU_ejP4dq1VHmKqO-N7zKLd21132nbZRIWPFkYQpj30l-HAWD8XZgPCEoAPtnq_m-vl3ag/s320/clip_image004-734442.jpg)
- Creating a Layout
- Creating a RTF Template
Γ Create a new template using Microsoft word (Refer section 4.3 for detailed steps for creating the Template).
Γ Select the table for which the template is going to created i.e. ‘Emp_GrpBy_Function’.
Γ Using Table Wizard create a template as shown below.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjig1j6GTP9-AqK92hfjRyHGyQ7eFK5ZD5Vqxrzj21F9moSskMNCWSp-FX939-a19n-aDsuw_EdqecgQsPJsa_8tGaeqXR0aQw-fEmlGqwXoUKLddqzMQAkYQ58xE6P8msYu_6TKDmeCA/s400/clip_image010-740551.jpg)
Γ After formatting the template as explained in section 4.3 , the final template will look as below.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinOMo_t5Z7Hb9T-6xNdUXHoIP9kCmCb-StJuvsAo1dHr3M32l5JXrZvhoInfdBu_F3S3WPnvDgtlCnkiX7Dx4ZTjc3LOEU3EPIdITHkTJ9-kYZRhvCzgsMBw1MyLFCEUadD7FpvZ0qeOc/s400/clip_image012-742412.jpg)
- Uploading the RTF Template
Γ Now upload the template created by using the option ‘Browse and upload’ in BI Publisher.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEgoXuckz_Ov7fc22XhjInV-RyhV8nQ6ieMSu0I4qTN9z2zRqS2aFMMD1Urqx90tLT6R0bvhAn4rNzUgJxVKMoDxO2lFiyCkmVpaUWUVU0S17HKHsh2vizFZTXfYwmNf6WCO6RRc7afro/s320/clip_image014-744482.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi45LaPLfw_UcxhUfQrK9RRomd4Gyt9pyIvkrCyvC6DZjKT7ZfjW7pBi3W_nMPLsU0Mq4AfKv832LDC1hCGFUrL6IxVK9_4-VKw85wKgGEVZnUIR6LGZfKZ0zOO19avbNg6tW6USgxqcwE/s400/clip_image016-746464.jpg)
Γ Save the changes.
- Viewing the Output
Comments
Post a Comment