Search results for query: *

Also I forgot to mention, that this is Crystal 11.

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

SUBSTR(replace(TABLE_.FIELD,' ','')), INSTR(replace(TABLE.FIELD,' ',''),'A-')+2,5) = to_char(SUBSTR(replace(TABLE.FIELD,' ',''), INSTR(replace(TABLE.FIELD,' ',''),'A-')+2,5)

Thanks lbass - I wrote a customized sql command after looking at a book to speed it up. But thank you so much since your code helped give me an idea of how to proceed.

Thanks lbass - you are always very helpful. I'd like to rephrase: I need to pull all relevant fields from a table where the memo field contains this string and only these many characters: "A-#####". The hashes will always be numeric characters and there will always be exactly 5 numeric...

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

Thank you. When I don't have any running totals, I don't get the above mentioned error message. I have just a simple formula for count of problem type which I use in the cross tab expert column and then do the percentage of that count right there, I am able to chart fine based on that (bar...

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

Thanks lbass - that worked and I learned something new. I am not a technical user but both were my developers were out and I needed help - since I did not get a response to the earlier loop - I thought I would rephrase the subject since the content of the request had changed. Thanks...

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

Thank you all for the post responses. I have version 11. May I rephrase my query please. Since a couple of items have changed and the cross-tab summary did not work. Say I have a formula field to calculate the days between order taken and last time it was sent for closure. There are several...

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

Thank you for your response. So currentfieldvalue <>1 will work in my case since I do not want to show values of 1?. I will look into how/where to use it. If you see my attached chart, it shows the percentage of total value _displayed within_ the chart - not sure how to display in that manner...

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