Problem with RTC calling report which makes a file

Kisu
Kisu Member Posts: 381
edited 2011-05-04 in NAV Three Tier
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?
K.S.

Answers

  • Kisu
    Kisu Member Posts: 381
    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.
    K.S.
  • matttrax
    matttrax Member Posts: 2,309
    Are you explicitly closing the file? As in using File.CLOSE at the end of the routine.
    Matt Traxinger - ArcherPoint
  • Kisu
    Kisu Member Posts: 381
    Yes close function for the file variable is used after all writes in the report. And it works on classic client :/
    K.S.
  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    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,..

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • Kisu
    Kisu Member Posts: 381
    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.
    K.S.
  • Kisu
    Kisu Member Posts: 381
    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.
    K.S.
  • Kisu
    Kisu Member Posts: 381
    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.
    K.S.
  • mihail_kolev
    mihail_kolev Member Posts: 379
    In RTC, when you call CREATE, the file is already open, so you need to skip the OPEN part :)
    -Mihail- [MCTS]
  • Kisu
    Kisu Member Posts: 381
    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 :o
    K.S.
  • Kisu
    Kisu Member Posts: 381
    So far so good, yet still the second report -export does some counting wrongly but I think this problem is quite solved now.

    \:D/
    K.S.
  • Kisu
    Kisu Member Posts: 381
    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/
    K.S.

Categories