Crystal Reports problem

95 pts.
Tags:
Crystal Reports 8
SQL Server 2005 Express Edition
VB.NET 2005
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!!!!


Software/Hardware used:
VB.NET 2005, SQL Server 2005 Express Edition, and Crystal Reports 8

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following