I duplicated the SO pick list system report and wanted to add a field that already exists in the included OrderHed table(OrderHeld). I moved that field from the "Excluded Report Fields" to the "Included Report Fields" and saved it. I then opened the new report in Crystal. I can't seem to find a way to get that new field to show up. I've printed a SO pick list and exported it to xml and tried using that as a datasource and tried refreshing the table data. Here is the error I get when trying to use it as a datasource.
Logon Failed. Details: System.Data: The table (Section) cannot be the child table to itself in nested relations.
What am I missing here? I've done this on other reports with no problems but can't seem to figure this one out. Thanks.