failed to open a rowset
-
i m new to work with crystal reports i write a query in sqlcommand which is an option in addcommand DATA BASE EXPERT. i have two parameter Date and Date2 i want the ouput between these parameter but it show errors when i finished it. **"failed to open a rowset"**plz chk and reply
SELECT Sum(b.TotalSale*b.Price) AS total, a.Category , a.[Transaction]
FROM TransactionType AS a INNER JOIN CouponTransaction AS b ON a.TransactionTypeID = b.TransactionTypeID
where b.TransactionDate BETWEEN ({?DATE}) AND ({?DATE2})
GROUP BY a.Category,a.[Transaction]; -
i m new to work with crystal reports i write a query in sqlcommand which is an option in addcommand DATA BASE EXPERT. i have two parameter Date and Date2 i want the ouput between these parameter but it show errors when i finished it. **"failed to open a rowset"**plz chk and reply
SELECT Sum(b.TotalSale*b.Price) AS total, a.Category , a.[Transaction]
FROM TransactionType AS a INNER JOIN CouponTransaction AS b ON a.TransactionTypeID = b.TransactionTypeID
where b.TransactionDate BETWEEN ({?DATE}) AND ({?DATE2})
GROUP BY a.Category,a.[Transaction];How is this a C# question ?
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
How is this a C# question ?
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
sorry i can't find a forum for crystal reports so i send my query in this forum plz help
-
sorry i can't find a forum for crystal reports so i send my query in this forum plz help
I'd guess the SQL or database forums are appropriate, you posted SQL.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.