Running Reports from OS command line

McLean

We are using Cognos Portfolio to group various reports (from PowerPlay, Excel, HTML etc) together and provide the users with a single point of entry to information. We can run Navision reports and save the output as HTML but it would be very useful if the users could run the report entering the filter data. My idea is to run (somehow) Navision from the command line, possibly I would need to write a C program for this.
Any suggestions?

mayer

...
i would use the timer function and a report which test´s every time a existing file and starts an other report if it is true.

R. Mayer

John_Tegelaar

There a (too many?) things you cannot do with commandline switches or options. You can specify a database to run, but you cannot select a company on forehand, to name a limitation.

My guess in this would be to create an external file and read this out using a codeunit in Navision. In the file you put the data required to select the report and feed this with the required data to have it run properly. Depending on which report(s) you are talking about, this might be quite complicated. Perhaps using an alternative reportgenerator, or ODBC connection (or SQL connections when NF 2.5 is used) is a more elegant way to go.

John

Jim_Hollcraft

John is right about command line limitations. Having more command line options is on my wish list. However, Navision will select the last company opened so in theory, you could "select" the company by choosing different zup files.

---

Jim Hollcraft
aka Skater
drilldot.com
Unauthorized Navision News