Help! I can't open a Classic Form in the RTC

Mr_NavMr_Nav Member Posts: 13
edited 2009-06-10 in NAV Three Tier
1.) I have create a Report.
2.) In the Report i have input FORM.RUNMODAL(52115); in the OnInitReport() -Trigger
3.)
a) I would run the Report (with Property ProccesingOnly) in the RTC but i become an error "the page does not exist"
b) I would run the Report (with Property ProccesingOnly=false) in the RTC but i become an error "database server unknown"

Please Help Me. What do I simply wrong?

PS: Sorry for my bad English :oops:

Comments

  • AlishaAlisha Member Posts: 217
    Not sure what you are trying to do.. you cannot open classic forms on RTC, forms are pages, and you cannot open them from reports, so your report does not make any sense on RTC...
  • kinekine Member Posts: 12,562
    You cannot use this way to open forms. The form is closed right after the OnOpen trigger is finished and the form goes into the wait loop (waiting for some trigger).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Mr_NavMr_Nav Member Posts: 13
    I would open the ClassicForm as described under http://dynamicsuser.net/blogs/mark_brum ... -2009.aspx


    This works but for my Form not!
  • kinekine Member Posts: 12,562
    You must be sure that there is no Layout created in the report you want to run, because the report must be run in the classic mode. If there is Layout created, the RTC will run the report in RTC mode...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Mr_NavMr_Nav Member Posts: 13
    Attached my Report!

    Wat is wrong???

    EDIT: In ClassicClient(CC) I can run the Form over the Report (see the Picture)
  • kinekine Member Posts: 12,562
    Open the report in designer, click Tools-Delete Layout, save object, close, try again in RTC...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Mr_NavMr_Nav Member Posts: 13
    Delete-Layout not possible

    after save object in the RTC following Error
  • kinekine Member Posts: 12,562
    Check that you have selected the "File-Database-Alter-Options-Enable for Microsoft Dynamics NAV Server" option.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Mr_NavMr_Nav Member Posts: 13
    Is selected!
  • kinekine Member Posts: 12,562
    Than check the ProcessingOnly property - it must be no to be able to remove the layout. I do not know history of your report, may be it was not ProcessingOnly before, someone created the layout, and the layout was not deleted when you set ProcessingOnly to true. And I assume that the report to work correctly, must be ProcessingOnly=No (else it is started in RTC mode each time).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Mr_NavMr_Nav Member Posts: 13
    OK. Without ProccesingOnly I can delete the Layout, but
    when I run the Report (with Property ProccesingOnly=false) in the RTC but i become an error "server unknown"??
  • kinekine Member Posts: 12,562
    Check that the Classic Client of NAV 2009 is installed. For me it seems like some other version is installed instead (or was installed after the 2009 version)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Mr_NavMr_Nav Member Posts: 13
    The CC ist installed and I can open the Form (see atached).

    I work on a Virtual PC. It's only Nav 2009 (RTC+CC) installed.

    EDIT: Is that right (PIC ServErr) that i can't the server select??
    I have the connection setup in the CustomSettings.xml!?
    <?xml version="1.0" encoding="UTF-8"?>
    <appSettings>
    	<!-- 
        The network protocol used to access the database.
        Valid options: Default, NamedPipes, Sockets
      -->
    	<add key="NetType" value="Default"></add>
    	<!-- 
        Name of the database server to connect to.
      -->
    	<add key="DatabaseServer" value="TESTPC\SQLEXPRESS"></add>
    	<!--
        Name of the database to connect to.
      -->
    	<add key="DatabaseName" value="Nav2009_PPS_DEMO"></add>
    	<!--
        Name of the Microsoft Dynamics NAV Server instance to connect
        to (for client) or listen on (for server).
      -->
    	<add key="ServerInstance" value="DynamicsNAV"></add>
    	<!-- 
        The listening TCP port for the Microsoft Dynamics NAV Server.
        This is part of the server's URL.
        Valid range: 1-65535
      -->
    	<add key="ServerPort" value="7046"></add>
    	<!-- 
        The listening HTTP port for the Microsoft Dynamics NAV 
        Business Web Services.
        This is part of the web service's URL.
        Valid range: 1-65535
      -->
    	<add key="WebServicePort" value="7047"></add>
    	<!--
        Turns on or off the https for Web Services
      -->
    	<add key="WebServiceSSLEnabled" value="false"></add>
    	<!--
        Maximum permitted size of a Web Services request, in kilobytes
      -->
    	<add key="WebServicesMaxMsgSize" value="512"></add>
    	<!--
        Maximum time in seconds a call from the client to the server
        may take to return.
        Time span format: [dd.]hh:mm:ss[.ff]
            dd: days
            hh: hours
            mm: minutes
            ss: seconds
            ff: fractions of a second
        Or "MaxValue" to indicate there is no timeout.
      -->
    	<add key="OperationTimeout" value="MaxValue"></add>
    	<!--
        The security services used to protect the client/server data stream.
        Valid options: EncryptAndSign, Sign, None
      -->
    	<add key="ProtectionLevel" value="EncryptAndSign"></add>
    	<!--
        Maximum number of concurrent client calls that can be active on the 
        Microsoft Dynamics NAV Server. To disable this setting set the value
        to "MaxValue".
      -->
    	<add key="MaxConcurrentCalls" value="40"></add>
    	<!--
        Sets the grace period within which the client can reconnect to a
        running session.
        Time span format: [dd.]hh:mm:ss[.ff]
            dd: days
            hh: hours
            mm: minutes
            ss: seconds
            ff: fractions of a second
        Or "MaxValue" to indicate there is no timeout.
      -->
    	<add key="ClientReconnectPeriod" value="00:10:00"></add>
    	<!--
          Threshold for when to start compressing data sets to avoid that they 
          consume prohibitive amounts of memory.
      -->
    	<add key="CompressionThreshold" value="64"></add>
    	<!--
          Sets the Metadata Provider cache size (in number in objects cached). 
          Set to 0 to disable cache.
      -->
    	<add key="MetadataProviderCacheSize" value="150"></add>
    	<!--
          Limits the size of files that can be uploaded in order to avoid out of memory errors. This value is in megabytes.
      -->
    	<add key="MaxUploadSize" value="5"></add>
    	<!--
          With the EnableDebugging flag set to true the Microsoft Dynamics NAV Server
           will start with debugging mode enabled.  This mode has three main functions:
          1)	Upon first connection by a RoleTailored Client all C# for that application
              will be generated.  
          2)	C# files will be persisted between server restarts.
          3)  Application Objects will be compiled with debug information.
      -->
    	<add key="EnableDebugging" value="false"></add>
    </appSettings>
    
  • kinekine Member Posts: 12,562
    1) Please, when creating the screenshots, switch the client into english...
    2) Where the SQL server is running? It seems that the client is trying to connect to it but cannot...
    3) Are you running the CC when developing the form/report in the VPC too ro you run it from outside?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • azwierzchowskiazwierzchowski Member Posts: 15
    Are you using default or named sql server instance? You can not run classic reports in RTC if you are using named instance. I think that it shows "database server unknown" in this case.
  • Mr_NavMr_Nav Member Posts: 13
    @azwierzchowski
    I'm using the default sql server instance. But its exist an another Instance from an old SQL Server!?!

    My Configuration:
    ServerName = TESTPC\SQLEXPRESS
    Database = Nav2009_PPS_Demo
    An in the Config from Nav (CustomSettings):
    <add key="DatabaseServer" value="[color=#FF0000]TESTPC\SQLEXPRESS[/color]"></add>
       <!--
        Name of the database to connect to.
      -->
       <add key="DatabaseName" value="[color=#FF0000]Nav2009_PPS_DEMO[/color]"></add>
       <!--
        Name of the Microsoft Dynamics NAV Server instance to connect
        to (for client) or listen on (for server).
      -->
       <add key="ServerInstance" value="DynamicsNAV"></add>
       <!--
        The listening TCP port for the Microsoft Dynamics NAV Server.
        This is part of the server's URL.
        Valid range: 1-65535
      -->#
    

    @kine
    2) Where the SQL server is running? It seems that the client is trying to connect to it but cannot...
    SQL-Server is running (on Virtual PC)
    3) Are you running the CC when developing the form/report in the VPC too ro you run it from outside?
    Yes the CC is running when i developing the form/report, but i can close the CC & RTC and restart and the problem is not solved
  • kinekine Member Posts: 12,562
    TESTPC\SQLEXPRESS means that you are using named instance, and this is the problem which azwierzchowski described... ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Mr_NavMr_Nav Member Posts: 13
    Realy :?: :?:

    How can i easy change the named instance to a default insatnce?
  • mihail_kolevmihail_kolev Member Posts: 379
    Umm, I don't get it. You can't run form in RTC, have you made the page equivalent for that form??
    -Mihail- [MCTS]
  • Mr_NavMr_Nav Member Posts: 13
    Umm, I don't get it. You can't run form in RTC, have you made the page equivalent for that form??

    I can't create equivalent Page .. that form is a matrix form
  • mihail_kolevmihail_kolev Member Posts: 379
    well, try this one

    In the OnInitReport trigger write:
    FORM.RUNMODAL(0, yourRecord);

    your form should open this record by default i think... i mean
    FORM.RUNMODAL(0, recCust); opens the customer list

    source:Mark Brummel's blog
    -Mihail- [MCTS]
  • Mr_NavMr_Nav Member Posts: 13
    well, try this one

    In the OnInitReport trigger write:
    FORM.RUNMODAL(0, yourRecord);

    your form should open this record by default i think... i mean
    FORM.RUNMODAL(0, recCust); opens the customer list

    source:Mark Brummel's blog

    Yes, but i become the Error "Server unknown" bei run the report in the rtc = that's my problem
  • Mr_NavMr_Nav Member Posts: 13
    kine wrote:
    TESTPC\SQLEXPRESS means that you are using named instance, and this is the problem which azwierzchowski described... ;-)

    But, WHY I can run other classic reports??
    Is the default instance only for the CC-Forms in RTC essential???
  • mihail_kolevmihail_kolev Member Posts: 379
    Hmm... it's realy strange. Is same thing happen if you try to open the customer list the same way?
    Also make sure that the RTC and classic client are same version.
    When i try this, the customer list is open.
    -Mihail- [MCTS]
Sign In or Register to comment.