In Microsoft Dynamics NAV, there are two different layouts for reports:
-
Classic report layouts
-
Client report definition (RDLC) report layouts
To view the Classic report layout of a report from the RoleTailored client, you must ensure that the RDLC layout does not exist. If the RDLC layout does not exist and if you run a report from the RoleTailored client, then the Classic report layout is shown.
Before you begin this procedure, confirm the following:
-
The report for which you are deleting the RDLC layout does not have any global variables or global functions. If a report has global variables or global functions and you delete the transformation layout, you will get the following error when you run the report from the RoleTailored client:
Report state information cannot be transferred to Classic client report from the RoleTailored client. One or more of the public functions on report <report number> has been called prior to running the report.
You must either redesign the report so that it does not use global variables or global functions, or create an RDLC report layout for the report so that you can view the RoleTailored report from the RoleTailored client.
-
You have installed the Classic client, so that you can view the Classic report layout. You must have the same version of the Classic client and the RoleTailored client installed.
-
TCP/IP is enabled on your SQL Server. To enable TCP/IP, do the following:
-
Click the Start button, point to All Programs, point to Microsoft SQL Server 2005 or Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
-
In SQL Server Configuration Manager, expand SQL Server Network Configuration, click Protocols for MSSQLSERVER, right click TCP/IP, and then click Enable.
-
-
You are aware of the differences in supported report functions and properties for RDLC and Classic report layouts. For more information, see Supported Data Types, Functions, Properties, and Triggers in the Classic Client and RoleTailored Client.
To view a Classic report layout from the RoleTailored client
-
In the Classic client, on the Tools menu, click Object Designer.
-
In Object Designer, click Report, select a report for which you want to delete the RDLC layout, and then click Design.
-
On the Tools menu, click Delete Layout. In the dialog box, click Yes to confirm that you want to delete the layout.
-
Close Report Designer.
-
In the RoleTailored client, run the report. For more information about running a report from a command prompt, see How to: Use a Shortcut to Run a Report.