If the {?GetYear} and {?GetWeekNo} parameters are what they look like, either numbers or strings, then your formulas are incorrect. DatePart, both in SQL and in Crystal Reports, are expecting...

Another option that I got from a search some time ago is to use a Case statement in the Where section. Based on your code so far, add a set...

In general, also remember that a Left Outer join can return FEWER records, if you use a Where clause that restricts what is returned from the additional table. Anything in...

I've been writing Crystal Reports for 8 years now, and besides having to work around a number of issues (like the orphaned record parts when a Group Footer splits across...