Search results for query: *

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

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

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

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

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

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.

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

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

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

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

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

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

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

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.

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?

Yes it is

No. should have mentioned that. Definitely not private. In fact copied it from an existing standard view and made alterations.

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

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.

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?