private void BuildProductsReport()
{
// request data from OData service
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12; // force Tls12
var service = new DemoODataService.DemoService(ODataUri);
// select all categories and products of each category
var categories = service.Categories.Expand(c => c.Products).Execute();
var products = (
from c in categories
from p in c.Products
select new
{
CategoryID = c.ID,
CategoryName = c.Name,
ID = p.ID,
Name = p.Name,
Description = p.Description,
ReleaseDate = p.ReleaseDate,
DiscontinuedDate = p.DiscontinuedDate,
Rating = p.Rating,
Price = p.Price,
}).ToList();
// load report definition from resources
Assembly asm = Assembly.GetExecutingAssembly();
using (Stream stream = asm.GetManifestResourceStream("Binding.Resources.Reports.flxr"))
_report.Load(stream, "Products");
// assign dataset to the report
_report.DataSource.Recordset = products;
}
private void BuildCategoriesReport()
{
// request data from OData service
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12; // force Tls12
var service = new DemoODataService.DemoService(ODataUri);
// select all categrues
var categories = service.Categories.Execute().ToList();
// load report definition from resources
Assembly asm = Assembly.GetExecutingAssembly();
using (Stream stream = asm.GetManifestResourceStream("Binding.Resources.Reports.flxr"))
_report.Load(stream, "Categories");
// assign dataset to the report
_report.DataSource.Recordset = categories;
}
