Skip to main content

Posts

Show only Date not Date and Time in RTC Reports?

Hi all, Most of the time client requires only date to be printed in the report, say for the shipment date. But when we create the report in RTC and set the dataset field for the shipment date we get data and time. The date in RTC Report shows date and time and that is the standard format. If you want to show only date then we need to use the Format Property. Example Then in Page body click on the expression of the text box which says  “=SalesLine_ShipmentDate” and convert it to =FORMAT(SalesLine_ShipmentDate,"Short Date"). This will only show date. Regards, Saurav Dhyani www.sauravdhyani.com

How to Start Navision Application Server?

Hi all, We always face issues while using NAS. Lets discuss how we can install, configure and use Navision Application Server (NAS). Go to Server Folder in the installation disk of the Navison version for which you want to start the Navision Application server. Install the server on the disk. This will create a service, go to services.msc to change the startup parameter of the service and use an administrative account to start the service.

RTC Report Development 3.

Hi all, If you haven't read part1 and part2 then click here for Part1 and Part2. Now lets see what can be done to create Page Header without any issues. Lets check what Microsoft do to create Page Header for the same report. Here is what it see the Layout of standard Report.

ERROR The trasaction log for database is full.

Hi all, Sometime we face an error in SQL Server while performing transaction in Navision. ERROR - (Error 9002) The following SQL Server Error or errors occured when accessing the "Table Name" table: 9002,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] The trasaction log for  database 'Database name' is full. To find out why space in the log cannot be reused, see the log_reuse_Wait_desc column in sys.database. SQL: Update "database name"."dbo"."Table Name" with (RepeatTableRead) set something where  query. Reason For Error- The error is due to space avilability in the disk where Log file reside. Resoultion - There are multiple options for the resoultion of the same, choose one that best suite you- 1) Backing up the Log. 2) Freeing Disk Space. 3) Moving the Log File to a Different Disk 4) Increasing the size of a log file. 5) Adding a log file on a different disk. 6) Completing or killing a long-

RTC Report Development 2.

Hi all, If you haven't read the part first then read it  here. Now when you created the suggestion layout you can see the Red Dots in the Report body. For being specific in the table details of the first table in the Page Body. The most part of an RTC Report is the Page Header, we all face issues in this. Let's discuss what happens when we say suggest layout.

RTC Report Development 1.

Hi all, we all have some known and unknown issues while creating a Report For Role Tailored Client . we will try to create a standard report by deleting its Layout and creating a new RDLC Layout from Scratch. I have saved Standard Report 406 Purchase - Invoice as 5000 Purchase - Invoice 1. Then I deleted its existing layout by using Tools->Delete Layout. Now lets create the Layout from Scratch. Now lets see what Layout suggestion suggest for this report, by using Tools -> Create Layout Suggestion.

Microsoft Dynamics NAV Classic client was opened from an untrustworthy component. Contact your system administrator.

Hi all, A Comman error faced while trying to Run a Report From Role Tailored Client (a report with no layout defined), it try to start the Report Engine from classic Client. It can happen that after updating RTC, you end up with a version of RTC which is not compatible with the default classic client. In this case you will typically get this error message when trying to run the report. First of All you need to find the build of classic and Role tailored client. The Build for both should be same. Following screen shows how to check the build for both client. If the build is diffrent you need to udate the Build using this link (require Partner/Customer source login). If the build is same then we need to find out from where does RTC find the classic client for running classic reports? RTC finds the location of Finsql.exe in this place in registry: (can be opened by typing regedit in RUN) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\