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!

Register Log in
  • Congratulations Mike Lewis 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: *

  1. danstaunton

    Change of VPN peer IP address - Cisco 877

    Hi, I have a site to site tunnel with my customer. They have informed me that they have recently moved offices, and therefore need to update the configuration of our tunnel to reflect this change. Am I correct in saying that I need to apply the following commands to update the tunnel? Conf t...
  2. danstaunton

    Function to display missing dates

    I'm not sure how to do the equivalent in MYSQL, and even if I did I don't know how I could join it to my data. The difficulty I have is that my dates are store as a string and in this format dd/mm/yyyy hh:mm:ss , this makes it hard to join any data to the report. If I want to do anything I...
  3. danstaunton

    Function to display missing dates

    Yes I posted it, the question was answered correctly however I cannot apply the formula so that it work on charts / cross tabs
  4. danstaunton

    Function to display missing dates

    The database type is MYSQL
  5. danstaunton

    Function to display missing dates

    Hello, I was wondering if someone can help me with a very tricky Crystal Reports issue. My report takes data from our helpdesk package and provides a summary of our helpdesk activity for the last 8 days. I have attached a screen shot of how the report looks when it is working. The problem I...
  6. danstaunton

    Inserting the average numbers of helpdesk calls in a cross tab.

    Hi, The day names are put in manually as text objects. I did this after following the guide on creating a manual crosstab. I'm not sure how to create an accumulation formula can you please explain how I do this? Thanks
  7. danstaunton

    Inserting the average numbers of helpdesk calls in a cross tab.

    XI Release 2
  8. danstaunton

    Inserting the average numbers of helpdesk calls in a cross tab.

    Hi, I've started to look at the manual crosstab. I've already configured it using this guide - http://www.tek-tips.com/faqs.cfm?fid=1219 I have no problems getting the distinct count of calls per hour per day, it's the calculating the average that I have the problem...
  9. danstaunton

    Inserting the average numbers of helpdesk calls in a cross tab.

    I need to do disctinct count because my call reference is actually a number. Can you think of any other ways I can do this in Crystal? I really do not want to add any tables in my database.
  10. danstaunton

    Inserting the average numbers of helpdesk calls in a cross tab.

    Hi, I need to build a crosstab report that displays the average number of helpdesk calls per hour for each day. My Cross Tab is correctly displaying the hour in the rows section (00:00 - 23:00) the days (mon - sun) in the column section. The only way I can calculate the total number of calls...

Part and Inventory Search

Back
Top