First, let me complain about your original post.
One of my pet peeves with this forum is when posters don't state everything in the post. I should not have to get part of what the issue is from the post header and the some from the post itself.
Second, have you ever done this before? I'm not convinced Crystal Reports can actually create temp tables.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]