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...
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.
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...
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 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...
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}...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.