Posts

Showing posts from October, 2009

sum total column in BIP pivot table

For long long time, wanted to document this , but missed in my list. In BIP 10.1.3.4 ++, new support was added to the crosstab and changed it to pivot table. In order to use this functionality, the server has to be in latest or above 10.1.3.4++. Reason: server support has been added to make it much better. How does it work. Forum question <?crosstab:c45;"//ROW";"CodPais{,o=a,t=t}";"Pais{,o=a,t=t}";"Hombre,Mujer";"sum"?> And use following in total, <?$c45//M0/M1/T?> == Hombre <?$c45//M0/M2/T?> == Mujer c45 -- refers to the name of the table R - refers to ROW C - refers to column o=a ==> order - ascending t=t ==> datatype = text "sum" ==> specifies the summary, you can use count, sum etc... $c45//M0/M1/T - sum of Hombre element $c45//M0/M2/T - sum of Mujer element

PIE chart - Explode slice

In the pie chart, how to seperate the slices. if there is a support to for a way to separate the slices in pie chart was the question in the forum. Answer to this is a big YES :) In order to "explode" pie slices, add the following lines in the "Graph Settings" under the graph element. <SeriesItems> <Series id="0" pieSliceExplode="100"/> <Series id="1" pieSliceExplode="100"/> <Series id="2" pieSliceExplode="100"/> <Series id="3" pieSliceExplode="100"/> </SeriesItems> <Graph ...... pieDepth="25" pieTilt="25" ....> add this to your graph element attribute , to tilt the pie slices

Custom Scalefactor

By default the Y or X -axis scale in my graph reads as 0K, 20K, 40K... How to modify the scale to read 10000, 20000... or in some other custom formats? <Y1Axis> <ViewFormat scaleFactorUsed="true" scaleFactor="SCALEFACTOR_NONE" /> </Y1Axis> Attribute scale factor can take one of the following values. SCALEFACTOR_THOUSANDS | SCALEFACTOR_MILLIONS | SCALEFACTOR_BILLIONS | SCALEFACTOR_TRILLIONS | SCALEFACTOR_QUADRILLIONS

Power of Inlines

Image
How to add the looping element in same line - horizontally ? use @inlines command,in conjunction with for-each. Here is the sample on how to do.

subtemplating

Image
Have a look at this, just adding sub template and calling them based on the concurrent program parameter. <?param@begin:ReportType;string(‘YS’)?> <?choose:?> <?when: $ReportType =’YES’?> <?call:TC1?> <?end when?> <?when: $ReportType =’NO’?> <?call:TC2?> <?end when?> <?otherwise:?> <?call:TC2?> <?end otherwise?> <?end choose?> Run with ReportType as NO or other than YES. You should get the result as follows Run with ReportType YES. You should get the result as follows

Avery label Print Template

Image
How to create label using Avery template ? Here it is use the following xml <Root> <Row> <Code>001</Code> <Part>100</Part> <Id>01</Id> <Supplier>K0G</Supplier> </Row> <Row> <Code>002</Code> <Part>100</Part> <Id>01</Id> <Supplier>K0G</Supplier> </Row> <Row> <Code>003</Code> <Part>100</Part> <Id>01</Id> <Supplier>K0G</Supplier> </Row> <Row> <Code>004</Code> <Part>100</Part> <Id>01</Id> <Supplier>K0G</Supplier> </Row> <Row> <Code>005</Code> <Part>100</Part> <Id>01</Id> <Supplier>K0G</Supplier> </Row> <Row> <Code>006</Code> <Part>100</Part> <Id>01</Id> <Supplier>K0G</Supplier> </Row> <Row> <Code>007</Code> <Pa