Skip to main content

RDLC Report - The tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members.

Hi Readers,

In This article we will discuss how to resolve an Issue that we face During Creation of a RDLC Report.

Applies To - NAV 2009 and Later (RDLC Reports)

Scenario -

You are creating Say a Document Report. There are multiple tables in Body. For Linking these tables you put all these tables inside a List.

When You want to save the Report, You get an Error Message -
Error while validating RDL content:
The tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members.




How To Resolve Error?

Select the List and From Row Group Select Group Properties.


Select Add in General Tab and Add the Group Fields for the List.



Save the Report.

You Need to Add the Fields based on Which you want to repeat all the tables inside List.

For Example If Its a Sales Order Report Then You want to Group on -
Document Type
Document No.

Hope it make sense and will help you if you face the Above issue.

Regards,
Saurav Dhyani

Comments

Post a Comment

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Microsoft Dynamics NAV 2016 - How to Configure Phone Client.

Hi All, In this article we will discuss how we can connect Microsoft Dynamics NAV 2016 with New Client Launched i.e. Phone Client. This Article Contain Steps for a Android Phone as I have Only Android Phone. I am doing it having all tiers on my windows 8 machine, steps remain same for multiple servers but issues might be different. What we Need (Other what we discuss in this article) -  The Service Tier should be on Public IP . Some of the Data-card does not Provide you Public IP. check it for sure.

Download Microsoft Dynamics Business Central on Premises 2020 Wave 2 Release.

 Hi Readers, As Expected Microsoft have released #msdyn365bc 2020 wave 2 is available.  This article provides details of the new release. The 2020 release wave 2 for Business Central delivers a wealth of new features. Read What's new in 2020 Release Wave 2 here .  Dynamics NAV Customers upgrading to Business Central on Prem will be able to run business central on premises, move to cloud or choose a hybrid approach.