I'm not getting the results I expect to see when I try to suppress the distinct rows of data.
Following is an example of what I have that meets the criteria of 3 in 60 days, and the way it is grouped.
Cust 1
3/6/2004
3/7/2004
4/17/2004
4/17/2004
5/15/2004
6/11/2004
I want to be able to...
I did get this to work with the solution provided. Now I have a another question.
With the report grouped by the custID and the date and where we are looking for 3 or more tickets within a 60 day timeframe, there are some tickets for the same custID that show up under more that one of the date...
I need to identify 3 or more tickets within a 60 day timeframe. The report needs to go back further than the last 60 days. For example, from January 1, 2004 thru the current date, identify all tickets that meet the criteria of 3 or more within 60 days.
Thanks for any and all suggestions...
I understand what you are saying to bring in only the data that meets the criteria, however, I need to bring in year to date data and out of that data select the reports that meet the criteria of "3 in 60".
Thanks,
dmt4cats
I am using Crystal Reports 8.5 and am trying to determine when 3 or more tickets occurred within 60 days for the same customer.
My ticket information is on separate rows. I know how to tell if there are 3 or more tickets between given dates by using a simple formula such as:
Formula 1
if...
I have a report that includes several rows of data for the same ticket number. I need to compare one field of the data, to see if the 2nd row is the same as the last row, in this one particular field, (the last may be the 10th or the 15th row, no certain number). Is there a way for me to do...
I am using Seagate Crystal Reports, Version 7.5. I have a report with multiple rows for each ticket. I have grouped the report by ticket number and done a running total to show the number of rows for each ticket. My customer only wants to see the tickets that have 4 or more rows. Is there a...
In the data mart I am pulling data from, all times are stored in Central Time. Is there an easy way to convert this time to the time zone for the State.
I thought they may be some type of function to convert this type of data.
Thank you for any help you can provide.
I am using Seagate Info version 7.5. I have built a crosstab query, I do not like the way the rows are sorted when I use ascending. Is there a way for me to build a custom sort order? I have seen specifed in the options to sort, but, I haven't figured out how to use this if this is what I...
This is a string field. I am trying to break it down to seconds or minutes so I can calculate and then display however my customer wants.
I am looking at breaking it down to 3 separate fields with the suggestion from Nuffsaid.
Thank you,
I am using Crystal 7. I have a field that displays days hr:min:sec. I want to convert this field to a number so I can do calculations on it.
Following is an example of what is in the field:
203 01:21:15
Is there a way to convert this field?
Thank you for any help.
I am using Crystal Info 7.5. I am trying to get the running totals for 3 separate groups. I have the running totals for the report by region, I now also need the running totals for each state and each city. Can I do this in the same report so I do not need to use subreports. I know I can do...
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.