Showing posts with label formula. Show all posts
Showing posts with label formula. Show all posts

Sunday, February 26, 2012

global variables urgent,

hey
i declare 3 global variables inside a formula.but can not refer those variables in another formula in the same report.
tell me how & where to declare global variables.
thanx.hi
try using this way :

formula @.x
numbervar a;
a:=10+20;

formula @.y
numbervar b;
numbervar a;
b:= 20+30;
b:=a+b;

as many variable as you want decalre in a formula, but the each formula should declare the variable.

This will give an idea about the global varialbles.
please try and let me know.|||Use shared variable also. Read it more in help file

Friday, February 24, 2012

Global Summation

Hello,

I'm having one small issue. I have 13 subreports, and in these subreports, I have a formula that adds up certain data fields. However, I need a formula in which it adds up all these fields globally but have been unsuccessful to do so.

If anybody could shed some light on this, that would be fantastic.

Thanks,
Adrianyou may look at 'shared' data level.


shared numbervar myvar;

it keeps value of variable in other sub report.

Sunday, February 19, 2012

giving more than one condition in selection formula

hi ,
how to use more than one condion in selection formula.for example
i wish to select the record between two date ranges. i am begnner to crystal repots and also how to use images in crystal report.any body have an idea about this pleaz forward ur answer to meYou will have to create two parameters in your select statement. Since you can not use multiplevalues you will have to do something like the following:

Parameter 1: DateFrom
Parameter 2: DateTo

Your select statment will look something like this:

Select ....
From...
Where table.date >= DateFrom AND table.date <= DateTo|||You can also use Selection Forumla

CR.SelectionFormula="Date between {firstDate} and {SecondDate}"