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 Wanet Telecoms Ltd 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. char473

    split function results in null value

    OH MY...You both are brilliant. I'm utilizing both solutions for different needs. Thanks so much for being here!!!
  2. char473

    split function results in null value

    Hi All, I'm using Crystal 10 When the report is run, the following error is received against the formula below; error: A subscript must be between 1 and the size of the array. formula: if ubound(split({tableA.fieldA},"\"[7])) > 0 then split({tableA.fieldA},"\")[7] else "" Here is a few...
  3. char473

    Using Report footer formula in group

    Here are the formulas being used @printfloorcommon (placed in report footer) whileprintingrecords; numbervar accumfloorcommon; numbervar accumfloorcommon @accumfloorcommon (placed in group footer) whileprintingrecords; numbervar accumfloorcommon := accumfloorcommon + shared...
  4. char473

    Using Report footer formula in group

    I am using Crystal 10 I have the following formula in the report footer numbervar percentofcommon; numbervar percentofcommon := ({@printfloorcommon} / {#RTotal1}); numbevar percentofcommon This formula yields a percentage that need to use in a formula that is placed in a previous group header...
  5. char473

    conditioning data with if then else

    HI, Before I begin, I apologize for my rudeness, I was place on other projects. I realllly appreciate your help. Turkbear your reallll close. Here's an example of the data CarA Blue CarB Red CarC Green CarD White CarA Red CarB Green CarC White CarA Green The...
  6. char473

    conditioning data with if then else

    I need to work on my examples...hopefully without going into the business details here's an example; Let's say a need a report of all the cars in stock and the colors of those by customer preference. The customer prefers blue if not then red if not then green I only need on line of...
  7. char473

    conditioning data with if then else

    Hi, this is my first posting...be gentle. I'm having difficulties getting my report to select from the multiple details records from a secondary table. Here's an example of the table layout table1 table2 ID1 detaila detailb...

Part and Inventory Search

Back
Top