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

    Adding Multiple fields

    I am looking to add multiple fields together for a total. The table they are in looks like this; Table Name : Volumes ID Date Volume1 Volume2 Volume3 Volume4 up to Volume 96 (all the 15 minute intervals of the day) How do I quickly sum up all the Volume items of data? In VBA I know how I...
  2. NickEveritt

    ReCrystallize Question

    Ken, how do concurrent access licences work? batches of 5 etc or its a one off payment? N
  3. NickEveritt

    ReCrystallize Question

    to legally expand the number of concurrent licences is our only option to buy licences of CR to cover the multiples of 5 or is there any sort of other license we can buy? And also, are you saying, from one of your earlier posts that there isnt actually a runtime limit anyway on CR 8.0
  4. NickEveritt

    ReCrystallize Question

    Thanks again Andrew To clarify, are you saying that throught the ASP we are limited to 5 concurrent users by licence but we are not limited by the system? Nick
  5. NickEveritt

    ReCrystallize Question

    Thanks for that answer Andrew. With the demo version, I had 6 people looking at the same report. The demo version is for saved data only, is there a difference between saved and run-time? Im guessing there is. So to expand the number of concurrent licences without going to CE, do I have to...
  6. NickEveritt

    ReCrystallize Question

    If we design reports in Crystal Reports 8.0, and then use ReCrystallize to create the web pages, my understanding is that it utilizes the viewers. How many people can access one report using these viewers concurrently? Does ReCrysallize utilize the web components with Crystal Reports or does...
  7. NickEveritt

    Web Publishing Crystal Reports

    Thanks for that. My understanding of the broadcast licence (at 10K a year) is that if over 50 people will view a report that is automated (which it will be) you need the licence. For example, from research so far, we can produce templates in Crystal Reports, use ReCrystallize to put it into an...
  8. NickEveritt

    Web Publishing Crystal Reports

    Please ignore my ignorance, I am doing some research for an MI project. But Im sure you can all help. Requirement: to publish reports onto an Intranet and also available to certain clients on an extranet. The reports are all pre-defined and will need to be targeted to users. I.e. users login...
  9. NickEveritt

    Global Variables?

    OK but how do I create groups of EVENT types? i.e. Group 1 (1,2,3) and Group 2 (4,5,6)?
  10. NickEveritt

    Global Variables?

    I have field which captures the length of time in EVENTS. There are EVENTS that are productive and non-productive, and there is an EVENT TYPE field. Therefore I am looking, in one field to have the fields for EVENT LENGTH sum all the Productive event lengths, and then another field for all the...
  11. NickEveritt

    Inputbox - Excel 2000 - Dates

    Sorry I think I may not be explaining things well here. It is not about how it is entered into the input box, (it is always entered dd/mm/yy style). it is about what the input box does with the date, it immediately transfers it to the locale version of the date, i.e mm/dd/yy. with the code...
  12. NickEveritt

    Inputbox - Excel 2000 - Dates

    All methods and functions that I have tried will do the same thing, they take what is in the input box and always convert it to the regional setting version of the date. e.g. if input box is a string, and you use cdate it will use the regional setting, same with datevalue etc. Also in getting...
  13. NickEveritt

    Inputbox - Excel 2000 - Dates

    cdate is based on the locale of the machine, which I have set to mm/dd/yy, the output from the inputbox, which is entered as dd/mm/yy, comes out as mm/yy/dd, and then finally the spreadsheet cells are set to dd/mm/yy! Its this that makes me confused! The the inputbox in my mind should be the...
  14. NickEveritt

    Inputbox - Excel 2000 - Dates

    I am having problems with dates from an inputbox produced by VBA into excel. I 100% know that it is the regional settings, all PCs here should be on dd/mm/yy, but as usual they are not all set-up, I have changed my settings so that I can get round ther variations. I have read all the previous...
  15. NickEveritt

    Login / Logout report

    We have the newer turrets with the HEADSET button, if you press it, you are logged out, but it doesnt log you back in if you press it again, which is essentially whats happening. You need to change your reports to show hh:mm:ss, it is possible to log in and out in about 3 seconds, so it will...
  16. NickEveritt

    Login / Logout report

    We are running v6, with a G7 ACD. Eveton - when you queried it with Avaya, was the patch free? Did they have an explanation for how and why it was happening? N
  17. NickEveritt

    Login / Logout report

    I have all the Agent Traces possible set-up, unfortunately i have not been lucky enough to catch one yet, there is no pattern, so Im hoping to catch one by luck rather than judgement. There are about 200 agents here, so it exceeds the number of agent trace places. Have you looked at your own...
  18. NickEveritt

    Login / Logout report

    BIS That was my first thought, but there have been no changes to their skills. The agents are not aware that this is happening,somehow the ACD is retaining their login number and effectively logging them back in. Have you looked into this on your own agents? It may be happening to you! I am...
  19. NickEveritt

    Login / Logout report

    Has anyone come across instances where an agent is shown on the Historical/Agent/Login/Logout report as logging out and in again at the same time? I have changed the report to show this by the second, and there are clearinstances of it being on the exact same second. Any clues to what is...
  20. NickEveritt

    CentreVu Open Database Connectivity (ODBC)

    Thanks for that PD. We will be choosing our fields from within the tables, at this stage probably only from the Historical Interval tables of Split, Agent, Vector and VDN,maybe CWC. It will basically be a daily dump at a quiet time into a warehouse, where we will be building a new db with...

Part and Inventory Search

Back
Top