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

  • Users: Kibeth
  • Content: Threads
  • Order by date
  1. 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...
  2. 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.
  3. 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...
  4. 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...
  5. 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...
  6. Kibeth

    Formula not working

    I am using the following formula to find the Due Date of an order, but I am getting an error saying I need a number on the 4th line instead of a field. Does anyone have a workaround for this? I am using CR XI. Thank! WhileReadingRecords; DateVar Array Holidays; DateVar Target:={@OrderDate}...
  7. Kibeth

    Select by "Null" Value

    I have a report that I need to see only the results that have a null value in the "Ship" field. I have tried having Crystal convert the Null values to default, but it doesn't seem to be working. The Ship field is a date-time field, and no matter what I put in the Select Expert it says I need...
  8. Kibeth

    Group by Formula Field

    I just created a formula field to give me the Product Name, and I need to be able to group by that field, but it is not listed in my Group Expert. I have put the field in the report details, and it is not even listed under the "Report Fields" in the Group Expert. Please help I am using CR XI.

Part and Inventory Search

Back
Top