i'm working with VB .Net
i'm creating a crystal report using dataset
have used OledbDaAdapter, and have to filter the records between two date. which i cant give while giving query. as with OleDbDaAdapter we give query with mark
for ex: SELECT SpecialChoice.Menu, SpecialChoice.Kcode, SpecialChoice.Veg, SpecialChoice.Description, F_Detail.fDate, F_Detail.paxG, F_Detail.paxE, F_Detail.LType, F_Detail.Venue, F_Detail.FPCode FROM F_Detail INNER JOIN SpecialChoice ON F_Detail.Mcode = SpecialChoice.MCode WHERE (F_Detail.fDate = )
but i have to select between two dates. dataset created from this adapter i used in Crystal Report. i want to know that how can i filtered the dataset between two tables.
please help me...
Thanks
Filtering the data in Dataset
Hernan Gatta
you can filter any records from any table by using ReportDocument object and pass to it your desire parameters from your source code. even you can make filter at your crystall environment. add two tables with two different connection to your report then at "selection formula" you can select any fields from any tables and compare them.
be success. Ahmad