Recent content by Sacheveral

We currently have Crystal Reports 10 embedded in our .Net application and when we get more than 15 simultaneous reports called, any additional ones return an error because the maximum concurrent calls to Crystal Reports has been reached. Firstly, does anyone know a way to cure this, and...

Once again thank you for your helpful response, however I am still not sure how many instances of each service I should have. Would one per CPU be a reasonable solution, and what dictates the number of instances of a service, i.e. why not just have for example one report job server service...

Hmmm, interesting. A lot of things we haven't previously considered there. Our current setup is as follows: 1 server with 4 single core hyperthreaded processors (so 8 virtual cores). We use Crystal Enterprise 10, so hopefully roughly equivalent to Crystal Reports Server XI. We have our reports...

Thanks for that. Although we only have 20 concurrent users, we also pre-generate about 15,000 report instances a day, and email about 5,000 of these, so therefore need a fair bit of resource. Thanks, Joe

Tried that, they were not very helpful. All they seem able to quote is the minimum spec! I got the distinct impression that they didn't really know, and I have asked several of their engineers about server specs. Aside from the specific Crystal application, do you have any general rules of...

If it was Crystal Reports you could tick 'can grow' but then tick 'limit to lines', and choose 1 line. Not sure if you can use that here. Joe

We are hoping to install a new Crystal Reports Server XI installation (20 concurrent users) in the near future, with both Crystal and Xcelsius content, and on the principle that the hardware is a lot cheaper than the licenses, we would like to get the best server up to the point where it stops...

I have just tried that, but unfortunately when exporting to excel it puts the second cells on a new line, even though in Crystal they overlay each other. Any suggestions? Thanks, Joe

Is it possible to have a different colour for the bottom border of an object than the other borders, for instance grey top, left and right, but black bottom? If not is there a work around? Using CR10 SP6. Thanks, Joe

Thanks for those. The first works, but I was wondering if there was something a bit briefer, and more flexible in terms of the number of fields, for example maybe a system function in the form "minimum (field1, field2, field3, etc., etc.)" The trouble with the second solution (unless I used a...

What is the most efficient method to find the minimum/maximum value of a number of date fields in a single record? For example I would like something like: select field1, field2, field3, field4, (lowest of fields 1 to 4), (highest of fields 1 to 4) from table1

Thanks, but wouldn't that return the record if{Employee_VT.Descriptor} was null, regardless of whether {Employee_Man.Descriptor} matched the name? Even if there is an alternate solution for this problem, I would be interested to know how to do a switch anyway, and the sort of SQL statement that...

Running CR10 in Win XP. According to the help you can pass conditional record selection to the SQL statement in Crystal by using the Switch command. However I have tried the following and it does not seem to work: {Employee_Man.Descriptor} = "John Smith" or...

Thanks for that, but unfortunately (at least as far as I can tell) you cannot add file attachments using the SendObject command, which is why I used the Outlook application method. I cannot log in as that account, I can just send email from it, and I do not want to go in and change it manually...

I have a routine that sends emails from Access, but I want to specify the 'From' field in the email and it will not seem to let me. Does anyone have any suggestions? The code is: Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem)...