Search results for query: *

lbass - You are absolutely my 100% hero! That worked like a charm. If you are ever in Denver, I owe you a drink! Thank you so much! [thumbsup2]

Ok - here goes ... My main report looks like this. GH1 - {SCEquipments.Zip} (This is suppressed) GH2 - {ARCustomers.CustomerName} (Also suppressed) Details - Abc Company Machine/Lease Information: 123 Main St. MIN 3050 EQ1234 Town, ST 00000 Wells Fargo 1/1/2000...

I've searched this a few times but it seems to be clear as mud to me. Using Crystal XI and SQL Server. The report I'm working on is of all active customer equipment and the leases and contracts that are active for each respective machine. My main report and subeport are grouped by customer...

I think I got it! Thanks for your help!

Thank you - That makes sense to me. But now the question is presented of how do I set up the prompt to enter the days off? I have very little experience in setting up parameters so I'm baffled!

Piggybacking on the previous post. I'm using SQL Server & CRXI. I am using the previously mentioned formula of Mr. Hamaday's {@Workdays} to calculate the number of workdays in a month. But here is what I need now. I have 10 technicians. I'm trying to figure out the average number of calls...

Thank you so much! That was perfect! [2thumbsup]

I'm a newbie using Crystal Reports 11 & SQL Server. I am trying to change both the date and year in a field. I know how to do one or the other: DateAdd ("YYYY",+2,{SCContracts.ExpDate}) or DateAdd ("D",-1,{SCContracts.ExpDate}) but I don't know how to make it do both. Any suggestions...