You can use table wizard to give more dynamic report as indicated.

1. Select the Table Wizard from BI Publisher tab.

   Figure 5-32 AddingDynamics to Report 1

   
   

   
   Description of "Figure 5-32 AddingDynamics to Report 1"

   
   
2. Select the Table and press Next.

   Figure 5-33 Adding Dynamics to Report 2

   
   

   
   Description of "Figure 5-33 Adding Dynamics to Report 2"

   
   
3. Use the same Data SET.

   Figure 5-34 Adding Dynamics to Report 3

   
   

   
   Description of "Figure 5-34 Adding Dynamics to Report 3"

   
   
4. Select all the fields and press Next.
5. You can create the group as follows:

   Figure 5-35 Adding Dynamics to Report 4

   
   

   
   Description of "Figure 5-35 Adding Dynamics to Report 4"

   
   
6. Click Next. You can give the sorting option as indicated.

   Figure 5-36 Adding Dynamics to Report 5

   
   

   
   Description of "Figure 5-36 Adding Dynamics to Report 5"

   
   
7. Click Next. The wizard creates the layout as indicated.

   Figure 5-37 Adding Dynamics to Report 6

   
   

   
   Description of "Figure 5-37 Adding Dynamics to Report 6"

   
   
8. You can add, modify static Text, logo in the layout and Save the layout with the same name of datamodel or report.

   Figure 5-38 Adding Dynamics to Report 7

   
   

   
   Description of "Figure 5-38 Adding Dynamics to Report 7"

   
   
9. Preview of the report layout is as indicated.

   Figure 5-39 Adding Dynamics to Report 8

   
   

   
   Description of "Figure 5-39 Adding Dynamics to Report 8"