hi serinor

the query you sent did exactly what i needed, and now i can continue with my work cause that was holding me up.

thanks again and all of you guys...

my id is unique value... what other possible ways there could be.

i tried this approach:

SELECT Depreciation.Depreciation, Depreciation.TransactionID,Depreciation.Depreciation +

coalesce

(

(

select sum(Dep.Depreciation) from Depreciation Dep

where Dep.TransactionID < Depreciation.TransactionID

)

, 0)...

thanks Ken, will work on it now and see if it's works

thanks again

thanks for the input, though in my case i'm using a dropdown which has a list of 289 records a user has to select from but when populating not...

hi

i wonder if you could help me with this one, i'm going nuts here cause i can't seem to figure out where the problem is:

i have a report with parameter...

hi guys

thanks for the responses and references it's helped and i've started using crystal and yes it's a pain working with formulas when you have to create grandtotals by i...

hi

i need a favour i'm struggling to get a correct value out of my table:

AssetID AssetCodePcodeDepIDStaValue

6370IT_INFR 1006102421953.43

6370IT_INFR ...

thanks for the input, i'll sure give it a go....... can you give me any links where i can get reference books??

thank you sooooooo much nigel.c.west, the listbox did exactly what i wanted, it really helped and now i'm able to run my report the way i want.

thanks again

sorry jack for not giving you the complete info.........

and thankz for giving me the lead, but i don't think i follow though but i'm gonna try and do as you...

thankx Jack for responding so quick

the thing is the format of my report is different from the normal layout,

i'm displaying the property information here's the layout of my report

my...

hi guyz i have a problem a bit similar to the post by sing4you... i created a report with two tables using one dataset and in my query i have...

hi guys you were such a great help, my package works like charm

thankx

the SchemeID fiels is and interger field

hi guys thanks for help, i've added the condintional splits my only problem now what is the expression to check for null or empty values against in my ID field...