Hello all
We are trying to manipulate table data using math operation. As part of populating the report we are using sql macro to capture the data as follows
{sql:datasource=TestRO|table=false} DECLARE @kloc_total float DECLARE @var1 float select @kloc_total = total from ##kloc select @kloc_total/1000{sql}
We want to capture the above result to a varible and use the variable in java script further manipulate the result before rendering back to the page.
Manipulation we are trying to make is doing some math on the result in the form of multiplication.
Can anybody point me in the right direction how this can achieved.
Thanks
Ravi.
Thanks Bob
Based on your other comments on different issues i have used replace-and-render macro to get this working.
Thanks
Ravi.
Generally speaking it is best to just let your SQL query do the math for you and if necessary, add some sql functions to your database to make it easier. A simple example would be:
select sum(kloc)/1000 from klocTable
You can also use a groovy or other script to manipulate the results (How to generate choice values using SQL shows some techniques in this area), but normally not needed if you have someone with sql skills.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.