Hi All
Using report writer in MSGP 10 when I add an additional header for currencyID and run the report , it generated error "Bad break field in an additional Footer or Header. Recheck". I have already added CurrencyID in Sort fields. Can anyone suggest solution to the problem.
*This post is locked for comments
May I get some assistance on this issue?
A colleague modified the Trial Balance Detail report to add a Cost Center header and footer. Their break field definition is the same for both. It has been so long since I worked with these sections that I don't remember if this definition means both Account Number and Account Number:Account_Segment_Pool2 are break fields or since the latter is highlighted when I open the window that means only it is considered the break field.
They also created a Sort Definition that includes both these fields from the reports temp table.
The issue is that the report prints fine when selecting the Cost Center as the sort in the Sort By: Segment ID option on the Trail Balance Report Options window, but it gives the bad break field error if you select any other segment here.
UPDATE :
My current hypothesis is the problem cannot be resolved due to it being a fundamental conflict with the Break Fields in the Cost Center header and footer and the attempt to sort the report differently than the defined Sort Definition as these alternate sorts do not contain the Break field.
From Dexterity Help: Sorting criteria specified at runtime supersede the sorting criteria defined in the report definition.
A Sort Definition was created on the report of Account Number and Account Number:Account_Segment_Pool2. The Break field chosen for the new sections is Account Number:Account_Segment_Pool2. Now we come into the Trial Balance Report Options window which allows you to choose a segment to sort by and the code called from this window is this :
sort by
component 'Segment Sort By' of table GL_Options_TEMP of field 'Account Number' of table GL_Trial_Balance_TEMP,
'Account Number' of table GL_Trial_Balance_TEMP,
I think this works when the Segment chosen is the Cost Center segment because the line starting with "component" will be the same as Account Number:Account_Segment_Pool2, but it will fail when choosing a different option. Consider this line from Dexterity Help as well:
The fields available for additional headers and footers to break on in the Header/Footer Options window are drawn from the main table's key or the sorting method, if one exists. If you create a sorting method or change the key used by the report, you could inadvertently exclude an additional section. If you're using additional headers and footers on your report, we recommend that you use caution if you use a different key or create a sorting method.
Adding a manual sort will override the index for the report.
Break field work on the index (or sort) fields.
You will need to include the index fields in the manual sort, especially the ones used in additional headers and footers as break fields to fix the report.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
What report are you trying to print? There was a known issue around this in erlier versions. I don't believe the issue has been resolved yet.
Go into report writer and select each header and footer in turn in the Sections option. If you get an error message on any particular section, then this is the problem none, and delete it. There is most likely an invalid field selected in the header that is causing the bad break issue.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
