logic in BLS

[Former Member]

Hi ALL,

I am working on real time scenario, where i have retreive the records do some lgic and show it in chart format.

Here there are many products details with quantity and date values.

i have to apply a different formula based on the product for each row and obtain the result. All the results obtained should be added based on date and divided by 3. This is the result for a particular day.

Like this i have to calculate for all the days and form a chart out of it.

I created a query template and cofigured to the bls sql query block. i created a xml document and a repeater to loop the number of rows.

I got struck updoing the transaction after parsing the resultset. Please help me out like how to the logic in bls.

[Former Member]

Hi

Within the loop (Repeater), use the <b>Calculation</b> action (under Misc Functions tab) to calculate the expected result using ur desired formula like adding, subtracting, dividing etc in the Expression in the Link Editor.

Finally the calculated result is mapped to the XML file output using <b>Row</b> action

Regards

Som

Please feel free to ask furthers if necessary

[Former Member]

Thanks

[Former Member]

Hi,

I am retreiving the data from database.