Results 1 to 1 of 1

Thread: Need to enter SELECT statement into CR11 for VB.Net during designtime

  1. Aug 7th, 2006, 01:40 AM #1
    superfrog
    superfrog is offline

    Thread Starter
    New Member
    Join Date
    Oct 2005
    Posts
    15

    Need to enter SELECT statement into CR11 for VB.Net during designtime

    Hi all,

    I'm using CR11 with VB.net and MySQL and need to pass a recordset similar to the following into the report:
    Code:
    "SELECT Sales.InvoiceNo, 
Product.ProductName, StaffPurchase.UName, StaffVerify.UName FROM Sales 
LEFT JOIN Product ON Sales.ProductID = Product.UID LEFT JOIN StaffProfile 
StaffPurchase ON Sales.PurchaseID = StaffPurchase.UID LEFT JOIN 
StaffProfile StaffVerify ON Sales.VerifyID = StaffVerify.UID ORDER BY 
InvoiceNo"
    The Sales database (MySQL) has (among others) the following fields:
    InvoiceNo VARCHAR(12)
    ProductID VARCHAR(10)
    PurchaseID VARCHAR(10)
    VerifyID VARCHAR(10)

    The Product database (MySQL) has (among others) the following fields:
    UID VARCHAR(10)
    ProductName VARCHAR(50)

    The StaffProfile database (MySQL) has (among others) the following fields:
    UID VARCHAR(10)
    UName VARCHAR(50)

    - how do I enter the SELECT statement above into the Database Expert in CR11 during design time, so I can drag/drop fields such as StaffPurchase.UName and StaffVerify.UName into the *.rpt?
    - would using aliases help?
    Last edited by Hack; Aug 7th, 2006 at 09:42 AM. Reason: Added [code] [/code] tags for more clarity.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width