Skip to main content

Posts

Showing posts from July, 2011

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-