Search results for query: *

Hello, I need to provide monthly count of opened and closed issues along with a count of issues dispatched to resolution queue. I am able to add the date field and group by month in the column section fine. The problem is that when I add more than one field in the row section, it does not...

Hello, I am looking to get any string that starts with a fixed alphabet followed by a hyphen and any 5 numeric characters like this "A-#####". This is a memo field. How would that work. The usual '?' or '*' wildcards won't work in this case - I searched for this but could not find a solution...

Hello, I posted this question on another forum and the opinion was I can't do a pareto chart in Crystal XI - that I need to buy an add-in. I received excellent advice here when I posted once last week and wanted a second opinion. I have a crosstab with one row which lists the different types...

I have a formula field to calculate the days between order taken and last time it was sent for closure. There are several dates for closure and only the last one in the table is relevant so the formula is: 1)maximum ({table.field}, table.id}) - {date created} then I want: 2) total closed in...

Hello, This seemed easy enough but I am struggling and would really appreciate some help. I am trying to create a crosstab for how many days it took to complete an order. These are the formulas I created (the first part is the name of the formula): 1) days took to close - Date difference in...

How do I eliminate all counts that are a value of 1 in a cross-tab table. Client only wants to see count of 2 and above. I created a formula for the summarized field where count <> 1 but it does not work. Also when I convert this cross-tab to a chart, I would like to show the value for 'count...