Visual Basic . NET 2003 with Crystal Report

• • Reply

  14 years ago

  by enzom

  Enzo Calcagno

  Montreal, Canada, Canada

  Joined 15 years ago

  I have 3 tables related (Employee, Employee_Place and Employee_Card)

  I can't find a method to display data in Crystal Report from the 3 tables.  In the main form I have a ComboBoxPlace and a DateTimePicker to select differents Employees and places.  Looking in the Web I found a method that uses DataSet but for only one table and one selection...trying to apply that for my case does not work.  Any idea...?  Thanks

   

   

  Report abuse
• • Reply

  14 years ago

  by ProgramGod

  Eric Haensgen

  illinois, United States

  Joined 16 years ago

  Fellow developer,

     I actually had the same problem, check out this article on Microsofts website.

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/crystlmn/html/crconincorporatingreportsintoapplications.asp

  Hope this helps :)

  -- Eric

  Report abuse
• • Reply

  14 years ago

  by ProgramGod

  Eric Haensgen

  illinois, United States

  Joined 16 years ago

  Sorry, that wasn't the best link, this one is better.

  http://www.freevbcode.com/source/WalkthroughCrystalReport.zip

  NOTE!!!   You use the myDA.FILL command for every table on your dataset

  Example:

  myCommand.CommandText=<SQL Query>
  myDA.Fill(myDS,"table1")
  myCommand.CommandText=<SQL Query 2>
  myDA.Fill(myDS,"table2")
  ...
  
  I know it seems kinda odd, but trust me it works.
  
  
  
  
  
  

   

  --Eric

  Report abuse
• • Reply

  14 years ago

  by enzom

  Enzo Calcagno

  Montreal, Canada, Canada

  Joined 15 years ago

  Ok...thankyou but How you created your DataSet?

  When I created mine on VB I drag the 3 tables and also I created the relations between.

  Then, MySQL looks like:

  Me.MyDataAdapter = New OleDb.OleDbDataAdapter("SELECT Employee.[Emp_ID]," & _

  "  Employee.[Last_Name], Employee.[First_Name],  Employee_Place.[PLace], Employee_Card.[Card]," & _

  "  Employee_Card.[Due_Date] FROM (Employee INNER JOIN Employee_Card" & _ 

  "  ON Employee.[Emp_ID] = Employee_Card.[Emp_ID]) INNER JOIN Employee_Place" & _

  "  ON Employee.[Emp_ID] = Employee_Place.[Emp_ID]" & _

  "  WHERE ( (Employee_Place.[Place] = @MyPlace) AND (Employee_Card.[DueDate <= @MyDate))", MyConn)

   

  In the form I have a ComboBox that displays the differents places and a DateTimePicker...it should filter the report.

  Actually it shows me every record that is filled on the DataSet...!

  I don't see just what I 'm looking for.

   

  Enzo

  Report abuse