I have a scheduled report that pulls data from a SQL db table and essentially sums traffic counts (enters/exits) by day and store. then joins to a Sybase table to add sales and transaction counts. When i execute the fex in DevStudio the report runs fine, when it's scheduled and emailed the SQL fields are summing at a store level (not breaking daily). I've made sure the actual/usage date values are changed in the master to match yymd as they are in Sybase (they come thru as timestamp from SQL). What am i missing they may cause this? Thanks.

Check WHENCE in each case. There may be duplicate, but different, Masters in your PATH.