Custom Product Reports
Posted: Fri Feb 27, 2009 1:21 pm
I have been trying to work with the Able reporting code to make some custom reports, but i'm not entirely sure how to do this.
It looks like the Inventory Ex report that we have uses CustomReportDataSource.cs, which seems to rely heavily on the manufacturerID for data to come out.
The LowInventory report, on the other hand, uses CommerceBuilder.Reporting.ProductInventoryDataSource, and I dont know how that works at all.
Currently, we need a report which will pull up items which are out of stock, and next to each item, show the list of emails for people who want to be notified when its back in stock. (no manufacturer ID is relevant)
This report, and others like it would be much easier to create if there were some solid example code of the proper way to directly access the Able database, independent of a particular field, or something I cant inspect myself.
Is anyone at Able willing to write something to ease the creation of new reports? Possibly a simple framework that contains methods to retrieve a particular column of data from any table in the database. This would definitely be a valuable addition to the software, and I would love to have something that offers total access and sortability to all of our data.
It looks like the Inventory Ex report that we have uses CustomReportDataSource.cs, which seems to rely heavily on the manufacturerID for data to come out.
The LowInventory report, on the other hand, uses CommerceBuilder.Reporting.ProductInventoryDataSource, and I dont know how that works at all.
Currently, we need a report which will pull up items which are out of stock, and next to each item, show the list of emails for people who want to be notified when its back in stock. (no manufacturer ID is relevant)
This report, and others like it would be much easier to create if there were some solid example code of the proper way to directly access the Able database, independent of a particular field, or something I cant inspect myself.
Is anyone at Able willing to write something to ease the creation of new reports? Possibly a simple framework that contains methods to retrieve a particular column of data from any table in the database. This would definitely be a valuable addition to the software, and I would love to have something that offers total access and sortability to all of our data.