RecordSelection in Crystal Reports
-
Hi, I have a problem: I have an .NET application that uses Crystal Reports as reporting tool. I need to filter records. The problem is that I have just dataView.RowFilter string but Crystal reports do not accept it becouse they have their own syntax for selecting records. Is there any way i can give normal MS SQL syntax string to filter records? (I mean where clouse) Or I need to create translator from SQL syntax to Crystal syntax? Do not offer to use ADO.NET datasets, they work very slow. Thanx
-
Hi, I have a problem: I have an .NET application that uses Crystal Reports as reporting tool. I need to filter records. The problem is that I have just dataView.RowFilter string but Crystal reports do not accept it becouse they have their own syntax for selecting records. Is there any way i can give normal MS SQL syntax string to filter records? (I mean where clouse) Or I need to create translator from SQL syntax to Crystal syntax? Do not offer to use ADO.NET datasets, they work very slow. Thanx
MMm.... well you can set that DataView in a new DataTable, and pass it as parameter to the Report as a dataset parameter. HTH Braulio
-
Hi, I have a problem: I have an .NET application that uses Crystal Reports as reporting tool. I need to filter records. The problem is that I have just dataView.RowFilter string but Crystal reports do not accept it becouse they have their own syntax for selecting records. Is there any way i can give normal MS SQL syntax string to filter records? (I mean where clouse) Or I need to create translator from SQL syntax to Crystal syntax? Do not offer to use ADO.NET datasets, they work very slow. Thanx
You can't use a DataView as a datasource. It's supposed to work, but my contact at Crystal told me that there is a bug in the current release that doesn't let it connect properly. Hopefully they will fix this in a future release. If you want to see all the ways you can connect a datasource to a report then check out Chapter 14 of my free online ebook. ----------------------- You are right. CR works with datasets, but not dataview. I discovered this while working on my book and discussed it with tech support. They worked on it and decided that there must be a casting error in their code and they created a KB issue for it. Hopefully it will be fixed in a future service pack.