Sadly it doesn't look like that web page can be loaded with School as the default. I snooped in the page source and it has this in it:

<select name="ctl00$PageContent$ddlReport" onchange="javascript:setTimeout(&#39;
__doPostBack(\&#39;ctl00$PageContent$ddlReport\&#39;,\&#39;\&#39;)&#39;, 0)" id="PageContent_ddlReport">
<option selected="selected" value="0">District</option>
<option value="1">School</option>

 

So it seems like it only refreshes the report when the choice is changed.

Maybe someone out there knows a trick that could be used to put something on the URL to get it to load up with School instead of District as the default -- that is really the only way to get at it. I checked the source of the page when it first loads, before one changes that selection, and the schools aren't in there at that point.

 

---

Thank you Dale. I was hoping that I was just missing some parameter in a transformer. I did see that snippet of code via developer tools and was hoping that maybe there was a way to use the javascript transformer to get around it, but don't have enough knowledge on possibilities.

---

Hi @durshe80

 

 

I agree with what @daleatsafe said. I've been having a look to see what the request looks like when you select School, or Export to Excel. Unfortunately, the header/body in the request are so big it's causing my computer issues with building the request in FME or Postman, so I haven't actually been able to confirm that that method would work.

 

 

You may have to work with the data after exporting it to Excel manually I'm afraid.

---