Cannot Create DataSet [message #196631] |
Tue, 27 February 2007 15:17 |
Eclipse User |
|
|
|
Originally posted by: dhook.reveregroup.com
I am trying to create a dataset with the following SQL
select Organization.OrganizationName,
AdjustmentCode.Description,
Type.TypeDescription,
Adjustment.Adjustment_ID,
Adjustment.CreateDate,
Adjustment.Buyer_ID,
org.OrganizationName,
Salesman.Name,
Invoice.Invoice_ID,
Invoice.InvoiceDate,
Invoice.Amount,
SUM(Adjustment.Amount) as TotalAmount,
SUM(CASE WHEN DATE_SUB(CURDATE(), INTERVAL 30 DAY) <=
Adjustment.CreateDate THEN Adjustment.Amount ELSE NULL END) AS 'amt_1_30',
SUM(CASE WHEN DATE_SUB(CURDATE(), INTERVAL 31 DAY) >=
Adjustment.CreateDate AND DATE_SUB(CURDATE(), INTERVAL 60 DAY) <=
Adjustment.CreateDate THEN Adjustment.Amount ELSE NULL END) AS 'amt_31_60',
SUM(CASE WHEN DATE_SUB(CURDATE(), INTERVAL 61 DAY) >=
Adjustment.CreateDate AND DATE_SUB(CURDATE(), INTERVAL 90 DAY) <=
Adjustment.CreateDate THEN Adjustment.Amount ELSE NULL END) AS 'amt_61_90',
SUM(CASE WHEN DATE_SUB(CURDATE(), INTERVAL 91 DAY) >=
Adjustment.CreateDate THEN Adjustment.Amount ELSE NULL END) AS
'amt_over_90'
from Adjustment
left join Seller on Adjustment.Seller_ID = Seller.Seller_ID
left join Organization on Seller.Organization_ID =
Organization.organization_ID
left join AdjustmentCode on Adjustment.AdjustmentCode_ID =
AdjustmentCode.AdjustmentCode_ID
left join Type on Adjustment.Status_ID = Type.Type_ID
left join Buyer_Salesman on Adjustment.Buyer_ID = Buyer_Salesman.Buyer_ID
left join Salesman on Buyer_Salesman.Salesman_ID = Salesman.Salesman_ID
left join Invoice_Adjustment on Adjustment.Adjustment_ID =
Invoice_Adjustment.Adjustment_ID
left join Invoice on Invoice_Adjustment.Invoice_ID = Invoice.Invoice_ID
left join Buyer on Adjustment.Buyer_ID = Buyer.Buyer_ID
left join Organization as org on Buyer.Organization_ID =
org.Organization_ID
group by Organization.OrganizationName, AdjustmentCode.Description,
Type.typeDescription
When I hit Finish in the Query window, I get an error:
A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Model
Plug-in ID:org.eclipse.birt.report.model
Version:2.1.2.v20070205-1728
Error Code:Error.PropertyValueException.VALUE_REQUIRED
Error Message:The value of the property "name" is required.
The SQL runs in my database tool just fine. I am using MySQL 5.0
THanks ....
|
|
|
Powered by
FUDForum. Page generated in 0.05363 seconds