Recent content by NickEveritt

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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