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 Chriss Miller 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: suemon
  • Content: Threads
  • Order by date
  1. suemon

    Cannot view existing pages

    Hi I am using Visio Std 2003 and am working with a cross functional flowchart I've been sent. The file properties show 10 pages I should be seeing but when I open the file I seem to be looking at new functional band someone was trying to create and can't get to the rest of the data. The top of...
  2. suemon

    Conditional selection of group to total/count

    I am writing a report that summarizes total number of customer visits per year then averaging the number of visits per month. This is all simple but I need to change the 'averaging' for the current year to divide by number of months passed rather than the simple /12. Making the divide by a...
  3. suemon

    prompting for passwords in crystal XI when accessing Lotus Domino data

    Just occurred to me that someone might have a quick fix for this as well. Or at least be able to point me in the right direction. Wrote a report in crystal that contains various subreports. Each of which access different Lotus Domino databases. I am using single sign on in Notes and have set...
  4. suemon

    sub reports within crystal XI

    I am trying to write a report that contains other subreports and am having trouble with the way the detail sections present. (first time I've seen this happen and can't figure it out) The report is meant to collate customer data from across many different countries (all of which have their own...
  5. suemon

    Excel Formula to create a traffic light system

    I am trying to evaluate our sales information system and put together a simple way to evaluate how my salespeople are performing in their task of updating and keeping this info clean. I have established measures on "how many" of the different records are "correct" but I need to put these into a...
  6. suemon

    Converting a string array to number

    Hi all, Hoping someone help. I am pulling a string field from a notes database that sometimes presents as an array. I need to convert this to numeric in order to total the values. For example The field may contain only one value but may alternatively contain more than one. Like so. 1200 or...
  7. suemon

    Notes and connecting with Crystal

    I have created a new view in my notes database and am trying to access it via crystal reports in creating a new connection. The view is not visible in the database expert dialog box. Can anyone tell me why? this is the first time I've had a problem and am probably missing something really...
  8. suemon

    Identifying incomplete records

    Hi Hoping someone can help. Am still really new to crystal reports and struggle with even the basics. Am booked in to another course but have a current requirement to resolve. I need to write a basic report in crystal v9 that will identify (and then evaluate) incomplete records within a lotus...
  9. suemon

    Counting Null Fields

    I am working on a report that reports on the number of two different types of records added to a database weekly. One is a Company name field and the other is a concatenated 'client name' field. The data looks like this: Captain Highliner etc. Captain Highliner...
  10. suemon

    Concatenating fields with potential null values

    I am trying simply to concatenate three name fields in a lotus domino database. Any one, or potentially all three (though all three being blank is highly unlikely) may be blank but I still need them to be picked up. For example the three fields are: salutation, first name, last name. If I...

Part and Inventory Search

Back
Top