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!

Register Log in
  • Congratulations gkittelson 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: *

  1. JohnGa1

    SQL expression sometimes returning null instead of data

    I'm doing some further investigating and will post. I assumed that more than one value would return an error, if this is not the case, then multiple values could be the problem.
  2. JohnGa1

    SQL expression sometimes returning null instead of data

    Sorry, forgot to mention, I'm running Crystal XI and SQL Server 2008.
  3. JohnGa1

    SQL expression sometimes returning null instead of data

    I'm using the following SQL expression to fill a field in a report: (select "inc_cat_1"."inc_cat_sc" from "inc_cat" as "inc_cat_1" where "incident"."incident_id" = "act_reg"."incident_id" and "act_reg"."cause_id" = "inc_cat_1"."inc_cat_id" and "inc_cat_1"."inc_type" = 'c')...
  4. JohnGa1

    x

    Yes, its Crystal XI and SQL 2008. Thankyou, that seems to have worked perfectly. I'm sure I tried isnull and couldn't get it to work. Obviously doing something wrong, can't remember now. Thanks again.
  5. JohnGa1

    x

    Apologies for the thread title, I had some difficulties posting. if possible, could it be changed to "SQL expression incorrectly returning null value".
  6. JohnGa1

    x

    I have a SQL expression something like this: (select max("act_reg"."act_rmk" + "act_reg"."act_rmk" + "act_reg"."act_rmk" + "act_reg"."act_rmk") from "act_reg" where "incident"."incident_id"="act_reg"."incident_id") which is extracting text from the four "rmk" fields and placing them in a...

Part and Inventory Search

Back
Top