on 09-26-2008 2:20 AM
can union command will work in crystal report? I tried and it did not work. if it can work than what will be syntax for that. thanks!
regards,
mansoor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have to do it from within a SQL Command using the SQL syntax that matches you particular RDBMS.
Jason
where that would be in crystal?
Open the Database Expert.
On the right hand side of the screen, expand your data source until you see the "Add Command" option
That will open the Command window.
Enter your SQL code there.
Quick tip: Try to get everything into one SQL Command. Mixing Commands with tables or even other commands can cause major performance issues.
Jason,
thanks for your help, I was able to create a report using SQL Command tool. Much appreciated!
Mansoor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.