Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Telemachus

    Color a field red

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

    FOR FETCH ONLY WITH UR under nested select

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

    How do I combine a SUM formula with an IF formula?

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

    Dynamically Select a field to use within the report

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

    Select Expert NULL date

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

    Select Expert NULL date

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

    Select Expert NULL date

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

    Average on average - cannot summarize field

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

    Average on average - cannot summarize field

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

    Average on average - cannot summarize field

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

    Average on average - cannot summarize field

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

    Data Missing from Crystal report when using a materialized view

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

    using "set database location" for a DB2 query

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

    Boxes !

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

    equivalent to select max(field)... in crystal

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

Part and Inventory Search

Back
Top