Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: auburnfan
  • Content: Threads
  • Order by date
  1. auburnfan

    Need help finding a sum

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

    Find the number of days

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

    Adding sums together

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

    Number Paramater

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

    Counting

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

    Report Viewer

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

    Not like

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

    Closest to date

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

    Having CR calculate info

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

    Pulling up by todays date

    I am a new user to CR and I have been trying to figure this out without much luck. I need to run a report that automatically pulls the information up by todays date. I would like to do this wihtout having to manually type in the date each time I run the report...is this possible? Thanks in advance.

Part and Inventory Search

Back
Top