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!

  • Congratulations wOOdy-Soft 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: *

  • Users: Sacheveral
  • Content: Threads
  • Order by date
  1. Sacheveral

    Maximum Concurrent Reports Embedded in .Net

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

    Server Spec for Crystal Reports Server

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

    Different Colours for Borders of Objects

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

    Find Minimum of list of Fields

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

    Switch Not Passing to SQL

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

    Specifying the 'From' field in Emails from Access

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

    Dynamic Positioning

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

    SQL Problem When Upgrading to CR10

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

    Sorting by Calculated Field from Totals

    I have a very simple report that groups by employee, and the detail section has two fields, a formula for the item that is 1 if it is an enquiry and 0 if not, and a similar formula for if it is a deal. The detail section is hidden. In the employee group footer I have 2 totals: sum of enquiries...

Part and Inventory Search

Back
Top