Search results for query: *

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!

MEMBER_TYPE is a number.

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

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

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

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

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

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!

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

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

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

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.

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

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

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.

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

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.

Thank you both! This was very helpful.

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

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