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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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')...- JohnGa1
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
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...- JohnGa1
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 4 Other topics
