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 gmmastros 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: *

  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

    sub reports within crystal XI

    Yes I have tried various things. Subreports are in separate detail sections. Underlaying just seems to make it look much worse. putting the subreports into the same detail section also doesn't alter the results. Think I am just going to scrap and try rewrite. Like I said, I've never seen this...
  4. 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...
  5. 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...
  6. suemon

    Excel Formula to create a traffic light system

    Wasn't asking for you to do this for me!!! You are right... this is a place where we are supposed to learn, it's just that some of us are not quite as advanced as you are. Absolutely no need for the tone but thanks for your time.
  7. suemon

    Excel Formula to create a traffic light system

    Got that but it is still not colouring the column correctly. Don't know what I'm doing wrong. Am using the Formula Is and putting your formula into the third condition (which colours cell red) Is this wrong.?
  8. suemon

    Excel Formula to create a traffic light system

    The solution you give seems to turn the cells red with the word 'true' appearing regardless of anything else. example col 1 = 2% (green) col 2 = 6% (amber) col 3 = 21% (red) col 4 = =+(Col1+Col2+Col3)/3 result is 10 which turns it amber. How do I apply this type of formula to the 4th col in...
  9. suemon

    Excel Formula to create a traffic light system

    You will have to forgive me but this is the first time I have tried this and maybe I am not explaining correctly... let me try again. Also I am trying to keep the example simple bear with me... I have no trouble conditionally formatting the first three columns. They have three conditions each...
  10. suemon

    Excel Formula to create a traffic light system

    I understand that and have already done it. Maybe I'm just not seeing the forest for the trees. Here is what I am trying to do. Columns 1 through 3 = percentage of correct record types A,B,and C conditionally formatted to turn red, amber or green dependant on value Column 4 needs to be...
  11. 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...
  12. suemon

    Converting a string array to number

    Works a treat!!!! Only thing I did different was reset the sumarray to zero so that it didn't give cumulative totals. (see below) Thanks Lbass ! You have saved the day yet again! numbervar i; numbervar j := ubound(split({table.stringarray},",")); numbervar sumarray :=0; for i := 1 to j do(...
  13. 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...
  14. suemon

    Notes and connecting with Crystal

    Hey Pascal, Thanks for sticking with me on this. Yes the first column is actually a modified date. @Date(@Modified) and it is categorized and sorted. But this is true of the default view as well so that can't be the difference.
  15. suemon

    Prevent copying

    Tried through the properties tab and it doesn't work. Cannot access the text in body field as it is greyed out. Has anyone found a way to do this without the use of other software?
  16. suemon

    Notes and connecting with Crystal

    Yes it is
  17. suemon

    Notes and connecting with Crystal

    No. should have mentioned that. Definitely not private. In fact copied it from an existing standard view and made alterations.
  18. 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...
  19. suemon

    Identifying incomplete records

    Yes I mean it's greyed out. Sorry must be my foreign accent. I tend to confuse people all the time. And I am definitely using a view as datasource. Had to write it in lotus designer myself.
  20. suemon

    Identifying incomplete records

    Tried that. Show SQL is an unavailable option on the menu though. Could it be that my crystal v is V9 Professional and that this feature isn't avail? Is there any other way to view it that you know of?

Part and Inventory Search

Back
Top