Search results for query: *

Thanks a lot! it works perfectly!

Thanks Mike for your response. I have tried using a variable but cannot seem to get it right. May be I'm not defining them correctly. Can you please highlight me on how to go about it? This is what I have tried but doesn't work as desired. Whileprintingrecords; numberVar Total; numberVar...

Hello experts, I am trying to get an average time in hh:mm:ss without counting the records with a zero value. From the results below you see the total is actually an average of all the 14 records but I only need an average of the four records that have a time. One of the column is in seconds...

This works perfect!!! Thanks so much LB! Thanks too Dell! I really do appreciate both your time. I have learnt a lot from this.

Thanks LB. I'm new to this site so still trying to find my way around :) but will do as you suggest next time. Thank you for the formulas too. I am working on them and will get back with the results.

I'm still unsuccessful in getting this resolved. I also tried the format in this thread http://www.tek-tips.com/viewthread.cfm?qid=1647107&page=2 and the only problem I have with it is that the 'N/A' does not display and the results are all in one text box thus I cannot format the individual...

That's exactly what I did StringVar RESULT4; if PreviousIsNull({@UserNameID}) or {@UserNameID} <> previous({@UserNameID}) then RESULT4 := 'N/A' else if {@Res3} <> 'N/A' and RESULT4 = 'N/A' then RESULT4 := ToText({Level_3.Result}, 0); RESULT4;

I placed the results in the details and created another set of formulas (Res1, Res2 etc)which I placed in the group footer //{@Res1} whileprintingrecords; stringvar Result1; This seems to work for the first 3 results but returns the same values after that. I guess I am not getting the...

Here it is //{@UserNameID} - grouping by a combination of User name and User ID StringVar RESULT1; if PreviousIsNull({@UserNameID}) or {@UserNameID} <> previous({@UserNameID}) then RESULT1 := ToText({Level_3.Result}, 2); RESULT1; StringVar RESULT2; if PreviousIsNull({@UserNameID})...

Thanks so much Dell for your response. I have tried this method and I am getting duplicate records except for the first and last user. Here is an example of the first 3 results User Name    Result1    Result2    Result3 User1    80    N/A    N/A     User2    80    99    73   ...

I'm trying to generate a report in Crystal Reports 2008 that gives me an overview of Users' results for a Month ignoring the date it was taken. For example the results table looks like this: User Name Result Date_taken User1 80 4/2/2011 User1 98 4/3/2011 User1 100 4/3/2011 User2 78 4/3/2011...