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: *

  1. Kibeth

    "Distinct Count" Summaries Counting Nulls

    I don't know why that worked lbass, but it did the trick. Thank you so much for all your input and patience in helping me resolve this!
  2. Kibeth

    "Distinct Count" Summaries Counting Nulls

    MEMBER_TYPE is a number.
  3. Kibeth

    "Distinct Count" Summaries Counting Nulls

    1 - I did not enter anything in the {@null} formula 2 - "Convert null to default values" is not checked 3 - MemberID is never null 4 - The data type of MemberID is (number) Thank you again for all of your help with this. -kibeth
  4. Kibeth

    "Distinct Count" Summaries Counting Nulls

    Okay, this isn't making sense to me. If I use the formula IF {VIW_ORDER_DETAIL_REPORT.MEMBER_TYPE} = 1 THEN {VIW_ORDER_DETAIL_REPORT.MEMBERID} ELSE tonumber({@null}) then I get the error "The string is non-numeric." but when I use IF {VIW_ORDER_DETAIL_REPORT.MEMBER_TYPE} = 1 THEN...
  5. Kibeth

    "Distinct Count" Summaries Counting Nulls

    lbass- When I try your solution I get an error message saying "The string is non-numeric." Any suggestions on how to fix that?
  6. Kibeth

    "Distinct Count" Summaries Counting Nulls

    This would be great, as long as the same customer/company didn't make two orders in the same time period. When that happens, they would be counted twice where we only want them counted once. Thanks for your advice. Any other suggestions? -kibeth
  7. Kibeth

    "Distinct Count" Summaries Counting Nulls

    I am running a report to find out how many unique customers or companies placed orders during the last week. I have done this by using the fields "Order ID" and "Member ID" and formulas called IsCust and IsComp. The formulas are: IF {VIW_ORDER_DETAIL_REPORT.MEMBER_TYPE} = 1[1=cust 2=comp] THEN...
  8. Kibeth

    Cross Tab sorting

    Thank you so much for all of your help with this! It has been wonderful working with you. You have been so patient, and helped walk me through the simplist of issues. You truly are a wonderful help to everyone on here. Thank you!
  9. Kibeth

    Cross Tab sorting

    Sorry for taking so long to get back with this information. I do not have a field that clusters these products. The field I am working with (The field for the Row) is the product name (4x6, 3x5, 20x20 Gloss, etc), which I am grouping using the Sepcified Order to get the high level product...
  10. Kibeth

    Cross Tab sorting

    The reason I am using the Specified order is because I have several products that I want to list as one product. For example, one of our products is "Prints" so the database actually has 4x6 Prints, 5x7 Prints, 8x10 Prints, 8x12 Prints, 3x5 Prints and Wallets, but in the report I want it to see...
  11. Kibeth

    Cross Tab sorting

    lbass, thank you so much for all of your help with this. That option is not available to me after I have clicked in the corner of the cross tab. I wonder if this is because my products are grouped in specified order. I have 10 sizes of one product displaying as one line instead of 10, and...
  12. Kibeth

    Cross Tab sorting

    I have a Cross Tab that has Products in rows, and Quantities in monthly columns. I want to sort this by Total Quantities for the year. I have tried using the Group Sort option, and it isn't working. Any ideas? I'm using CR XI Professional.
  13. Kibeth

    Repository Help

    Thank you all for your help. You have helped to make this a less trying experience for me.
  14. Kibeth

    Repository Help

    Sorry, I am really new to this. I have searched the FAQs and forums for help in accessing and setting up a repository. I have been unable to find anything. Let me explain my situation. The company I work for purchased Crystal Reports XI Professional for me because they wanted quick access to...
  15. Kibeth

    Add data to Crosstab

    Oh, I also need to be able to sort my products by the overall top seller. My "Products" are groups of similar SKUs currently grouped by sepcified order. I'm not sure if there is a way to do this besides doing it manually.
  16. Kibeth

    Add data to Crosstab

    I have a crosstab showing monthly sales for each product, it look something like this ---------------------------------------------- January|February|March|April|May... Mug| 20| 15| 10| 8| 2... Mouse Pad 5| 14| 2| 3| 12... I need to add the Quarterly sales...
  17. Kibeth

    Shared Formulas

    I have XI Professional. Can someone show me how to use the repository? Unfortunately; I am currently the only one in the company using Crystal Reports, and they didn't want to pay for training so I'm learning everything by experience and help from all of you.
  18. Kibeth

    Shared Formulas

    Thank you both! This was very helpful.
  19. Kibeth

    Shared Formulas

    I have several reports that I will be creating over the next couple of months, they will all need to include the same basic formulas (some cdates and similar). Is there a way for me to only have to write these formulas once, and be able to use them in any report I create? I am using CR XI...
  20. Kibeth

    Formula not working

    @ Order Date is simply: cdate({ORDERS.ORD_DATE}) @SLA is: IF {VIW_ORDER_DETAIL_REPORT.SKUID} = "01006194" THEN "0" ELSE repeating 100+ times with a different number for each SKUID.

Part and Inventory Search

Back
Top