Can Anyone help me with trying to generate a dataset with a table join so that I can PUSH it to a crystal report? I cant seem to get the PUSH method to work when my SQL has a table join though it works fine with just one table.
The error I get is a "Query engine error" when I try a multi-table join ( the sql works perfectly fine otherwise so I know that is not a sql problem) i think it is due to the datset name not being the same in the dataset's table header and the statement
DataSet ds=new DataSet("MY_TABLE");
how do i join 2 tables in a dataset
any links/ sugestions please?
using VIsual studio .NET 2003 and crystal reports 8
The error I get is a "Query engine error" when I try a multi-table join ( the sql works perfectly fine otherwise so I know that is not a sql problem) i think it is due to the datset name not being the same in the dataset's table header and the statement
DataSet ds=new DataSet("MY_TABLE");
how do i join 2 tables in a dataset
any links/ sugestions please?
using VIsual studio .NET 2003 and crystal reports 8