Click here to Skip to main content
15,902,634 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: 3 tier architecture Pin
bhanu1234525-May-07 22:36
bhanu1234525-May-07 22:36 
AnswerRe: 3 tier architecture Pin
Dave Herren26-May-07 12:35
Dave Herren26-May-07 12:35 
Questiondrop down binding using data table in the grid view Pin
tauras8125-May-07 19:12
tauras8125-May-07 19:12 
AnswerRe: drop down binding using data table in the grid view Pin
Sonia Gupta25-May-07 21:21
Sonia Gupta25-May-07 21:21 
AnswerRe: drop down binding using data table in the grid view Pin
Noman Soofi26-May-07 5:56
Noman Soofi26-May-07 5:56 
GeneralRe: drop down binding using data table in the grid view Pin
Gamzun26-May-07 12:40
Gamzun26-May-07 12:40 
GeneralRe: drop down binding using data table in the grid view Pin
tauras8126-May-07 18:36
tauras8126-May-07 18:36 
QuestionCrystal Report on basis of Dataset having Multiple Tables Pin
Syed Ali Raza25-May-07 19:06
Syed Ali Raza25-May-07 19:06 
hi
I want to use the crystal report in my application on the basis of dataset.
I have done it with dataset having single table but having this error with more than one table :
"Query Engine Error"

Here is the Code:

Dim DS As New DataSet
Dim Cnn As New SqlClient.SqlConnection
Dim DA As New SqlClient.SqlDataAdapter
Cnn.ConnectionString = "data source=sofsrv02\development;" _
& "initial catalog=Northwind;persist security info=False;" _
& "user id=sawd=;workstation id=alirazaooling=false;packet size=4096"
Cnn.Open()
DA.SelectCommand = New SqlClient.SqlCommand("Select A.PRODUCTID,A.PRODUCTNAME,B.SUPPLIERID,B.COMPANYNAME from SUPPLIERS B,PRODUCTS A WHERE A.SUPPLIERID=B.SUPPLIERID", Cnn)

DA.Fill(DS)
Dim oRpt As CrystalReport1 ' create new report object
oRpt = New CrystalReport1 ' create new instance of the report object
oRpt.SetDataSource(DS) ' set the reports data source
CrystalReportViewer1.ReportSource = oRpt ' set the viewers report source



It executes all the code but finally give me error.

Kindly Solve this Problem

Regards

Ali

AnswerCrystal Report on basis of Dataset having Multiple Tables Pin
Syed Ali Raza25-May-07 19:10
Syed Ali Raza25-May-07 19:10 
Questionruntime error Pin
Sonia Gupta25-May-07 18:43
Sonia Gupta25-May-07 18:43 
AnswerRe: runtime error Pin
Guffa25-May-07 23:16
Guffa25-May-07 23:16 
AnswerRe: runtime error Pin
doWhileSomething26-May-07 14:41
doWhileSomething26-May-07 14:41 
QuestionGridview help Pin
eric_tran25-May-07 18:21
eric_tran25-May-07 18:21 
AnswerRe: Gridview help Pin
Gamzun26-May-07 12:46
Gamzun26-May-07 12:46 
QuestionBinding GridView with Oracle DB Pin
shedid25-May-07 10:41
shedid25-May-07 10:41 
QuestionNeed help regarding database in .Net 2.0 Pin
s_a_20026325-May-07 9:01
s_a_20026325-May-07 9:01 
AnswerRe: Need help regarding database in .Net 2.0 Pin
Not Active25-May-07 9:34
mentorNot Active25-May-07 9:34 
GeneralRe: Need help regarding database in .Net 2.0 Pin
s_a_20026326-May-07 5:29
s_a_20026326-May-07 5:29 
GeneralRe: Need help regarding database in .Net 2.0 Pin
Not Active26-May-07 7:01
mentorNot Active26-May-07 7:01 
GeneralRe: Need help regarding database in .Net 2.0 Pin
s_a_20026326-May-07 7:59
s_a_20026326-May-07 7:59 
GeneralRe: Need help regarding database in .Net 2.0 Pin
Not Active26-May-07 8:35
mentorNot Active26-May-07 8:35 
GeneralRe: Need help regarding database in .Net 2.0 Pin
s_a_20026326-May-07 12:53
s_a_20026326-May-07 12:53 
GeneralRe: Need help regarding database in .Net 2.0 Pin
Not Active26-May-07 13:51
mentorNot Active26-May-07 13:51 
GeneralRe: Need help regarding database in .Net 2.0 Pin
s_a_20026327-May-07 1:36
s_a_20026327-May-07 1:36 
GeneralRe: Need help regarding database in .Net 2.0 Pin
doWhileSomething26-May-07 14:37
doWhileSomething26-May-07 14:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.