Search results for query: *

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

ALright, how do I suppress all of the entries other then the first one?

I am using CR 9. What I need to do is find a way to bring up an entry that is closest to current date. So it will find the last journal entry. Any suggestions? thanks

I tried that but it didnt work quite right. Here is what I did. {datafieldwithhours} > 0.00 (this pulls up the calls with more then 0 hours.) Now I need to multiply the number of hours by 125. so I did this {datafieldwithhours} > 0.00 * 125 but all of my information vanishes when I do this...

Is it possible to make CR calculate information? What I have is it is pulling up the information of amount of hours spent doing a job, I need to multiply each hour by 125 and I need it to show me the result. Any suggestions? oh yeah version is 9.2

WHERE CallLog."RecvdDate" = 'CurrentDat' That is what appeared in Show SQL Query.....now I went back several times and made sure that I was entering currentdatE and when it shows up here the E is missing. What I ment by it did nothing is it did not give me an error saying the string was...