I'm using CR XI to create reports from Sage Master Builder (SMB). SMB uses Visual Fox Pro as their database source. I can open and run reports on any one table using fields from that table. When I try to add more than one table to my report I get the following warning: "More than one datasource or a stored procedure has been used in this report. Please make sure that no SQL Expression is added and no server-side group-by is performed." I click OK and then report is blank except for field names. To my knowledge there are no SQL Expressions, I haven't addded any. If someone knows how to check I'll be happy to do so. The same for the server-side group-by.
Can someone please point me in the right direction as to get past this warning and generate a good report?
Thanks,
Ken