Create a new Custom RDLC Report layout:

Many reports in Microsoft Dynamics NAV 2015 are based on RDLC. In previous versions of NAV users had not been able to customize RDLC based reports. In Microsoft Dynamics NAV 2015 the platform changes to support tenant-specific custom Word layouts. Reports in NAV 2015 can now be edited in Report Builder.

Create a new Custom RDLC Report layout

Select Sales Invoice Report 1306 from ‘Report Layout Selection’ page

Department/Administration/IT/Administration/Reports/Report Layout Selection

Find Report 1306: Sales – Invoice. The RDLC is currently the selected layout.

Select the Function ‘Custom Layouts’ in the Ribbon

image

Create new ‘Custom RDLC Report layout’ based on Sales Invoice Report 1306

Select New and then select ‘Insert RDLC Layout’

image

We can now give it a description

image

In the example below I have given it a description ‘My custom RDLC Report’

image

Edit the RDLC Report layout

We can now edit the RDLC Report layout. Select ‘Edit Layout’

image

The report builder open in Microsoft SQL Server Report Builder

image

Once the report opened we can edit the report. Cosmetic changes can be done and in my example below I have done the following changes:

· ‘Customer Address’ fields changed to Red and Bold

· ‘VAT Registration No.’ changed to Bold

· Remove the field ‘Company Giro No.’

· Moved the Company Bank Name one field lower

· Changed the background colour where the field is empty

· Changed the background colour for the columns to light blue

image

The report changes had been completed and we can now save the changes.

image

We can also select to save the report changes by selecting ‘Yes’ on the next warning message to import the changes into Microsoft Dynamics NAV 2015.

image

 

Test the new custom RDLC Report layout

The report can now be tested and made active. The changes can now be verified when selecting the function ‘Run Report’. Note that the report is still inactive and will not be available for the users.

clip_image002

Select Preview

clip_image004

I can now see all the changes that I have made to the report in the report builder BUT the changes is not yet visible on the actual documents.

image

Make the new Custom RDLC Report active

Once the report had been tested and all the changes are completed, the changes can be implemented. I am now back on my Report Layout Selection Page and I select Custom Layout in the field ‘Selected Layout’

clip_image008

The Custom Report Layouts Page opens and I can see my custom report layout. I select OKclip_image010

When the page close I can now see that my report layout is the selected layout.

clip_image012

When printing a Sales Invoice, the report changes will be effective in the live database.

clip_image014

Microsoft Dynamics NAV is a business management solution from Microsoft that is quick to deploy, easy to use, and has the power to support your business ambitions. Please do not hesitate to contact Technology Management for more information.

Leave a Reply