Skip to Content
0
Former Member
Aug 28, 2007 at 02:35 PM

logic in BLS

32 Views

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.