Access-Crystal Report

[medel]

Hello,

I am facing problem on my access report, now im thinking maybe if i use
crystal report my problem "might" be solved. my problem is i created a
formula inside the Access Report and within that formula i need to get the
grand total of that, i am able to display the result of that formula except
the grand total as my formula seems to be very complicated.


now my question is, is it possible to run crystal report viewer and the
viewer will ask me for values of date1 and date2? i am not using any
programming software such as VB. only crystal report viewer and msaccess.


thanks.

 

[boblarson]

I don't think using Crystal Reports is going to help you all that much.

For your grand total, you need to put a text box in your Report Footer and
include the entire formula in the Sum formula:

=Sum(YourEntireFormulaHere)

for example:

=Sum(([Field1]*[Field2])/(([Field1]*.01)*([Field2]/2.33)))
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com

__________________________________

 

[medel]

Sir,

Thank you for your interest in helping me, using MSAccess only, I tried your
suggestion but i got an error Cannot have aggregate function in
expression(Sum((IIF ...

any more help please? I've tried placing my formula by creating a new field
expression in Query tab; as follows

FoodQ: IIf([Food]>0,[Food]/[Expr2]/8*[SumOfNormal])
NormalHrs: IIf([SumOfNormal]<>Max([SumOfNormal]),FoodQ,[Food])
Food1: IIf([Date of Joining] Between [Forms]![Salary Calculation]![Text0]
And [Forms]![Salary Calculation]![Text2],[Food],NormalHrs)

But I got an error

Circular reference by FoodQ

I don't think using Crystal Reports is going to help you all that much.

For your grand total, you need to put a text box in your Report Footer and
include the entire formula in the Sum formula:

=Sum(YourEntireFormulaHere)

for example:

=Sum(([Field1]*[Field2])/(([Field1]*.01)*([Field2]/2.33)))
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com

__________________________________

Hello,

I am facing problem on my access report, now im thinking maybe if i use
crystal report my problem "might" be solved. my problem is i created a
formula inside the Access Report and within that formula i need to get the
grand total of that, i am able to display the result of that formula except
the grand total as my formula seems to be very complicated.


now my question is, is it possible to run crystal report viewer and the
viewer will ask me for values of date1 and date2? i am not using any
programming software such as VB. only crystal report viewer and msaccess.


thanks.

 

[medel]

any help please?

Sir,

Thank you for your interest in helping me, using MSAccess only, I tried your
suggestion but i got an error Cannot have aggregate function in
expression(Sum((IIF ...

any more help please? I've tried placing my formula by creating a new field
expression in Query tab; as follows

FoodQ: IIf([Food]>0,[Food]/[Expr2]/8*[SumOfNormal])
NormalHrs: IIf([SumOfNormal]<>Max([SumOfNormal]),FoodQ,[Food])
Food1: IIf([Date of Joining] Between [Forms]![Salary Calculation]![Text0]
And [Forms]![Salary Calculation]![Text2],[Food],NormalHrs)

But I got an error

Circular reference by FoodQ

I don't think using Crystal Reports is going to help you all that much.

For your grand total, you need to put a text box in your Report Footer and
include the entire formula in the Sum formula:

=Sum(YourEntireFormulaHere)

for example:

=Sum(([Field1]*[Field2])/(([Field1]*.01)*([Field2]/2.33)))
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com

__________________________________

Hello,

I am facing problem on my access report, now im thinking maybe if i use
crystal report my problem "might" be solved. my problem is i created a
formula inside the Access Report and within that formula i need to get the
grand total of that, i am able to display the result of that formula except
the grand total as my formula seems to be very complicated.


now my question is, is it possible to run crystal report viewer and the
viewer will ask me for values of date1 and date2? i am not using any
programming software such as VB. only crystal report viewer and msaccess.


thanks.