Search results for query: *

remove the quotes from @RED = "1" and try. Use this: IF @RED = 1 THEN crRed ELSE crnocolor Thanks, Madhu

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...

Please try this out. when you got to select expert select formula for the datefield and enter the formula editor type : isnull(datefield)

Hi Anders, It is the same variable. it is safer to use while printing records Thanks, Madhu

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...

where have you placed the Average that you are calculating from the other fields? please provide more details Thanks, Madhu

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...

Gurus....I was running into a same kind of situation..Thanks for the help :)..mine worked too