Reports VS 2010, drill down ICollection

Question

I have the following Linq, its linked to a report.

Resuming it's a report of bills, but bills have multiple products, so i have an ICollection of Products. The idea is to show each bill with their multiple Products in a single report using drilldown (trying to avoid subreports).

public class BillsDataSet
{
    public int IDGestion { get; set; }
    public string Comentario { get; set; }
    public ICollection<BillProduct> Products { get; set; }
    public decimal Monto { get; set; }
    public string Personal { get; set; }

    public static List<BillsDataSet> BillsPorFecha(DateTime dtFechaInicial, DateTime dtFechaFinal)
    {
        Context db = new Context();

        List<BillsDataSet> BillsDataSet = (from p in db.Bill
                                               select new BillsDataSet()
                                               {
                                                   IDGestion = p.IDBill,
                                                   Comentario = p.Historial.FirstOrDefault().Comentario,
                                                   Products = p.BillProduct,
                                                   Monto = p.Total,
                                                   Personal = p.Historial.FirstOrDefault().CodigoEmpleado
                                               }).ToList();
        return BillsDataSet;
    }
}

I'm getting this error on the web page report...

What I want to achieve is to have a drilldown on Products to hide/show all the Products related to the bill...

you should take a look to my question http://stackoverflow.com/questions/9637818/handle-this-object-datasource-on-reporting-services — Jorge, Mar 14 '12 at 14:11

score 0 · Answer 1 · answered Jul 16 '12 at 15:40

Try the following

public static List<BillsDataSet> BillsPorFecha(DateTime dtFechaInicial, DateTime dtFechaFinal)
{
    Context db = new Context();

    List<BillsDataSet> BillsDataSet = (from p in db.Bill
                                           select new BillsDataSet()
                                           {
                                               IDGestion = p.IDBill,
                                               Comentario = p.Historial.FirstOrDefault().Comentario,
                                               Products = (from b in db.BillProduct where b.product_id == p.IDBill select new BillProduct()).ToList() as ICollection<BillProduct>,
                                               Monto = p.Total,
                                               Personal = p.Historial.FirstOrDefault().CodigoEmpleado
                                           }).ToList();
    return BillsDataSet;

}

Reports VS 2010, drill down ICollection

1 Answers1