Hi Alisa,
No, that is why CR has subreports so you can add one or more data sources.
Create a View Server side or Stored Procedure than it will be one data source.
Don
You should be able to do this - lots of folks will use a join to an Excel file to filter their data. What type of file are you connecting to?
First off, I would try using a native Oracle connection instead of ODBC - there are some issues using ODBC with Oracle.
If you remove the file from the report so it's just working off of one data source, does it work? Does the file DSN work to get the data if you don't have a connection to Oracle?
What version of Crystal are you using?
-Dell
Hi Dell,
Lots of people do it but it's not supported. You will get a pop up indicating this and to not use other things like Server side grouping or SQL Expressions.
The problem is it can generate multiple starting points so it may or may not be valid data.
Don
Add comment