Tuesday, July 26, 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
http://saurav-nav.blogspot.com/

Thursday, July 7, 2011

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.

Monday, July 4, 2011

Friday, July 1, 2011

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-running transaction.

For more information click here.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/