Browse by Tags

Tagged Content List
  • Blog Post: How can I export an Office Accounting report to Excel in code

    It has been a while since my last post and I have gotten a few questions. One question was related to exporting reports to Excel. This is actually pretty simple; you may have noticed the IReportExportToExcelV2 interface. This is the key to this task. Basically the system report e xecutor implements...
  • Blog Post: How do I use the ReportColumnType and ReportColumnPreferenceType values when I build custom Office Accounting reports?

    The question about the ReportColumnType came up in a comment for a prior post, and yeah I guess it’s fair that I tell you about it :o) First a brief description of the values, from the quick overview you can see that you really do not have that many ColumnTypes to choose from as many of the values...
  • Blog Post: Add custom filters to your custom Office Accounting reports

    What if I have created a INativeReport and I want to filter it, but the build in filters are not exactly what I need? Well you can create your own filters! It does require some coding though (but we like code, right?). As an example let’s add a “Region” filter to the “Customers Grouped by...
  • Blog Post: Sample IReportFilterGenericV2 implementation

    [ Serializable ] class RegionFilter : IReportFilterGenericV2 , ISerializable { private int censusRegion; private string state; private bool visible = true ; private string [] censusRegionNames = { "All" , "Northeast" , " New England " , " Middle Atlantic " , " Midwest...
  • Blog Post: How to create Office Accounting reports with totals?

    Ok - it’s been way too long since my last post, and I now feel forced to cover a topic that several people has asked me: “native reports are great and all, but can I add a total to my report”. The good news is the answer is yes, the bad news is it requires some work. Let’s assume I...
  • Blog Post: Creating reports that can access data in SQL

    I got a comment on one of the prior post asking if I would create a new post on how to query the data in the Office Accounting database directly, thank you for the question. I would like to encourage other readers to ask for other posts on other things that could help you. I won’t promise that I’ll get...
  • Blog Post: Adding reports 3 - native reports with a little more meat

    In my last post I showed that you can add a native report to Office Accounting. but really the report I created in my example was kind of bla – don’t you think? Let’s try to add a little meat to the report! Filtering To add filters to the report we have to do a couple of things. First...
Page 1 of 1 (7 items)