Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Joins...
- Thread starter sam1one
- Start date
synapsevampire
Programmer
Please remember to always post your software version and the databsae used in any post to software forums.
There are many ways to add data sources to Crystal, if you're using the Crytsal GUI, right click the link and selct options, you'll see the available types of joins for *that* database, which varies or course. A Left Outer is a one to many, as is a right outer.
By SQL, I assume you mean SQL Server. SQL is a database programming language.
I would create Views or SPs on the database as the datasources as this promotes reusability and simplifies maintenance, or if you have CR9 or above, you can paste in existing SQL using the Add Command.
But again, I'm only guessing because you didn't provide anything technical.
Look at thre successful posts here, almost none of them have a single sentence, and the best include:
Crystal version
Database/connectivity used
Example data
Expected output
Also note that Crystal has an extensive programming language within, and if you use the Crystal GUI (database expert) properly you can pass the where clause of the SQL to the database.
Hopefully something here resolves your concern and you have a better understanding of Crystal.
-k
There are many ways to add data sources to Crystal, if you're using the Crytsal GUI, right click the link and selct options, you'll see the available types of joins for *that* database, which varies or course. A Left Outer is a one to many, as is a right outer.
By SQL, I assume you mean SQL Server. SQL is a database programming language.
I would create Views or SPs on the database as the datasources as this promotes reusability and simplifies maintenance, or if you have CR9 or above, you can paste in existing SQL using the Add Command.
But again, I'm only guessing because you didn't provide anything technical.
Look at thre successful posts here, almost none of them have a single sentence, and the best include:
Crystal version
Database/connectivity used
Example data
Expected output
Also note that Crystal has an extensive programming language within, and if you use the Crystal GUI (database expert) properly you can pass the where clause of the SQL to the database.
Hopefully something here resolves your concern and you have a better understanding of Crystal.
-k
- Status
Similar threads
- Locked
- Question