News and Announcements icon

Dynamics 365 CommunityForums Finance forum Electronic Reporting: ...

Finance forum

Unanswered

Electronic Reporting: Delete excel row of field is disabled

(1) Share

Report

Report

Posted on by Adis

266

Dear all,

I would like to disable rows 23-25, if the values are null. I know that can be achieved by putting up this field with the according formula. For testing purpose I set it to FALSE.

However, I would like the whole row to be deleted, so that the rest of the content moves one line up.

F.e., if row 24 (Our Quotation) is not enabled, I would like "Project Supplementary Info" to move to line 24, as I dont want to have an empty row between "Order number" and ""Project Supplementary Info".

How do I achieve this?

Kind regards, Adis

Categories:

Development / Customization / SDK

Administration and Setup

BI and Analytics

All responses Img

All responses (1)

Answers Img

Answers (0)

Adis 266 on at

Like (0)

Report

Electronic Reporting: Delete excel row of field is disabled

With some help I figured it out:

If you want one or more rows to be deleted, the cells need to be part of a range. If the row is deleted, subsequent content will move up and you wont have empty rows in between, in case there is no data.

Then you use the "Enabled" field to control when the row(s) should be shown or not (deleted)

Kind regards, Adis

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 287,773 Super User

#2

Martin Dráb 225,513 Super User

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans