Today I create my second report using group above and group left.
I also used sum function in this report.
First I loaded XML data as before.
My XML data structure is as follows:
My intention is to design a summary report of total sale by year and month.
Run Table Wizard as follows:
Follow the following steps in Wizard:
Once clicked the result will be as follows:
Now I deleted whole Table inside the inside second column of second row of main table.
Now it should look like as follows:
Now keep you cursor inside second column of second row of main table.
Now goto Choose Field menu as follows:
Choose options as follows and click “Insert” button:
Take care cursor should be at location 3.
Now you report format will look like as follows:
Before previewing my report I changed the second column title to “Total Sales”.
So the final format will be as follows:
Thats all, its done!
When look into preview it will look like as follows:
Now I am looking forward to my next report using “Condition Formating”!
4 responses so far ↓
1 muhammad imran // Jan 28, 2008 at 3:40 pm
good helping data if someone is working on BI Publisher.Please also share, if you do have same knowledge about Administration tool (BI Repository).
I would be really thank full if you can send me such type of learning material and your experience directly on my email address ()
thanks
imran
2 Rajender Singh // Jan 28, 2008 at 4:28 pm
Hi Imran,
First down load the BI Publisher Plugin for ms word.
When you will install it, the sample data (xml data) also will get installed with it.
Regards,
Rajender
3 muhammad imran // Jan 28, 2008 at 4:54 pm
yes……. i have installed BI Publisher as i am working on data warehouse.
but i am not currently working on BI Publisher what are the other functions of BI Publisher excluding reports development
thanks
imran
4 Rajender Singh // Feb 12, 2008 at 8:36 am
Hi Imran,
Actually its 100% report or data presentation.
Best thing about it is that separation of processing, presentation and tranformation layer.
you develop main dataset once, then it can be used in any number of format and can be transform to any file type i.e excel, pdf, xml and so on.
Regards
Rajender
Leave a Comment