Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple Reports using filters
Message
De
12/09/2006 16:25:04
 
 
À
12/09/2006 15:06:07
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Versions des environnements
Environment:
VB 8.0
Database:
Visual FoxPro
Divers
Thread ID:
01153132
Message ID:
01153148
Vues:
15
Hi, Erik,

As you've discovered, you can't pass a DataView to Crystal Reports.

However, in VS2005, you can do the following, to filter your datatable and pass a subset datatable to Crystal:
dtMySourceTable.DefaultView.RowFilter = "User = 'Erik'";
DataTable dtMyFilteredTable = dtMySourceTable.DefaultView.ToTable("MyFilteredTableName");
And then push dtMyFilteredTable into Crystal.

The new ToTable() method in ADO.NET 2.0 is very powerful - check out the overloads for it, it allows you to do the equivalent of SELECT DISTINCT on rows.

Let me know if that helps, or if you need anything more.

Kevin
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform