I have also used NH with Crystal passing an IEnumerable to the crystal
report. if the list is empty though Crystal freaks out. Not liking
DataTables all that much I created an simple extension method to
convert an IEnumerabl<> to a datatable. This way I only work with the
datatable when passing it to the report.
public static DataTable ConvertToTable(this IEnumerable<T> items)
{
var table = new DataTable();
var type = typeof(T);
var properties = type.GetProperties();
foreach(var property in properties)
{
table.Columns.Add(property.Name, property.Type)
}
foreach(var item in items)
{
var row = properties
.Select(p=>p.GetValue(item, null))
.ToArray();
table.Rows.Add(row);
}
return table;
}
when I need to generate a report I can query via NH. map the entities
to a report specific view and convert the data to table.
var data = session
.CreateCriteria<X>()
.Future<X>()
.Select(x => mapper.Map<X, Y>(x)
.ConvertToTable();
using(var report = new MyReport())
{
report.SetDataSource(data);
report.Export(...);
}
On Jan 28, 1:15 am, wanyaland <[email protected]> wrote:
> Thanx Paulo. What I did was to pass my objects to a datatable and bind
> the table to the report.Its working at least considering crystal
> reports work with datasets/datatables
>
> On Jan 11, 10:23 pm, Paulo Quicoli <[email protected]> wrote:
>
> > Hi,
>
> > here we pass list of object to a crystal reports report...
>
> > 2010/1/11 Harold Wanyama <[email protected]>:
>
> > > ---------- Forwarded message ----------
> > > From: Harold Wanyama <[email protected]>
> > > Date: Mon, Jan 11, 2010 at 5:15 PM
> > > Subject: Report generation with Nhibernate
> > > To: [email protected]
>
> > > Hi all, Iam a newbie in Nhibernate and so far so good as I work grasp the
> > > nhibernate ideas and workarounds on it. Iam working on a project and am at
> > > the stage of creating reports. How can I do this? Any simple example will
> > > do. I am able to fetch data from the db and am using Hql for that.
> > > Harold
>
> > > --
> > > You received this message because you are subscribed to the Google Groups
> > > "nhusers" group.
> > > To post to this group, send email to [email protected].
> > > To unsubscribe from this group, send email to
> > > [email protected].
> > > For more options, visit this group at
> > >http://groups.google.com/group/nhusers?hl=en.
>
> > --
> > Paulo R. Quicoli
>
> > Editor Técnico - ClubeDelphi Magazine - DevMedia
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
