Hi,

I have following problem. If I use any statement using database fields, global variables don't seem to work properly.

For example - when I have two formulas in report:
Formula a (within Formula field A):

global stringvar a:="Nothing special ";
local stringvar d:="";
a:=a+"x";

Formula b (within Formula field B):

global stringvar a;
a;

As a result of it, when I display Formula field 'B' on a report, everything is ok, I get 'Nothing special x' text, however if I would add in first formula anything with database field, it doesn't work anymore.
For example - if I would modify above Formula a like this:
Formula a (within Formula field A):

global stringvar a:="Nothing special ";
local stringvar d:="";
if({Command.field_1}<>"") then d:="nothing important for example";
a:=a+"x";

then Formula field B shows... nothing.. This is crazy. The only difference is that I put if statement, comparing data from db with a string, and please notice, that it has also nothing to do with global variable a!

I don't get it ;/

Any help be appreciated.

Mikolaj

I use Crystal Reports XI


Edited by majki - 22 Dec 2009 at 4:28am

I tried both - checking if this field is null and also just to use Command.field_1 as argument for 'is null' funcion and also using the column {Command.id} which is by default not null (as a key in db). Still nothing.

What is also weird - it worked fine for few tries (even before i made any change! I just came back to Crystal reports), after that it asked me to re-connect to db - after that - it's again lost.

I'm confused.

Anyone? Problem still exists :(

Update - Now i know why it needed this line - it's about the time when it's being calculated.

Instead of what i've written, we can write (and actually it is much more obvious) like this:

zzz:
EvaluateAfter({@akt});
stringvar gA;
gA;



Probably when i put a line with 'command.d_id' field from db, it had to wait till records were read. Here, we just tell CR to run this formula AFTER the one in which global variable gets proper value.


For new guys in Crystal Reports (as I am) reading this - read some information about EvaluateAfter(), WhilePrintingRecords, WhileReadingRecords and BeforeReadingRecords.

All of them accessible in standard CR help (F1) under 'Evaluation Time'.
This is core and knowing this will help you a lot.

Best regards,
Mikolaj

reset your a1 to 0 in the group header...If the record is blank, there is no value to update a1, so it stays the same.