Constantly refreshing reports !

[FoxG]

Hi,

Is anyone else aware of a quirk when using currentdate in the record selection formula. Every time I read a new page it prompts to refresh the report.

I seem to have found a solution!

Don't use currentdate in the record selection !!

Add a formula
BeforeReadingRecords;
currentdate

Then use this in the record selection formula.

If anyone else has come across this please let me know.

Best wishes,
Geoff

 

[kenhamady]

I have never seen that, what version?
Do you have subreports?
What was your selection formula? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[FoxG]

Hi Ken,

You should have received an Email from me.

Hopefully you may be able to see what I am doing that is causing this strange problem.

Thanks,
Geoff

 

[FoxG]

Not sure why but ...

By changing the record select expression from ...

EvaluateAfter({@voting type};
stringvar p:= left({?Gov_body},1) +
left({?Gov_position},1) + left({?Gov_type},1);
(if p = "***"
then {@voting type}
else ...)

where {@voting type} is :-
not({GOV_LINK.GOV_TYPE} in ["CLK","NHT","OBS"])

to....

(if (left({?Gov_body},1) +
left({?Gov_position},1) + left({?Gov_type},1)) = "***"
then not({GOV_LINK.GOV_TYPE} in ["CLK","NHT","OBS"])
else ...)

appears to have fixed it.

Thanks to Ken and Ngolem for their suggestions