First let me say - this is part of an R&D effort, not a production issue, so it may not be worth pursuing.
That said, I am researching how one would use a report viewer in a UC and use Umbraco content nodes as the data source. It would appear that no one has done this sort of thing before.
Most times, XSLT would be the way to go. But for complex reports, such as financial reports, I'd like to be able to encapsulate all the sorting, section subtotals, formatting, etc. in the report definition and deploy as needed. It would also be great to take advantage of the report viewer's capabilities for printing, pdf, zoom, export etc. also.
This may be more a matter of developing the report def and assigning a Node.ChildrenAsTable as the datasource.
If I get something working along these lines, I'll write it up.
It sounds like an interesting little project, I hope you manage to get this working and look forward to reading about it if you write a blog post when you've got it working.
Report User Control
Hello Umbraco Colleagues:
I'm trying to create a UC that contains a Report Viewer & Report for reporting Umbraco data... but not getting very far.
It was suggested to me that the ChildrenAsTable method of the NodeFactory might be the way to go. I'm having trouble taking it from there.
Any suggestions or sample code that would set me on the correct path would be greatly appreciated.
(Umbraco 4)
Thanks,
David Hill
Hi David,
What exactly are you trying to do?
At the moment I am wondering why you are not using XSLT?
Cheers,
Chris
That is definitely a valid question.
First let me say - this is part of an R&D effort, not a production issue, so it may not be worth pursuing.
That said, I am researching how one would use a report viewer in a UC and use Umbraco content nodes as the data source. It would appear that no one has done this sort of thing before.
Most times, XSLT would be the way to go. But for complex reports, such as financial reports, I'd like to be able to encapsulate all the sorting, section subtotals, formatting, etc. in the report definition and deploy as needed. It would also be great to take advantage of the report viewer's capabilities for printing, pdf, zoom, export etc. also.
This may be more a matter of developing the report def and assigning a Node.ChildrenAsTable as the datasource.
If I get something working along these lines, I'll write it up.
David
As noted by David, its matter of setting report datasource to something like Node.GetCurrent().ChildrenAsTable()
Hi David,
It sounds like an interesting little project, I hope you manage to get this working and look forward to reading about it if you write a blog post when you've got it working.
Cheers,
Chris
is working on a reply...