Hi Tia,
Use the code below,I have tested creating command object ,you can create a view or stored procedure in SQL
Select
New.Name,
New.Job,
Old.Job,
case when Old.Job = 'Sales Rep (old)' then
New.Actual * 2
end,
New.Quota,
New.Actual
from job New
left Join Job Old on New.Name = Old.Name AND old.Job = 'Sales Rep (old)'
The above Sql Joins the table to itself and calculates the actual in same row ...
This is the results in two rows as new old ,but it also calculates the actual
Once the report is generated you can suppress the details section
checking for
{table.job} = 'Sales Rep (old) '
this will display one row with the calculations .
let me know if it works,or you can post some more sample data to playaround....
Cheers
Rahul
IP Logged
