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.
Please Mark As Answer if it helped.
MCPD ASP.NET 4.0 and 3.5, MCTS WSS, MOSS, SharePoint 2010, MCT
Microsoft Community Contributor Award 2011
Marked as answer by Ming Xu - MSFT on May 08, 2012 01:07 PM
asrkakamilan
Member
14 Points
25 Posts
select from multiples tables
Apr 29, 2012 08:18 AM|LINK
hi all
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 :)
adeelehsan
All-Star
18573 Points
2789 Posts
Re: select from multiples tables
Apr 29, 2012 08:55 AM|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.
MCPD ASP.NET 4.0 and 3.5, MCTS WSS, MOSS, SharePoint 2010, MCT
Microsoft Community Contributor Award 2011
cYpH3r x3r0
Member
327 Points
107 Posts
Re: select from multiples tables
May 03, 2012 10:14 AM|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
http://msdn.microsoft.com/en-us/library/ms181765.aspx