MIS reports

Anjana

I am implementing a solution in Navision 3.70. There are many complicated MIS reports which are to be generated through the system.
At present these are maintained in Excel with many worksheets , interdependent on each other.
There are concepts of Transfer Pricing betwen GL accounts and different dimensions, Financial Budgets, Quantitative Budgets, Apportioned expenses/revenues across dimensions and different companies.

Does any one have an idea, how to develop such kind of reports?
Is OCX,ODBC with Olap technology a better idea than to customize these reports in Navision Report objects?
Has anyone used Jet Reports?

Any suggestion will be helpful.

Thanks.

hansfousert

Hi Anjana,

Reading your posting I would definitely go for Jet Reports if I were you:
- very easy to use functions, 1 specifically for Financial reports
- multi-company in 1 single report
- rows, columns, sheets, matrix-reports
- dimensions are integrated as fields: no need to know the separate Navision dimension tables
- AutoPilot that creates reports at any moment

And there are a lot more interesting features.

Please contact me directly so that I can reply to your additional questions. Or maybe you've got some real examples that you would like to show, so that I can tell you how they can be created with Jet Reports.

Anjana

Many thanks for the reply.

I have not used Jet Reports, but saw a demo on the net itself. By the face of it, looks like that it can provide them with the solution they are looking for. Are these Jet Reports exclusively for Navision?

What technology are they using?

Any idea, how much will it cost for the customer if he agrees to buy it?

Thanks and Regards,

Anjana

hansfousert

Although Jet Reports was originally developed for Navision, it is now compatible with all open databases, e.g. SQL, Oracle etc. So you can build any report you want.

For information about pricing, distribution etc. I would like to recommend you to get in touch with Jet Reports itself. Their contact information is on their website: http://www.jetreports.com/contact.html. The person you are looking for is Paul Hollcraft.

Shenpen

I would do what I suggested in the "Demistfying Business Intelligence" topic.