ssmith147
Sep 17th, 2008, 07:15 PM
I'm using VS 2008 and the included Crystal Reports. I'm having trouble making a connection to SQL Server 2005 CE.
Has anyone had success making this happen? As it is, I can connect through a dataset, but this leaves me with some limitations. Specifically, I'm having trouble working with datasets with more than one table. I can't set the report to agther data from two reports and I can't select any linked records, or dependent records (not sure if that's the right word) because I don't know how to use this line of code very well:
Me.ReportFile.SetDataSource(DsCustomersReports.Tables(0))
It looks like the Tables() array can only point to one table. Even if it could point to more, I wouldn't know how to set it up to send the right data to the right fields.
I want to connect directly to see if I can get around this problem using the wizards.
Has anyone had success making this happen? As it is, I can connect through a dataset, but this leaves me with some limitations. Specifically, I'm having trouble working with datasets with more than one table. I can't set the report to agther data from two reports and I can't select any linked records, or dependent records (not sure if that's the right word) because I don't know how to use this line of code very well:
Me.ReportFile.SetDataSource(DsCustomersReports.Tables(0))
It looks like the Tables() array can only point to one table. Even if it could point to more, I wouldn't know how to set it up to send the right data to the right fields.
I want to connect directly to see if I can get around this problem using the wizards.