Failed to open a Row set
-
crystal reports r new to me i want to make a query using Add Command and want to include a condition Between for a Date. How i can do that? when i done it i create parameters also usin CREATE PARAMETER but when i give value to Date1 and click ok it show error Permission violation, or other nonsecific error and give another error failed to open a rowset. here is my query plz chk and reply. thnx in advance
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 ({?Date1},{Date2})
GROUP BY a.Category,a.[Transaction]; -
crystal reports r new to me i want to make a query using Add Command and want to include a condition Between for a Date. How i can do that? when i done it i create parameters also usin CREATE PARAMETER but when i give value to Date1 and click ok it show error Permission violation, or other nonsecific error and give another error failed to open a rowset. here is my query plz chk and reply. thnx in advance
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 ({?Date1},{Date2})
GROUP BY a.Category,a.[Transaction];I suggest you take your select processing away from CR and move it back to your database where it belongs. When I worked with CR X|, years ago, we would build a stored proc (in SQL Server) that returned the exact set of data to service the report. Testing the data set is dramatically quicker in SQL management studio. Then use a parameterised query to get the data from the proc.
-
I suggest you take your select processing away from CR and move it back to your database where it belongs. When I worked with CR X|, years ago, we would build a stored proc (in SQL Server) that returned the exact set of data to service the report. Testing the data set is dramatically quicker in SQL management studio. Then use a parameterised query to get the data from the proc.
thnx 4 the suggestions but i want to get Date parameters value at run time.what should i do?