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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: rbvcbr
  • Order by date
  1. rbvcbr

    Lowest Date

    I have date field, I want to show on the report, start date (lowest date) and end date(latest date). Need help with formula please. Something like, 9/1/09 - 9/18/09. Thanks,
  2. rbvcbr

    Total Vs Move

    I put the following formula, calculation works. when highlighted this field to "Sum (total)", it show is "Move" instead "instert summary". Any tips please to "insert summary" (want to total this field). Thanks, if {JCT_CURRENT__TRANSACTION.Accounting_Date} =...
  3. rbvcbr

    Show value

    Please see below, real data. Here I have '02', grouped by descripion, where it has real costs. I have groups by descrition 1 to 34. My goal is, I want to show $ 100 (could be $.10c) where there are no costs for that group, means I want to show all 34 lines/rows. Hope this helps. Thank you...
  4. rbvcbr

    Show value

    Thank you for the reply, hope you will find the answer. This data is grouped by description and showed totals only. Detail records are suppressed. Since "02" does not have data/amounts, I just want to show like below 02.Description --- 100.00 Thank you,
  5. rbvcbr

    Show value

    See below, output data, watch on left after 02 is missing, 02 should be showing 100. Check my formula also. May be something wrong in the formula. Thank you. Description --- Amount 01. Desc. One --- 14,531 03. Desc. Two --- 318,605 04. Desc. Three --- 227,227 05. Desc. Four --- 298,741 06...
  6. rbvcbr

    Show value

    I have the following formula, if there is no amount I want show $100 (meaning now blank row). But the following formula is not showing any value. Can somebody please fix the formula. Thank you, if {CURRENT__TRANSACTION.Accounting_Date} < 8/1/2009 then if...
  7. rbvcbr

    Formating the Date and Time on a Cheque

    See if this helps, if {Order_Details.UnitPrice} > 10 and {Order_Details.UnitPrice} < 19 then "********** "&ToWords ({Order_Details.UnitPrice}) else if {Order_Details.UnitPrice} > 20 and {Order_Details.UnitPrice} < 29 then "*********** "&ToWords ({Order_Details.UnitPrice}) else if...
  8. rbvcbr

    Address Formula

    Thank you.
  9. rbvcbr

    Address Formula

    I am creating labels/form letters with the the following data. If I do not have "Address 2" I want supress that row and move up the "city" up one row to replace "Address 2". Can I get some help please. Thank you. Name Address 1 Address 2 City State, Zip.
  10. rbvcbr

    Latest Date Formula

    I want to write a formula to pick the latest date and amount(most recent).
  11. rbvcbr

    Latest Date Formula

    I have the following dates and amounts fields. I want to write a formula to pick the latest date (most recent). Can some body help me please. Thank you, 04/09/2009 - $12,000- 06/18/2009 - $9,000- 04/17/2009 - $16,000- 07/15/2009 - $1,000- 05/11/2009 - $8,000-
  12. rbvcbr

    Crystal Formulas

    Thank you sir.
  13. rbvcbr

    Crystal Formulas

    I am pulling data from timberline, transaction table. This table has two fields acct_date and amounts. If I put from and to acct_dates (5/1/09 - 5/31/09) it gives me that criteria amounts (Column1). This is good. Now - Besides this column1 I want to show amount in another column (Column2) "from...
  14. rbvcbr

    ASP / MS Access

    John, Thanks for your response. I know this simple </tr> <tr> breaking. There are other strings attached to it in breaking data. Also, please I am more than happy to answer to questions what I know. I am not aware that anybody can answer here in this forum.
  15. rbvcbr

    ASP / MS Access

    I have about 20 fields in a table, I want display all these 20 fields in two rows, first row will be 10 fields, and second row will be 10 rows. How can I break like this. Please advise with code or some links. Using ASP /MS Access 2003 / XP Thank you.
  16. rbvcbr

    Crystal formulas v10 and v8.5

    See the attachment repott/mdb In crosstab report, in rows box I want to insert 'aca.year', column box I want to insert 'status', and in summary box I want to insert 'countNR' (this countNR I am counting, not sum). Any help will be helpful, Thanks.
  17. rbvcbr

    Crystal formulas v10 and v8.5

    I created a crosstab report in v10 with few formulas and I can see/use all formulas. I created the same crosstab report with same formulas in v8.5 and I cannot see/use all the formulas in v8.5 and with this I cannot create the same report what I created in v10. Am I doing something wrong in my...
  18. rbvcbr

    CR Version 10

    I have created a report in version 10, and I want save that report under 8 or 8.5. I want use this report under version 8 or 8.5. Is there any option in version 10 how I can do this. Thank you.
  19. rbvcbr

    Count or sum text field

    Sorry to drag this, yes, I did inserted the formula in detail section,not in a text box. The Other questions @sex comes from different kind of formulas, it is hard put it here. Thank you,
  20. rbvcbr

    Count or sum text field

    if {@sex} = "Female" then 0 else 1

Part and Inventory Search

Back
Top