i have been using navision’s report for quite a while now, and i realised that it has a lot of limitations. e.g. it needs a keys in a navision table to sort. should i look into crystal reports? as far as i know, all you have to do is to construct a sql statementq query that could get all the data you want, and you have your report.
All I can say is for design and presentation Crystal Report = WOW Navision Report = Oh well And for speed Navision Reports = whoosh Crystal Reports = oh dah hum, hum dad um, dum da hum, da lets have a coffee du dum Paul Baxter
I’m developing an interface between crystal nad navision using a vb dll - what the other guy said is right - crystal can be slow if you allow it to do the database query for you - but if you assoicate a result set with the report at runtime it is as fast as anything I ever seen. See crystal website ‘active data’ reports for more info.
quote:
Originally posted by jordi79
i have been using navision’s report for quite a while now, and i realised that it has a lot of limitations. e.g. it needs a keys in a navision table to sort. should i look into crystal reports? as far as i know, all you have to do is to construct a sql statementq query that could get all the data you want, and you have your report.
the crystal report is slow even for both navision native db and MS SQL db?
how about trying Brio?
And if You’re interested in dynamic analysis instead of reports and static dimensions; Try QlikView. http://www.qliktech.com //Lars
Hi, I would also like to know how the speed is when using MS SQL with a SQL ODBC link in stead of the C/ODBC link. Thanks Anret
The advantage to a SQL link would be the ability to utilize stored procedures on SQL itself, which could greatly speed up processing if designed right, and if needed. Yes, Crystal is easier to use, has a much greater support infrastructure behind it (at least in sheer numbers of users and books available), is of course the world-wide standard, and will give you a lot of different options that would take a lot of work to accomplish in the Navision report writer. Having said that, Crystal can be slow, it is difficult (but not impossible) to use flow fields, and being a seperate application instead of integrated is also a big minus. Being able to integrate C/SIDE code is also another plus of the Navision report writer. I have to say, that as a person that had been writing reports in both Crystal and Visual FoxPro before I came over to the Navision camp, it was very difficult to get the hang of it. The most annoying thing about the Navision report writer is not being able to select multiple objects and change them all at once (for example, to make them bold).
What about using ODBC with Excel and VB?? Or the product Jet Reports??? Does any one have experiences they would like to share??? Robert