>it doesn't seem to like it. If I clone the dataset into a table it seems to like it.

I haven't use Crystal before so I can't be sure, but most report generator I worked with uses Datatable instead of Dataset since they only work with one master table. A Dataset can have n Datatable and the report generator wouldn't know which one is the master table.