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
adeelehsan
All-Star
18319 Points
2746 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