"Show Results" in window & edit HTML report

14 views
Skip to first unread message

Carolyn C.

unread,
Jul 22, 2014, 12:20:00 PM7/22/14
to sofasta...@googlegroups.com
Hi all,

I have one troubleshooting tip for any new users who are, like me, having problems with the Show Results in-window feature in SOFA 1.4.3 using Windows OS (7 in my case but the problem might replicate on 8 / 8.1).

If you are unable to view tables, charts, or statistics test results in the window of SOFA, but instead have to open the HTML report to view, you might need to update Internet Explorer to the latest version. I never use IE, and apparently I still had version 9 on my desktop. I couldn't view any tables, charts, or statistics test results in-window until I updated to IE 11, and that cleared the problem right up.

I also have one troubleshooting question for Grant and/or other users: what's the easiest way to edit HTML reports? Relatively frequently I'll pull a bunch of tables and charts for my boss, and then realize that they'll need to be in a different order for clarity's sake, or that one or two are redundant and should be deleted. To me the obvious solution would be to dump the HTML report into MS Word to edit, but not all of the charts are preserved in Word (I believe that's a known bug, yes?). I'm not particularly good with HTML, so I really need a way to make point-and-click changes. Any ideas?

Let me know if you need any more information, etc.

Thanks!
Carolyn C.

Grant Paton-Simpson

unread,
Jul 22, 2014, 3:24:15 PM7/22/14
to sofasta...@googlegroups.com
Hi Carolyn,

Thanks for the tip re: upgrading IE on Windows 7. I'll add a note to the relevant places.

Re: editing HTML reports, you need to open the html file in a text editor. Each item of output is separated from the others by lots of empty lines to make it (relatively) easy to select and delete, relocate etc, items. Not exactly user-friendly but not hard either. Save a copy first in case you muck something up.

SOFA html reports have the following bits (fingers crossed this displays OK in the forum):

1) Top of file

2) Heaps of styling stuff you can ignore - may even be most of the report if a short report

e.g.

    .dj_ie .tundra .dijitTooltipBelow-paleorange .dijitTooltipConnector {
	
	    background-image: url("sofastats_report_extras/tooltipConnectorUp-paleorange.gif") !important;
    }
    .tundra .dijitTooltipAbove-paleorange .dijitTooltipConnector {
	
	    bottom: 0px;
	    left: 3px;
	    background:url("sofastats_report_extras/tooltipConnectorDown-paleorange.png") no-repeat top left !important;
	    width:16px;
	    height:14px;
    }

ends with this line:

<body class="tundra">

3) Then the items, separated by lots of spaces

E.g.

<br><br>
<hr style="clear: both; ">

<p>From sofa_db.demo_tbl on 23/07/2014 at 07:14 AM</p>
<p>All data in table included - no filtering</p>
<!-- _VISUAL_DIVIDER_BEFORE_THIS -->
<table cellspacing='0'><thead><tr><th class='tblcelltitle0'>
<span class='tbltitle0'>
<!-- _TBL_TITLE_START -->
The first report
<!-- _TBL_TITLE_END -->
</span>
<span class='tblsubtitle0'>
<!-- _TBL_SUBTITLE_START -->
<!-- _TBL_SUBTITLE_END -->
</span>
</th></tr></thead></table>
<!-- _REPORT_TABLE_START --><table cellspacing='0'>


<thead>
<tr></tr>
<tr><th class='spaceholder0' rowspan='1' colspan='2'>&nbsp;&nbsp;</th><th class='measure0'  >Freq</th></tr>
</thead>


<tbody>
<tr><td class='firstrowvar0'  rowspan='2'  >Gender</td><td class='rowval0'  >Male</td><td class='firstdatacell0'>769</td></tr>
<tr><td class='rowval0'  >Female</td><td class='firstdatacell0'>731</td></tr>
</tbody>

</table>
<!--_REPORT_TABLE_END -->
<!-- _ITEM_TITLE_START --><!--Frequencies_The first report--><!-- _SOFASTATS_ITEM_DIVIDER -->








<br><br>
<hr style="clear: both;  page-break-before: always ">

<p>From sofa_db.demo_tbl on 23/07/2014 at 07:14 AM</p>
<p>All data in table included - no filtering</p>
<!-- _VISUAL_DIVIDER_BEFORE_THIS -->
<table cellspacing='0'><thead><tr><th class='tblcelltitle1'>
<span class='tbltitle1'>
<!-- _TBL_TITLE_START -->
The first report
<!-- _TBL_TITLE_END -->
</span>
<span class='tblsubtitle1'>
<!-- _TBL_SUBTITLE_START -->
<!-- _TBL_SUBTITLE_END -->
</span>
</th></tr></thead></table>
<!-- _REPORT_TABLE_START --><table cellspacing='0'>


<thead>
<tr></tr>
<tr><th class='spaceholder1' rowspan='3' colspan='2'>&nbsp;&nbsp;</th><th class='firstcolvar1'   colspan='5' >Web Browser</th></tr>
<tr><th class='colval1'  >Google Chrome</th><th class='colval1'  >Firefox</th><th class='colval1'  >Internet Explorer</th><th class='colval1'  >Opera</th><th class='colval1'  >Safari</th></tr>
<tr><th class='measure1'  >Freq</th><th class='measure1'  >Freq</th><th class='measure1'  >Freq</th><th class='measure1'  >Freq</th>&
lt;th class='measure1'  >Freq</th></tr>
</thead>


<tbody>
<tr><td class='firstrowvar1'  rowspan='2'  >Gender</td><td class='rowval1'  >Male</td><td class='firstdatacell1'>193</td><td class='datacell1'>262</td><td class='datacell1'>165</td><td class='datacell1'>70</td><td class='datacell1'>79</td></tr>
<tr><td class='rowval1'  >Female</td><td class='firstdatacell1'>139</td><td class='datacell1'>260</td><td class='datacell1'>156</td>&
lt;td class='datacell1'>86</td><td class='datacell1'>90</td></tr>
</tbody>

</table>
<!--_REPORT_TABLE_END -->
<!-- _ITEM_TITLE_START --><!--Crosstabs_The first report--><!-- _SOFASTATS_ITEM_DIVIDER -->



Does that work for you?

All the best,
Grant
--

---
You received this message because you are subscribed to the Google Groups "sofastatistics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sofastatistic...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages