Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How to remove underscores on the excel layout report in Business Central
BC_First
Member Posts: 1
Hi,
Am new in business central and I want to create the excel report layout.
This is what I did,
1. I selected my filters on the report request page
2. Click on Send to
3. Select the Send to Excel (Data only)
4. Then run the report.
5. It download the excel report.
Issue:
The report headings comes with underscores (e.g Posting_Date) and I want to display Posting Date without underscores.
I have attempted to change the report column but I cannot as it requires me to have an underscore or make it one word (PostingDate).
Column(Posting_Date,"Posting Date"){}
When I change the report heading from Posting_Date to Posting Date, the system does not allow me to use that excel as a custom layout when I select it from the "Report Selection" then I get this error below error message
"The layout file couldn't be imported.
In the Excel workbook, the table named 'Data' on the 'Data' sheet has the following columns that aren't in report's dataset definition:Posting Date
This problem can occur, for example, if new columns were added to the table directly in Excel. You'll also see this message if you've mistakenly imported the layout on the wrong report."
May you please help me with a way to make this excel layout work without underscores
Thanks, much appreciated your time.
Regards
Am new in business central and I want to create the excel report layout.
This is what I did,
1. I selected my filters on the report request page
2. Click on Send to
3. Select the Send to Excel (Data only)
4. Then run the report.
5. It download the excel report.
Issue:
The report headings comes with underscores (e.g Posting_Date) and I want to display Posting Date without underscores.
I have attempted to change the report column but I cannot as it requires me to have an underscore or make it one word (PostingDate).
Column(Posting_Date,"Posting Date"){}
When I change the report heading from Posting_Date to Posting Date, the system does not allow me to use that excel as a custom layout when I select it from the "Report Selection" then I get this error below error message
"The layout file couldn't be imported.
In the Excel workbook, the table named 'Data' on the 'Data' sheet has the following columns that aren't in report's dataset definition:Posting Date
This problem can occur, for example, if new columns were added to the table directly in Excel. You'll also see this message if you've mistakenly imported the layout on the wrong report."
May you please help me with a way to make this excel layout work without underscores
Thanks, much appreciated your time.
Regards
0