This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I have an application that has many reports, all created using Active Reports. Currently, we supply each of these reports with a DataSet, with the DataSet populated with pure SQLClient code. I would like to remove the SQL code so the application is less database dependent. My plan is to use the Lightspeed Find<T> option to create a IList, then pass this to the reports at runtime. But Active Reports does not seem to like the IList. So I was wondering if there is a simple way I can get the Find to return a DataSet, or convert an IList to a DataSet. Thanks |
|
|
Hi, I think this may help you out with that conversion: http://towardsnext.wordpress.com/2009/04/16/convert-ilist-list-to-dataset-with-child-tables-and-relations/
Scott |
|
|
There's no way to get Find to return a DataSet. You would need to populate the DataSet manually from the collection/query (thanks for the link, exm!). That said, I'm surprised that a reporting tool would require a DataSet and would be unable to handle a strongly typed collection. This guy seems to have found a way to get ActiveReports working with LINQ -- he's using LINQ to SQL but I guess the same techniques should work with LINQ to LightSpeed or the LightSpeed Find API: http://tiredblogger.wordpress.com/2007/07/16/using-linq-as-a-activereports-datasource/ And according to the blurb at http://www.codeproject.com/Catalogs/2680/ActiveReports.aspx, ActiveReports supports "any entity that supports the iList [sic] interface." So it may be worth investigating this further with the ActiveReports folks. |
|