Recent content by auburnfan

It took me a while to get it the way I wanted it, but it did work out. Thank you very much :D

Hello everyone. Here is the problem I am having. I have a report that is making a count of all the different origins in the table. The table looks like this. {table_origin) email phone walk up fax voicemail What the report does is count each ticket placed under each origin by each team...

OK I am using CR 8.5. What I need is to be able to find the number of days since a customer called last. I want to be able to have my paramater as enter say 30 and it will show me every customer that has not called within 30 days. I know I could just enter the the date manually, but the...

That did it :D Thanks a bunch!

Here is a breakdown of what I have. {sumoftable.totalpages} this is say 100 {sumoftable.totaldeleted} this is say 50 I need it to tell me what the 100 - 50 would be. They are in the same group not sure if that is what you mean though...

Hello all, Is there a way to add two sums together? I have been trying to figure this out without much luck. thanks

Ok...Here is the problem I think. I made my Paramater {?date} but it is looking for an actual date(2006-03-14)I need to be able to type in a number Example... I need to know what customer has not called in 20 days, so when I open the report I need to be able to type in 20 in the paramater and...

currentdate-maximum({table.lastcalleddate},{table.customer} > {?MyNumberParameter} Tells me that a number is required here. Sorry for asking stupid questions, but I do not have much exp with this stuff.

I am using version 9.2 and an odbc database. What I am needing to do is figue out a way to to be able to search for customers who have not called in X amount of days. I have tried to make a paramater but cannot seem to find this in the data. What I need to do is figure out a way to match the...

Have a small problem. I need to find a way to figure out the number of 1's in a table. Here is a breakdown of it. {table.1} has two possible outcomes a 1 and a 0 what I need is if {table.1} has a 1 in it then I need it to count the number of 1's in the field (there will be many) and give me...

I am using CR version 9. What I am looking for is how do I write a report here at the office and send it to a client and allow them to run it and view it without them having to purchase crystal reports. Any suggestions?

Ver 9 Ok, I need to figure out what is not in {table.B} that is in {table.A} Example {table.A} {table.B} 1 1 2 3 3 4 4 6 5 7 6 7 I need the report to find that 2 and 5 are missing in {table.B} any...

Alright, I did this, placed it in the group footer but the problem is it is still giving blank spaces in the deatils section for the supressed entries.

I have the journals appearing in ascending order....is there a way to take the first entry and hide the rest? That would seem to be a much more simple way to do this.

Ok This didnt quite do what I was needing. The two tables that I am using are {journal.entrydate} and {journal.entrytime} There could be multiple entries on a date. What I need is for it to check for the closest date to current date and then check for the time closest to "11:59PM". This...