Browse by Tags

Tagged Content List
  • Blog Post: How can I create new Office Accounting reports that can be seen by low rights users?

    A few people have had this problem now: They create a report add-in for Office Accounting but when they deploy to the end users the reports does not show up in the menu. One of those ”but it works for me!!” problems… A typical reason can be that you forgot to set the AreaAccess property when you...
  • Blog Post: My Office Accounting report’s aging filters need to add new columns

    I just got this question: “The problem is that I am creating a new custom report using the INativeReportV2 interface. I am trying to apply Aging Options Filter to the report. The problem is, how I do capture those values in the CreateDesign method? The CreateDesign method only accepts the IReportDesign...
  • Blog Post: Accessing data in an Office Accounting report

    I was asked how you can access the data in an Office Accounting report in code. As the code shows below this is very simple – you just have to remember a few things: · There is no guarantee that the columns in the data view won’t change between versions · If you use the groups make sure to iterate...
  • 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: More than one report in one Office Accounting add-in

    I was asked If you need a new Report add-in for each report you want to add. I think it is a good question and one of the things you do not get for free in you generate your reports using the templates (there I had a chance to mention it again) The answer is no, you can do that if you want to be...
  • 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: Creating Reports in Visual Basic

    I have been asked how to do these things if you are a VB programmer. Well my very first comment you may have guessed already :o) Use the templates! – yes that’s right, some sweet soul has created templates for the VB side of things as well. Back to my little example of a native report implementation...
  • 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...
  • Blog Post: Adding reports 2 - simple native report

    Ok, I’m back from vacation so let’s take a look at the next thing you can do with the report SDK; adding native reports. A native report is a report that will run in the Office Accounting report engine and it will be shown in the native Office Accounting report UI. This basically means that you can create...
Page 1 of 1 (13 items)