Search results for query: *

Hi I have a cross-tab comparing 2018 and 2019 sales, I would like to highlight the schools that are new for 2019 but haven't been able to figure out how. I tried right clicking on the school and going to format field, border, background and entered: if{CUST.FIRST_DATE} in Date (2019, 01, 01)...

I have a Cross Tab and the Row lists months with the year - what I would like is for it to list the same month of different years under each other - is this possible? It would make it easier to compare the values of each year. Like this : Jan 2018 Jan 2019 Feb 2018 Feb 2019 Thanks

I have a cross tab that compares my customer type sales yearly, what I would like to do is be able to compare it monthly for example I want to compare 2018 Jan - May with 2019 Jan - May. Any suggestions how to do this? My record selection is this: {INVOICE.SHIPPED_DT} in {?Starting Date} to...

Hi I am working on a report where I want to find how many new customers each month so my Select Record is as follows {ORDERHDR.OPERATOR} <> "NW" and {ORDERHDR.ORDER_DT} in {?Starting Date} to {?Ending Date} and not {ORDERHDR.PROFORMA} and not {ORDERHDR.CANCELLED} and not {ORDERHDR.TEMPSAVE} and...

Hi I need a formula that will do specific dates but not include customers outside that date. In other words say from 3/1/2012 -2/28/2013 and 3/1/2011 - 2/28/2012 but if the customer ordered in 3/1/2012 - 2/28/2013 they shouldn't be included in the count for 3/1/2011 - 2/28/2012 Any ideas how...

Hi I have a report that shows territory sales just the state and total sales for a specific date range. Now I would like to add another date range so I can compare 2011 and 2012 but I am unsure how to do this. I am new to crystal - would appreciate any help. Thanks

I have a report that shows: account# customer address city state zip contact invoice# total For some reason the customer, city and state columns are suppressing duplicates. I have checked and I do not have the Suppress Duplicate oe Suppress checked in the format field. Any ideas why this is...

Hi I am having an issue with a cross tab - I have spacing I can't get rid of and it messes up excel when I export. If you look at the photos you will see my settings and the area I am talking about. Any idea how to get rid of the space I show in the 2nd photo marked in red?? Thanks This...

Hi I am fairly new to Crystal and I came across something - I opened an existing report to modify it and I noticed under the database fields it said Address rptStatements I know the address is part of my database but I don't know what the rptstatements is. I thought it was another report but...

I keep getting an error the ) is missing but I can't figure out where sum(({ORDERHDR.ORDER_TOT})where year = '2012') -sum ({ORDERHDR.ORDER_TOT}where year = '2011'))

Hi I have a cross tab that has the months (@monthnames) of the year as the row and the years(ORDER_DT) as the columns for sales figures (SUM of ORDER_TOT), now I want to show the difference for each month/year - for example: 2011 2012 Difference January 50000 35000...

Is there a way I can supress a whole line if the invoice # is a duplicate? The information reads : Co Name address invoice# date total sale For some reason there are some duplicates of invoice #'s and I need to supress not just the invoice# but the whole line. Is there a formula for...

Hi how can I combine two fields, I have a phone number and and extension so right now it is PHONES.NUM PHONE.EXT I would like to combine these so it shows in one field.

Hi I have a report that shows customers with their phones numbers and invoices. I am surpressing the duplicate phone numbers but I also want to only have them show once. In other words if there are 5 invoices I only wnat the phone numbers to show for the first invoice not all five. Anyone know...

I am doing a cross tab report to show sales for years, so I have the customer name in the Row the column is the Order Invoice Date (grouped for year) and the sum field is the sum of invoice.item_total. My question is : How do I get it to show the account number with the customer name?? I...

Hi I have a report for total customer purchases, but I want to show three years worth and have each year in their own column. Right now I'm using one date range (ie 01/01/2008 - 01/01/2011)and it just totals them all together, I want to be able to break out each years total. How do I do this...

Need help with this selection formula: {PHONES.CUST_NUM} = {?Pm-CUST.ID} and {PHONES.PHONE_TYPE} in ["", "O"] My problem is that it is not including the phone numbers that don't have a type. I need it to select the OFFICE phone number which is "O" and if it has no type listed I need it to...

Hi I am having a problem linking my tables, if you look at this file I have screen shots and explain what is happening, mabe someone has an idea why. Thanks http://www.mediafire.com/?14n3pj49041qd55

I am doing a Accounts Receivable Report and I only want to pick up customers that are over 30 days past due but I don't know haow to reference that in a formula. What do I use as a date to say when the ship date is over 30 days Right now I have this not {ORDERHDR.PROFORMA} and not...

Hi how do I get my report to only show the field/column names once? Right now they are repeated for each customer. Thanks