Problem with RTC calling report which makes a file

Kisu

I came up with odd problem.

We've made a customisation for one of our customers which basically calls report which lines up some data and exports it to a ascii file.

Problem is that it works on the classic side of Navision but not in RTC.
If its called in RTC client, it starts making the file but says its already open and finishes the file 0KB (0 kilo bytes).

As I noted this works in classic version user has roles for creating,editing and viewing the object and all objects that is included on for the report and also the file path should have all rights for creating the file.

Also both clients and the servers are on same computer.

Is there something that I should add when calling report with action so it wont hold up the file and end it as 0KB?

Kisu

I tried to call it around codeunit and as process and report straight report, it somehow keeps hold the filename and wont let use the file.

matttrax

Are you explicitly closing the file? As in using File.CLOSE at the end of the routine.

Kisu

Yes close function for the file variable is used after all writes in the report. And it works on classic client

mohana_cse06

Is your environment on single machine or client-server?

If client server, your file will be created in Service server.

You have to close the file first and download to client machine,..

Kisu

mohana_cse06 wrote:

Is your environment on single machine or client-server?

If client server, your file will be created in Service server.

You have to close the file first and download to client machine,..

As I said on first post client and servers are on same place. The client connects to the server with rdp connection.

Kisu

So nobody else had problems like this before?

when I call create file should I close it before opening and writing on it?

now the function process is like this:

CREATE the file
OPEN the file
WRITE loops
CLOSE

and this way it works on the classic client. Both clients and SQL and Navision server are on same computer.

Kisu

I started to think, does RTC client use onTriggers differently that in classic client?

Both of the file exporting reports should be just process only on this.

mihail_kolev

In RTC, when you call CREATE, the file is already open, so you need to skip the OPEN part

Kisu

mihail_kolev wrote:

In RTC, when you call CREATE, the file is already open, so you need to skip the OPEN part

mm thanks for the tip, I'm gonna test that right away

Kisu

So far so good, yet still the second report -export does some counting wrongly but I think this problem is quite solved now.

\:D/

Kisu

Okay I got both report file exports working.

First one the problem was that I had OPEN after CREATE with the file function.

Second one the problem was with CREATETOTALS, this did now work with RTC client.

Both works fine now \:D/