I have a simple Crystal Reports budget that pulls account number, name, and transactions from QuickBooks and pulls the budget amounts for those accounts from an Access database (link=account #) since QB's doesn't have a budget format that will work for us.

My problem is that all the accounts have a respective budget in Access but not all the accounts in QuickBooks have transactions. If I insert a running total field to total the YTD expenditures for all filtered account transactions (filtered for the fiscal year dates and account number range), my accounts with no activity in QB's are removed from the report. It looks as though we have a smaller account list and budget than we actually do. When in actuality it has removed them from the list along with their data.

Is there a way to have those accounts remain so that their budgeted amounts can be viewed?

Any help would be greatly appreciated.

I changed the link of the budget table to "left outer join" and it worked fine. I then used the select expert to select those 'transaction dates' in this fiscal year (between 7/1/07 and 6/30/08) and it truncated my report to include only those accounts that have transactions. I tried to force none...to...from...and both to no avail. The moment I delete the cherry picker, it works like one would expect.

I'm sure I'm missing something simple.