here's the coding for my crystal report display [code] Imports CrystalDecisions.CrystalReports.Engine Dim crRep As New ReportDocument Dim objItemSale As New ItemSale(strKey) Dim dsSet As New DataSet("InvoiceData") Try

crRep.Load("G:Format BackupLahiru DocumentsVisual Studio 2005 ProjectsSpringsSysSpringsSyscrSaleIn… dsSet = objItemSale.GetSaleData() crRep.SetDataSource(dsSet) crvReport.ReportSource = crRep crvReport.Refresh()

Catch ex As Exception MessageBox.Show(ex.Message, "Error viewing Report", MessageBoxButtons.OK, MessageBoxIcon.Error)

Finally crRep = Nothing End Try [/code] The above code is written in the report viewer form's load event method. 'this is the query for my dataset (used in objItemSale.GetSaleData(string) function) SELECT ItemSale.BillNo, ItemSale.IncomeID, Income.IncomeDate, Income.IncomeValue, ListItem.ItemID, Item.ItemName, ListItem.SaleQuantity, ListItem.SalePrice, ItemSale.SaleItemListID FROM Income INNER JOIN ItemSale ON Income.IncomeID = ItemSale.IncomeID INNER JOIN SaleItemList ON ItemSale.SaleItemListID = SaleItemList.SaleItemListID INNER JOIN ListItem ON SaleItemList.SaleItemListID = ListItem.SaleItemListID INNER JOIN Item ON ListItem.ItemID = Item.ItemID WHERE ItemSale.BillNo = ' " & Me.BillNumber & " ' " Me.BillNumber is a property of one of my classes. it holds a bill number in an Item Sale invoice. when I run this on SQL server it gives the correct result but in the crystal report it gives the same result as the report preview in the report designer. no matter what parameter bill number I use.

I also tried using an data table instead of an data set as the report data source. When I try to view the report I got this error.

 

[strong]"Cannot determine the qureries necessary to get data for this report. [/strong]

[strong]Details: This query cannot be performed. The link order requires Many to One query configuration which is not supported. Please rearrange the links.[/strong]

[strong] Failed to open a rowset. Error in File C:DOCUME~1LahiruLOCALS~1TempcrSaleInvoice {6A7FB2D4-E5A7-458E-83FB-BB22C3E5629E}.rpt: Failed to open a rowset." [/strong] Please help!!!!