Last post May 03, 2012 10:14 AM by cYpH3r x3r0
Apr 29, 2012 08:18 AM|asrkakamilan|LINK
i need some help here...
i'm using vs 2008 and sql server express 2005 creating a website online shop. and i need crystal report to present my report.
how can i select multiple tables to show data? i've already tried some suggested ways before, at the end my data still didn't show up..
thanks a lot :)
Apr 29, 2012 08:55 AM|adeelehsan|LINK
Either during building crystal report, you can select the tables involved in the report, or you can code a stored procedure selecting data from multiple tables and set it as the data source of the report.
If you have trouble writing SQL to select data from multiple tables, let me know the structure of the tables and your required output, I will help you in writing the select query.
May 03, 2012 10:14 AM|cYpH3r x3r0|LINK
above is right, you have to use stored procedures and joins in them, you can also use case statements to pull data from multiple tables.
in my opinion case statement is a better option since joins are always cartesian product and are relatively slower