Search results for query: *

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

Thanks for your suggestions. The format that I want to produce is two axes as simple straight lines with the x-axis in the middle (as people can have negative scores). I then want to position just the people's names vertically, relative to their score. As an added bonus if could stagger the...

Is there any way that I can dynamically position elements on a report based on their values? I am running Crystal 10. What I want to do is list the names of our sales people ranked according to a percentage score against each one. So far so easy, but I would like to make the space between each...

I have successfully created this as an SQL command. Many thanks to all. However I still cannot cite a link to the main report's SQL in the WHERE clause of my SQL command. Instead I have to link the command to a table in the main report on the 'Links' tab of the database expert window. Whilst...

Thank you all for your comments. It sounds like BO are pulling the rug from under us. Being new to CR 10 I have no idea how to create a Command. Could anyone advise? Does it require Enterprise and/or repositories. We have the former (though I have no control over its setup) but not the latter...

I created some SQL expressions in reports when I was using Crystal 8.5, which all worked fine. They contained SELECT statements etc. When I upgraded to Crystal 10 last week some of them stopped working, and despite applying all the hot fixes they still do not work. The common element in the...