Allday Consulting's Peachtree and QuickBooks Support Boards

I created a CR that includes account balances and budgets. When I use an inner join to link Chart to Budget_Details some of my accounts don't show presumably because they are missing budgets. A right outer join that includes all chart entries displays the accounts, with empty (null?) budgets. However, when I go to budget maintenance in Peachtree, there are budgets entered in all the accounts.

This makes me think that somehow Peachtree links differently for their canned reports than I can link in CR. Or perhaps the linking field is corrupted for some of the accounts. I'm stumped. I've run the data validation routine to see if that would clean things up, but it doesn't seem to make a difference.

Any help would be greatly appreciated.

Thanks,
Dan

I'm afraid that explicit Crystal/data help is hard to find. The best advice I can give you is to go into the Peachtree help file (NOT the Crystal help file) and do a Search on "DDF" (without the quotes). That should take you to the internal tables which give a fair amount of detail, and may help with the linking.

Also, there's a large number of canned reports within CR for PT, you can find them in the formula editor (I believe the category is Peach, it's been a while)