# Incorrect Reports - Columns shifted from headings

**URL:** <https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692>\
**Category:** Scoutbook & Scoutbook Plus Bugs\
**Created:** [July 6, 2019, 5:28pm UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692 "2019-07-06T17:28:50Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![ElisabethWoody](https://avatars.discourse-cdn.com/v4/letter/e/7c8e57/32.png) [@ElisabethWoody](https://discussions.scouting.org/u/ElisabethWoody)\
**Post date:** [July 6, 2019, 5:28pm UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/1 "2019-07-06T17:28:50Z")

</div>

I have set up a report to show the advancement status of a subset of my Scouts who are going to camp. The current ranks are showing correctly, but the detail below for rank requirements is incorrect - for example, Scout 4 has Tenderfoot rank, but her detail shows some Scout requirements not complete. These details match Scout 3’s records, and Scout 3 shows no rank, but all requirements are marked complete. Scouts 7 & 8, Second Class and Tenderfoot respectively, also show some Scout requirements not done in the report. It’s like the column detail is sorted in a different order from the headings. How do I troubleshoot this further? I can easily provide examples

---

<div class="post-metadata">

**Author:** ![Stephen\_Hornak](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/stephen_hornak/32/16282_2.png) [@Stephen\_Hornak](https://discussions.scouting.org/u/Stephen_Hornak)\
**Post date:** [July 6, 2019, 5:44pm UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/2 "2019-07-06T17:44:09Z")

</div>

@ElisabethWoody - you can post screen shots if that helps explain the issue.

---

<div class="post-metadata">

**Author:** ![CharleyHamilton](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/charleyhamilton/32/3113_2.png) [@CharleyHamilton](https://discussions.scouting.org/u/CharleyHamilton)\
**Post date:** [July 6, 2019, 7:06pm UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/3 "2019-07-06T19:06:44Z")

</div>

Hi, @ElisabethWoody,

This sounds similar to an issue I reported [here](https://discussions.scouting.org/t/many-existing-reports-are-not-working/122106/26). Are you seeing the mixed-up data in the graphical report, the CSV export, or both?

---

<div class="post-metadata">

**Author:** ![ElisabethWoody](https://avatars.discourse-cdn.com/v4/letter/e/7c8e57/32.png) [@ElisabethWoody](https://discussions.scouting.org/u/ElisabethWoody)\
**Post date:** [July 8, 2019, 2:23pm UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/4 "2019-07-08T14:23:54Z")

</div>

This issue appears to happen only when I sort by last name, the reports are correct when sorted by first name. Incorrect:

 ![11%20AM](https://global.discourse-cdn.com/scouting/original/2X/9/9c8085c5e35e21fbef21c8ae727a5ee5af674232.png)  
Correct: ![10%20AM](https://global.discourse-cdn.com/scouting/original/2X/8/8ccb3fdbf0a1c2a4817516fe63b496f17243c750.png)

---

<div class="post-metadata">

**Author:** ![DonovanMcNeil](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/donovanmcneil/32/24_2.png) [@DonovanMcNeil](https://discussions.scouting.org/u/DonovanMcNeil)\
**Post date:** [July 8, 2019, 2:27pm UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/5 "2019-07-08T14:27:06Z")

</div>

@ElisabethWoody please post the full url for these 2 reports noting which is correct and which is wrong

---

<div class="post-metadata">

**Author:** ![ElisabethWoody](https://avatars.discourse-cdn.com/v4/letter/e/7c8e57/32.png) [@ElisabethWoody](https://discussions.scouting.org/u/ElisabethWoody)\
**Post date:** [July 8, 2019, 2:29pm UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/6 "2019-07-08T14:29:59Z")

</div>

Correct: [https://reports.scoutbook.com/vim2/webscript/output/sbreports.aspx?Method=ExecuteScriptSet&ScriptSetCode=SBReportBuilderOutput&ScriptCode=GeneratePresentation&OutputType=HTML&ReportID=498823&vpWidth=1274&vpHeight=605&media=1](https://reports.scoutbook.com/vim2/webscript/output/sbreports.aspx?Method=ExecuteScriptSet&ScriptSetCode=SBReportBuilderOutput&ScriptCode=GeneratePresentation&OutputType=HTML&ReportID=498823&vpWidth=1274&vpHeight=605&media=1)  
Incorrect: [https://reports.scoutbook.com/vim2/webscript/output/sbreports.aspx?Method=ExecuteScriptSet&ScriptSetCode=SBReportBuilderOutput&ScriptCode=GeneratePresentation&OutputType=HTML&ReportID=498845&vpWidth=1274&vpHeight=605&media=1](https://reports.scoutbook.com/vim2/webscript/output/sbreports.aspx?Method=ExecuteScriptSet&ScriptSetCode=SBReportBuilderOutput&ScriptCode=GeneratePresentation&OutputType=HTML&ReportID=498845&vpWidth=1274&vpHeight=605&media=1)

---

<div class="post-metadata">

**Author:** ![ElisabethWoody](https://avatars.discourse-cdn.com/v4/letter/e/7c8e57/32.png) [@ElisabethWoody](https://discussions.scouting.org/u/ElisabethWoody)\
**Post date:** [July 11, 2019, 3:44am UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/7 "2019-07-11T03:44:05Z")

</div>

I posted the URLs as requested - is there more information needed?

---

<div class="post-metadata">

**Author:** ![edavignon](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/edavignon/32/16_2.png) [@edavignon](https://discussions.scouting.org/u/edavignon)\
**Post date:** [July 11, 2019, 3:45am UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/8 "2019-07-11T03:45:47Z")

</div>

Elizabeth,

The issue you discovered with data differences depending upon sort order was fixed on Tuesday, July 9. Can you check your reports again and still see if the issue persists?

---

<div class="post-metadata">

**Author:** ![ElisabethWoody](https://avatars.discourse-cdn.com/v4/letter/e/7c8e57/32.png) [@ElisabethWoody](https://discussions.scouting.org/u/ElisabethWoody)\
**Post date:** [July 11, 2019, 9:01pm UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/9 "2019-07-11T21:01:33Z")

</div>

Yes, the reports are now working as expected

---

<div class="post-metadata">

**Author:** ![edavignon](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/edavignon/32/16_2.png) [@edavignon](https://discussions.scouting.org/u/edavignon)\
**Post date:** [July 11, 2019, 9:18pm UTC](https://discussions.scouting.org/t/incorrect-reports-columns-shifted-from-headings/123692/10 "2019-07-11T21:18:37Z")

</div>

Closed on July 11, 2019, 9:18pm UTC


