Question

I am triying to fill a report with datatables. The report has two tables which are he same but with diferent alias. In c# I create a datatable for one of them with the records that must be shown and another datatable with the other table info. Crystal only gets info from the first datatable to fill the two tables so the shown data is wrong. Can I fill the two tables that are the same but diferent alias with two diferent datatables?

这是我昨天所写的同样问题,但却是imp。

感谢大家,

Answer 1

Crystal Reports does support duplicate tables with aliases. The problem may be the link. If your trying to display the two tables on the report both there s no JOIN or WHERE statement.

该表需要与自己挂钩。 http://www.wellho.net/forum/The-MySQL-Relational-Database/Joining-a-table-to-it.html 页: 1

select * from tbl1 as child join tbl1 as parent on parent.primarykey = child.foreignkey;

友情链接