Recent content by robhc

Thanks for your encouragement and generous offer. I'll give it a try tomorrow... CR - 11 user

thanks LBass. No wonder. I thought the outer join would be handled like a subreport. The problem with not limiting the observations in the record selection criteria is that there will be millions of observations on these patients that I will have to initially pull into the report (since...

thank you both for your reply. It sounds like both of you are saying to choose "exceptions for nulls" instead of "default value for null" in the formula editor. I changed it back and unchecked "convert NULL values to default". It is now finding those right table records that have a blank...

I have two tables joined together with a left outer join and am trying to use isnull(obsdate) to find records in the left table that are missing a corresponding record in the right table, with Obsdate being a date/time field in the right table. I am choosing "default value for nulls" in the...

Hi: I have a table with a date field in the format "1/1/2008" and need to use it in a date selection criteria. Unfortunately, you can see the lengths won't be a consistent MMDDYYYY so I don't see a way to totext it and use a mid formula to reconstruct it. Suggestions? CR - 11 user

thank you for this very helpful response. The secret was the "sumsites" addition to the bottom whileprintingrecords; numbervar sumsites; numbervar sumsites2 := sumsites2 + sumsites; sumsites CR - 11 user

Is there a simple way to continue the running total for a report total? I tried this, //from above //{@display} to be placed in GF1: whileprintingrecords; numbervar sumsites; //adding... numbervar sumsites2 := sumsites + sumsites2 //and then in the report footer: whileprintingrecords...