Hi,
I am newbie for Birt but a experienced database application
developer in desktop based Client server database applications.
I am using Flex PHP stack for web application development
and have chosen Birt as reporting engine in my first web application
which is actually a port of existing desktop C/S database application.
I could successfully create simple list based reports easily with birt
and quite happy with its ease and simplicity. For Reprt data comes
from PHP as XML output, very convenient. Now I am stuck with
master/detail kind of report and need help with it.
The output PHP generated as XML is enclosed at end for reference.
The structure of data is as follows
<root>
<PO>
<--- PO elements --->
<PoItems>
<poitem>
<-- PO Item elements -->
<Poitem/>
Variable Number Of items per PO
<PoItems/>
<PO/>
<PO>
<--- PO elements --->
<PoItems>
<poitem>
<-- PO Item elements -->
<Poitem/>
Variable Number Of items per PO
<PoItems/>
<PO/>
multiple PO objects
<root/>
What I want to print is as follows
Report header such as "List of Pending POs"
PO elements of PO object in one or multiple lines
POItem elements in One or multiple lines
POItem elements in One or multiple lines
POItem elements in One or multiple lines ...
PO details in one or multiple lines
POItem elements in One or multiple lines
POItem elements in One or multiple lines
POItem elements in One or multiple lines ...
PO - Purchase Order
POItem - Purchase Order Item
Thanks and Best Regards
Raja
The sample XML data as Follows i have included only Two Pos
but actually they can be of tune 1000 to 5000
<root>
<VOPurchaseOrder>
<poNo>1</poNo>
<name>R. S. Patil</name>
<address>asdasdad</address>
<state/>
<eMailId>kpr.rspatil@xxxxxxxx</eMailId>
<phoneNos>saadasdasd</phoneNos>
<region>0</region>
<basePrice>319.98</basePrice>
<taxRate>4.00</taxRate>
<taxes>12.80</taxes>
<shippingCharge>50.00</shippingCharge>
<totalAmount>382.78</totalAmount>
<array_items>
<VOPOItemRef>
<sr_no>1</sr_no>
<item_cd>4</item_cd>
<name>Nokia 3120</name>
<description>
Designed for both business and pleasure, the elegant Nokia 3120 phone offers a pleasing mix of features. Enclosed within its chic, compact body, you will discover the benefits of tri-band compatibility, a color screen, MMS, XHTML browsing, cheerful screensavers, and much more.
</description>
<price>159.99</price>
<image>assets/pic/Nokia_3120.gif</image>
<series>3000</series>
<triband>1</triband>
<camera/>
<video/>
<highlight1>Multimedia messaging</highlight1>
<highlight2>Animated screensavers</highlight2>
<orderqty>1.000</orderqty>
<orderrate>159.99</orderrate>
<orderamt>159.99</orderamt>
<_explicitType>VOPOItemRef</_explicitType>
</VOPOItemRef>
<VOPOItemRef>
<sr_no>2</sr_no>
<item_cd>5</item_cd>
<name>Nokia 3220</name>
<description>
The Nokia 3220 phone is a fresh new cut on some familiar ideas - animate your MMS messages with cute characters, see the music with lights that flash in time with your ringing tone, download wallpapers and screensavers with matching color schemes for the interface.
</description>
<price>159.99</price>
<image>assets/pic/Nokia_3220.gif</image>
<series>3000</series>
<triband/>
<camera>1</camera>
<video/>
<highlight1>MIDI tones</highlight1>
<highlight2>Cut-out covers</highlight2>
<orderqty>1.000</orderqty>
<orderrate>159.99</orderrate>
<orderamt>159.99</orderamt>
<_explicitType>VOPOItemRef</_explicitType>
</VOPOItemRef>
</array_items>
<_explicitType>VOPurchaseOrder</_explicitType>
</VOPurchaseOrder>
<VOPurchaseOrder>
<poNo>2</poNo>
<name>Sunil Kulkarni</name>
<address>Nagala Park Kolhapur</address>
<state/>
<eMailId>sunil_K@xxxxxxxx</eMailId>
<phoneNos>0233-3456789</phoneNos>
<region>2</region>
<basePrice>1867.97</basePrice>
<taxRate>8.65</taxRate>
<taxes>161.58</taxes>
<shippingCharge>100.00</shippingCharge>
<totalAmount>2129.55</totalAmount>
<array_items>
<VOPOItemRef>
<sr_no>1</sr_no>
<item_cd>9</item_cd>
<name>Nokia 6620</name>
<description>
Shoot a basket. Shoot a movie. Video phones from Nokia... the perfect way to save and share life’s playful moments. Feel connected.
</description>
<price>329.99</price>
<image>assets/pic/Nokia_6620.gif</image>
<series>6000</series>
<triband/>
<camera>1</camera>
<video>1</video>
<highlight1>Bluetooth technology</highlight1>
<highlight2>Up to 10 minutes video</highlight2>
<orderqty>3.000</orderqty>
<orderrate>329.99</orderrate>
<orderamt>989.97</orderamt>
<_explicitType>VOPOItemRef</_explicitType>
</VOPOItemRef>
<VOPOItemRef>
<sr_no>2</sr_no>
<item_cd>11</item_cd>
<name>Nokia 3230 Bronze</name>
<description>
Get creative with the Nokia 3230 smartphone. Create your own ringing tones, print your mobile images, play multiplayer games over a wireless Bluetooth connection, and browse HTML and xHTML Web pages. Plus, with a 32 MB MMC card and expandable memory, you'll have lots of space to be creative.
</description>
<price>369.00</price>
<image>assets/pic/Nokia_3230_bronze.gif</image>
<series>3000</series>
<triband/>
<camera>1</camera>
<video>1</video>
<highlight1>1.3 megapixel</highlight1>
<highlight2>Expandable memory</highlight2>
<orderqty>1.000</orderqty>
<orderrate>369.00</orderrate>
<orderamt>369.00</orderamt>
<_explicitType>VOPOItemRef</_explicitType>
</VOPOItemRef>
</VOPurchaseOrder>
</root>
