Search results for query: *

Hi all . . . again, I just know I'm doing something stupid here, but I am using Crystal Reports XI on Windows XP. I am pulling against a local Access DB on my desktop. I have designed a report form with a parameter that allows me to select the lab number to see when I refresh the form. I...

Thank you so much for your help and patience. This information has been more helpful than you'll ever know! Kathy

Should I put the Trim in? And where? kathy

Hi guys, I tried this, based on some of your suggetions and it works!! If Cstr({GermReadings.FinalGermDate})= "" then "**Germination will follow" Else " " I did have to change the data from date/time to string. Will this be bulletproof and should I put the Trim in and, if so, how? kathy

This time is says "the ) is missing" although it looks like they're all there to me. Would using something like: If ({GermReadings.FinalGermDate}) = (NullDate,Nulltime) then "**Germination will follow" Else " " work? I found the (NullDate,NullTime) info in the help menu, but I'm not sure...

Hi Mintman, I get an error that says "the formula result must be a boolean". Is there something special about this being a date/time field that is complicating things? Kathy

Hi again, I am using CR XI for a report pulling from an MSAccess DB. I have a text box that I want to fill with the text "Germination to follow" based on whether or not a data/time field in the DB is or is not null. I have tried the following formula: If Isnull...

I have found a way to put a formula into the detail section to supress it under certain conditions: If {LabNumber.SampleType} = "Mixture" Then True but when previewed, the entire report produces no data. Any idea why this is happening?

Could I do something like If isnull({tablefield1}) and isnull({tablefield2}) then true else false I have found that I need to put another field in there to accomodate some reports.

Hi all, I am using Crystal Reports XI with Windows XP and am fairly new to Crystal Reports, even though I have used it for years as part of MS Access. I have a report with several detail section. One of the sections, I would like to have print/show based on the presence/absence of data in one...

You're suggestion about the text box worked beautifully! Thanks so much. Kathy

I have a report utilizing fields from a database to provide an address for mailing the report. The fields are arranged thus: CompanyName AttentionTo Address These fields are presently in the details a section and pull data straight from the database. Sometimes, there is no data in the...

Thanks, lbass, unfortunately, this field is part of the address to which the report is going to be sent. Could I use the "if isnull" function to do something with this? kathy

I have Crystal Report XL running on Windows XP. I have a field in a form that I want to not print if the field is empty. But, what I would really like is for the space it occupies not to be blank and there to be no gap between the line above this field and the line below. Is this possible...

Hi, I'm using Crystal Reports XI with an Access DB on a local machine. I have a report in which for each lab sample there are two company names in the database. I want to be able to print one company name on the left side of the form with the address, etc. and if there is a second company...

Could be. This computer is on a state government system and the Db is on a server. Sometimes weirdness happens. I'll work on it a little more and see what happens. Thanks for your help. Kathy

I forgot to mention that these are MSAccess tables in an access database. The message I get when I try to create the link is: "No unique index found for the reference primary table" The primary table has a unique index, but not the field I am trying to join the second table to. Is this...

Hi guys, I have a question regarding linking tables together. I've run out of my expertise for this, so I'm hoping someone here has a solution (as you always do - almost). I have a table (LabNumber) with a primary key (OldLabNumber) and a field (CompanyID). I want to link that to a table...

Hi all, I'm new to this forum and new to Crystal Reports, so please forgive stupid questions. I have a report in Crystal Reports XI. It has three detailes sections with some subreports. For some reason I can't solve, the three details sections repeat once when the form is viewed in preview...

This is great. Thanks so much