Parameter fields and Formulas

[dnboughton]

I'm using CR 8.0 and have a report with a formula @directrate, Sum ({LABTRANS.REGULARHRS})/Total Available Hours*100.

I want to create a datetime range parameter field and have the formula update the Total Available Hours value in the formula above based on the parameter's datetime range value chosen.

How can I easily accomplish this?

Thanks
Deana

 

[Turkbear]

Hi,
It would seem that you could create a formula
@TotalAvaiableHours
and set its value based on your parameters ( without knowing how you compute these I cannot be specific)..

Use that formula in your original one
Sum ({LABTRANS.REGULARHRS})/@TotalAvaiableHours
*100. ( or do the *100 in the @TotalAvaiableHours
formula)







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[mujahads]

I have from date and to date fields (data type "date") in vb6 form thru access 2000 database, I want to use in crystal reports 8.5 as parameter field.

How can I pass the parameter value from vb to CR.

Please give me details with code.

thanks in advance.

Abdul Haq

 

[dnboughton]

Thank you TurkBear I was able to achieve my request.