If you are trying not to get the production table locked and to read the latest data in production you need not use the FOR READ ONLY clause. using WITH UR will do the job for you.FOR READ ONLY caluse is used for cursor selects. For more info please refer to...
you can write the whole thing in one formula using variables. use variables to evaluate each function and sum up all the variables in the end. it will look like this
declare the variables first
var1:=@Formula1(you can put the expression which evaluates this formula ;
var2=@formula2...
Please provide the version you are using.
If it is version 9 or 10 try this
create a formula like this with the parameter:
IF ?param in {field} then {field}
ELSE 'U999'
and create a record selection formula as
{field}=formula
I have not tried this out, so not sure whether this will work...
Hi dgillz,
I think we both are saying the same point but the only difference is that we reach the formula editor through different ways.
If you create a record selection formula it will appear in the formula of the select expert
go to select expert->show formula->formula editor
you can see the...
what Dglizz meant was to create a formula in select expert using the show formula button,rather than using the drop down. you are doing the same thing now.
as for your question you need to enlcose the field in simple bracket. an example would be:
{BPCUSTOMER.SATTAX_0} in {?regiondeb} to...
Along with the calculation of the sum for average
ie sharedvar:=SharedVar+AVG1
declare another variable 'sharedvar count'
and initialise it to 0
the concept is to evaluate the count as
count:=count+1, each time the average is summed.
and in the report footer calculate the average by dividing...
I am naming the AVG function in the group header as AVG-1 for ease of explanation.
Create a shared variable inside a formula and intialise it in the report header.
now use sharedvar:=SharedVar+AVG1
place this formula in the group header
create another formula in the report footer as AVG-2 and...
Hi pavandyke,
I have not run into an issue like this but one possibility that i could think of is that the database needs to be verified from crystal. Try verify database from crystal and run the report.
Materialised views get refreshed from time to time so that may not be reflecting in the...
when you are changing the report to point to a new database and try to run the report it will ask for a logon into the new database. In this screen instead of entering the login and clicking next, click on the back button.
Now select the new database from the datasources listed.
hit next and...
Hi,
I am not sure how feasible this is but
the only solution that I could think of was
1)drag the {?@variable} field into your details section.
2)right click and go to display string(it is found near to the supress check box in the common tab)
inside that
IF {?@variable}='tick' THEN 'A'
ELSE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.