Recent content by Andrew111

Thanks for the quick response! I tried using the Add Command feature you suggested, using a select statement. Like this: SELECT locationspec.location, locationspec.assetattrid, locationspec.numvalue FROM maximo.locationspec WHERE locationspec.assetattrid = 'fci' This gave me a simulated table...

I am reporting from an Oracle system called Maximo using Crystal Reports 11. In the Crystal report that I’m building, I have a primary table called WORKORDER with other tables related to it. I have to relate a new table called LOCATIONSPEC. The WORKORDER table and LOCATIONSPEC table have a...

Which connectivity are you using? Stating create new datasource doesn't quite describe it, you can use either ODBC or a direct connection under the Database files." I wish I knew how to find that out. All I know is I'm using the Standard Report Creation Wizard and picking xBASE to start the...

>One thing to keep in mind is that blanks are not the same >as NULLs ( in Crystal and in many database engines) Thanks. This is one of the first particulars I try to learn about a program (how it handles NULLs). There is so much difference out there, and I'm not up to speed with Crystal. And...

Thanks. That got my report working. And thanks for the reminder about checking for spaces. I'm still trying to uncover how Crystal behaves around spaces and nulls (also times and dates). I think running some tests will help me.

I must be overlooking something obvious. But I'm new to Crystal and can't spot it. What I'm trying to do is us an iif() statement to generate a "zz" if a field is blank. But what I get is a blank result when the field is blank. I've tried iif( isnull({WILLIAMS.TO_ART}), "zz"...