Recent content by QPRphil

The Nulls have it! Thanks for your replies everybody. The not isNull step worked just fine. I will have to remember that in the future. Thanks again to all. Phil

I have defined a new formula field called Category, that can have one of three values based on the value of three different database fields. - If {field1}="x" then "Legacy" else If {field2}="x" then "Vibe&quot...

Thanks very much for the assistance folks.

Hi, I am using Crystal 8.5 and want to run a daily report listing entries from a Remedy database that were created on the previous working day (Monday - Friday). I have created a formula field to calculate the previous day [DateAdd ("d",-1,CurrentDate )], but if this is a Saturday or...

Thank you Naith. I was beginning to wonder if sub-reports were an option worth pursuing on this. My background is AS400, very traditional, so some of these things are a bit of a stretch for me. For your first solution, where abouts would you expect me to be putting that SQL? In AS400 terms I...

I have a report in which I have one large file, something like 250,000 records, of which I am selecting 3,000, which I wish to link to a much bigger file, a couple of million records in all, of which I suspect I will be selecting about 20 for each record selected from the first file. I actually...

Hi, I am writing my first ever Crystal Reports over a Remedy database, my back ground is AS400. One of the fields I want to access is defined as type 'memo'; not really sure what this means in database terms. The entries in this field are a series of department names and date/time stamps. I want...