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 wOOdy-Soft 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: *

  • Users: dbradley
  • Content: Threads
  • Order by date
  1. dbradley

    select blank records if Convert NULL field to default is turned on

    Hi, I have several reports that require I have the convert database null values to default option turned on. With this option turned on, how can I write a formual to select blank values? The field on my report displays as "0.00" & it is a number data type, but in the select expert this...
  2. dbradley

    incorrect result using null values, or statements and not in list

    Hi, I am looking for some clarity in how Crystal Reports XI handles "or" statements and the "not in ....." statements. I have 2 formulas below, the top one works fine and I get the proper results, but the bottom one returns the same result as the top one -- the fields table1.cd1, table1,cd2...
  3. dbradley

    Converting old QRY files to XI

    I have many old Crystal Queries (QRY) from Crystal 8.0 I would like to have these converted to Crystal XI, but it no longer supports the QRY files. It says I need business views, but I believe those are part of Crystal Enterprise, which I don't own. I guess I could convert them to SQL views...

Part and Inventory Search

Back
Top