This question is locked. New answers and comments are not allowed.
I noticed that there are currently plans underway to better integrate OpenAccess with Telerik Reporting. I am excited to see how this will work. In the meantime, I need to get some reports working right now.
I have a view in my database that I use for reporting. It gathers values from multiples tables, joins them together and returns a linear result set. For example, the following returns a customer's id, first name, last name, order number, order date and product by joining data from three tables:
Forgive me if this is already documented. However, I cannot seem to find any proper documentation or examples on how to handle this scenario. Do I somehow create a read-only class that has the same fields that are returned by the view?
I have a view in my database that I use for reporting. It gathers values from multiples tables, joins them together and returns a linear result set. For example, the following returns a customer's id, first name, last name, order number, order date and product by joining data from three tables:
select |
c.Id, c.FirstName, c.LastName, co.OrderNumber, co.OrderDate, coi.Product |
from |
Customer c |
inner join |
CustomerOrder co on c.Id = co.CustomerId |
inner join |
CustomerOrderItem coi on co.Id = coi.CustomerOrderId |
where |
co.OrderDate between @StartDate and @EndDate |
order by |
co.OrderDate, c.FirstName, c.LastName |
Forgive me if this is already documented. However, I cannot seem to find any proper documentation or examples on how to handle this scenario. Do I somehow create a read-only class that has the same fields that are returned by the view?