nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problems with da SearchCursor results from LIKE query

ChrisStanley

I have built an app with WxPython to run in Arcmap to search some tables that are already existing in ArcMap as a Python Addin. I have a few fields in this table that will get results just fine and some fields that will get correct results and then no results from the same field with just different search values. My search is a LIKE type query, Ex, if I enter 55 as my search value, my WxPython app will not finish and open the PDF that has the results. If I enter 61 my search will finish and open the PDF with the appropriate data in the report. I do know there are several rows in my table that should be in the 355 search results.

If I run the code in the ArcMap Python window against the table with the 55 value I get the expected results with no problem from the cursor. The only difference that I can see are the variables I am using in the query. If I run it in the ArcMap Python window I am setting the variables manually to make sure the query is good. In the WxPython App I am getting one variable from a selection made from a dropdown for the field "ESN" and the search value is from a text box where the user enters the value, "55".

The examples below are from a script that I am testing in the ArcMap window and then the search that my WxPython App is using. The syntax is all correct so the indentations may be different between the two. My main issue is why can't I get results when I use "55" as my value and I can get results when I search "61" when there are values in the table that should get results when I search LIKE '%55%'. Also this same thing is happening in the Community field when I search LIKE values in there as well.

I have tested several variations and other fields and most everything will return results but I can't see any reason these will not.

Any help would be GREATLY appreciated!!!

Thanks

Chris

Here is the snippet from my manual search that gives me the results I want:

test <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ESN'</SPAN>

<SPAN class="comment token">#Query to retreive data from gisMSAG for GeoSearch...</SPAN>
story <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
results<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'LOW'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'HIGH'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DIR'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'STREET NAME'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EOB'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'COMMUNITY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ZIP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ESN'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'SRNUM'</SPAN><SPAN class="punctuation token">]</SPAN>
story<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>fields<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc3<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN>dir<SPAN class="punctuation token">,</SPAN>sname<SPAN class="punctuation token">,</SPAN>low<SPAN class="punctuation token">,</SPAN>high<SPAN class="punctuation token">,</SPAN>com<SPAN class="punctuation token">,</SPAN>eob<SPAN class="punctuation token">,</SPAN>esn<SPAN class="punctuation token">,</SPAN>sr<SPAN class="punctuation token">,</SPAN>zip<SPAN class="punctuation token">,</SPAN>desc<SPAN class="punctuation token">,</SPAN>rem<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>test<SPAN class="operator token">+</SPAN><SPAN class="string token">" LIKE UPPER('%55%')"</SPAN><SPAN class="punctuation token">,</SPAN>sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ORDER BY '</SPAN><SPAN class="operator token">+</SPAN>sname<SPAN class="operator token">+</SPAN><SPAN class="string token">' ASC, '</SPAN><SPAN class="operator token">+</SPAN>low<SPAN class="operator token">+</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor5<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">for</SPAN> mg <SPAN class="keyword token">in</SPAN> cursor5<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagdir <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagsname <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msaglow <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msaghigh <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagcom <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msageob <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagesn <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagsr <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagzip <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;display <SPAN class="operator token">=</SPAN> msaglow<SPAN class="punctuation token">,</SPAN>msaghigh<SPAN class="punctuation token">,</SPAN>msagdir<SPAN class="punctuation token">,</SPAN>msagsname<SPAN class="punctuation token">,</SPAN>msageob<SPAN class="punctuation token">,</SPAN>msagcom<SPAN class="punctuation token">,</SPAN>msagzip<SPAN class="punctuation token">,</SPAN>msagesn<SPAN class="punctuation token">,</SPAN>msagsr
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;story<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>display<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> story<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Here is the snipped of the same search from my WxPython App:

story <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
results<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'LOW'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'HIGH'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DIR'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'STREET NAME'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EOB'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'COMMUNITY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ZIP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ESN'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'SRNUM'</SPAN><SPAN class="punctuation token">]</SPAN>
story<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>fields<SPAN class="punctuation token">)</SPAN>
self<SPAN class="punctuation token">.</SPAN>SBar<SPAN class="punctuation token">.</SPAN>SetStatusText<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>selectedfield<SPAN class="operator token">+</SPAN><SPAN class="string token">" "</SPAN><SPAN class="operator token">+</SPAN>searchvalue<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc3<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN>dir<SPAN class="punctuation token">,</SPAN>sname<SPAN class="punctuation token">,</SPAN>low<SPAN class="punctuation token">,</SPAN>high<SPAN class="punctuation token">,</SPAN>com<SPAN class="punctuation token">,</SPAN>eob<SPAN class="punctuation token">,</SPAN>esn<SPAN class="punctuation token">,</SPAN>sr<SPAN class="punctuation token">,</SPAN>zip<SPAN class="punctuation token">,</SPAN>desc<SPAN class="punctuation token">,</SPAN>rem<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>selectedfield<SPAN class="operator token">+</SPAN><SPAN class="string token">" LIKE '%"</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>searchvalue<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"%'"</SPAN><SPAN class="punctuation token">,</SPAN>sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ORDER BY '</SPAN><SPAN class="operator token">+</SPAN>sname<SPAN class="operator token">+</SPAN><SPAN class="string token">' ASC, '</SPAN><SPAN class="operator token">+</SPAN>low<SPAN class="operator token">+</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor5<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">for</SPAN> mg <SPAN class="keyword token">in</SPAN> cursor5<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagdir <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagsname <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msaglow <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msaghigh <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagcom <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msageob <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagesn <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagsr <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msagzip <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;display <SPAN class="operator token">=</SPAN> msaglow<SPAN class="punctuation token">,</SPAN>msaghigh<SPAN class="punctuation token">,</SPAN>msagdir<SPAN class="punctuation token">,</SPAN>msagsname<SPAN class="punctuation token">,</SPAN>msageob<SPAN class="punctuation token">,</SPAN>msagcom<SPAN class="punctuation token">,</SPAN>msagzip<SPAN class="punctuation token">,</SPAN>msagesn<SPAN class="punctuation token">,</SPAN>msagsr
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;story<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>display<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> story‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

ChrisStanley

All,

I wanted to follow up with an update on this issue in case someone else runs into this in the future. I was able to get everything resolved. The issue was with line 98 where I had put in "print story". I had this in there when I was creating everything so I could see results during testing and never really thought anything about it. I could tell that with some queries that would work that the amount of records being returned were less than the queries that wouldn't work. For some queries like the "55" that was failing, once I took out 20 records from the table that one would work. I was just cleaning up some of the code and commenting out unnecessary things and once I commented out the "print story" every query ran with no issues. The only thing I could think of was that something with building the story for ReportLab wasn't liking that because the "print story" worked fine when I ran queries outside of my application. Either way it's working now and I appreciate everyone's input and assistance to work through the issue.

Chris

NathanHeick

I think your error is related to line 255 or a combination of 252 and 255. I think Popen is trying to open a file that has already been closed.

Try using os.system(fileopen) instead or do more research on that error, reportlab, WxPython, and Popen. I think there may be multiple threads trying to access the same file at the same time.

Nathan

DanPatterson_Retired

The word 'form' rings a bell... I know Arc* doesn't play well with Tk so I am guessing it could be an issue. If the can be run as a script via providing the parameters outside a dialog interface and it works... then you have your solution. If you are running this inside of arcmap anyway, why not use a conventional script tool or a python tool and toolbox?

ChrisStanley

Today I setup the Try-except and initially it didn't yield any results on just the cursor but I put it on the whole script so it would catch anything and I did get a result but I've researched it and cannot find anything similar to what doing.

The error I am getting when the issue happens with ESN LIKE '%55%' is Errno 9 Bad file descriptor

I tested with a value that I know works in my form and the error was not in the file from the Except and I tested with the 55 and it is in the file so I'm pretty sure that this is what I've been looking for but I haven't been able to find anything yet.

I'm thinking it's something with WXPython somehow because I can take this same script and fill in the values I'm getting from the form right in the script and just run it only in python and I get results every time I search anything.

Thanks again for the replies so far....

Chris

NathanHeick

You need to find a debugging method to isolate the problem to a specific line. Can you launch your application from a command line and print to stdout? At the least, you could always write to a file. You should be able to wrap the cursor in a try-except block and write the rows and any error messages to stdout or a file. I suspect the cursor may be fine and the report is choking on the records you pass into it for certain searches.

Nathan

DanPatterson_Retired

your EDN field contains just 3 numbers in text format? #1, there is no need for upper, #2 why not get rid of the % stuff all together for testing... I am sure that someone can enter 3 values. I might suggest that you ... 'str' ... any values entered to rule out numbers not being converted to text

ChrisStanley

Thanks to all of the replies......I did try removing the sql_clause and I still get the same results and just to make sure, I did change the zip and dir variables that I had set but it didn't change anything.

I have posted the complete code here to see if some can see anything.

I have tried multiple things and cannot understand why some numbers will return results and some will not. If I select ESN from my dropdown on the form that becomes the selectedfield variable and whatever I enter into the text box on the form becomes the searchvalue variable.

Everything I am searching for is in the table and I should get results. If I search something that I know is not in the dataset I will still get the PDF to open but with 0 results. If I enter 55 the PDF never opens so I know something in the query is not working. If I enter 62 I get results with several records and the PDF opens with the results. Everything I've tried in the 50's doesn't work but most of the 60's will work. Below is the table so you can see there are values with 55.

If I do this same search in Select By Attributes it will select fine.

I have another dataset that I have built this on and everything in that works fine, no issues like this, I can get results on anything I search. I did switch out this table with the same table from my test dataset just to make sure they are the same but still have the same results.

I really do not know where things are breaking or why.

Chris

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> pythonaddins
<SPAN class="keyword token">import</SPAN> wx
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> subprocess
<SPAN class="keyword token">import</SPAN> datetime
<SPAN class="keyword token">import</SPAN> sys
<SPAN class="keyword token">import</SPAN> traceback
<SPAN class="keyword token">from</SPAN> reportlab<SPAN class="punctuation token">.</SPAN>pdfgen <SPAN class="keyword token">import</SPAN> canvas
<SPAN class="keyword token">from</SPAN> reportlab<SPAN class="punctuation token">.</SPAN>lib<SPAN class="punctuation token">.</SPAN>pagesizes <SPAN class="keyword token">import</SPAN> letter<SPAN class="punctuation token">,</SPAN> landscape<SPAN class="punctuation token">,</SPAN> portrait<SPAN class="punctuation token">,</SPAN> A4
<SPAN class="keyword token">from</SPAN> reportlab<SPAN class="punctuation token">.</SPAN>platypus <SPAN class="keyword token">import</SPAN> Image<SPAN class="punctuation token">,</SPAN> Paragraph<SPAN class="punctuation token">,</SPAN> Table<SPAN class="punctuation token">,</SPAN>SimpleDocTemplate<SPAN class="punctuation token">,</SPAN>Frame<SPAN class="punctuation token">,</SPAN> BaseDocTemplate<SPAN class="punctuation token">,</SPAN> PageTemplate<SPAN class="punctuation token">,</SPAN> TableStyle
<SPAN class="keyword token">from</SPAN> reportlab<SPAN class="punctuation token">.</SPAN>lib<SPAN class="punctuation token">.</SPAN>colors <SPAN class="keyword token">import</SPAN> red<SPAN class="punctuation token">,</SPAN> black
<SPAN class="keyword token">from</SPAN> reportlab<SPAN class="punctuation token">.</SPAN>lib<SPAN class="punctuation token">.</SPAN>styles <SPAN class="keyword token">import</SPAN> ParagraphStyle<SPAN class="punctuation token">,</SPAN> getSampleStyleSheet
<SPAN class="keyword token">from</SPAN> reportlab<SPAN class="punctuation token">.</SPAN>lib<SPAN class="punctuation token">.</SPAN>units <SPAN class="keyword token">import</SPAN> inch
<SPAN class="keyword token">from</SPAN> reportlab<SPAN class="punctuation token">.</SPAN>lib<SPAN class="punctuation token">.</SPAN>enums <SPAN class="keyword token">import</SPAN> TA_JUSTIFY<SPAN class="punctuation token">,</SPAN> TA_LEFT<SPAN class="punctuation token">,</SPAN> TA_CENTER
<SPAN class="keyword token">from</SPAN> reportlab<SPAN class="punctuation token">.</SPAN>lib <SPAN class="keyword token">import</SPAN> colors



selectedfield <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">.</SPAN>TableFields<SPAN class="punctuation token">.</SPAN>GetValue<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
searchvalue <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">.</SPAN>SearchValue<SPAN class="punctuation token">.</SPAN>GetValue<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
msagradio <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">.</SPAN>radiobtnMSAG<SPAN class="punctuation token">.</SPAN>GetValue<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
intradio <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">.</SPAN>radiobtnINT<SPAN class="punctuation token">.</SPAN>GetValue<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
maddrradio <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">.</SPAN>radiobtnMAddr<SPAN class="punctuation token">.</SPAN>GetValue<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">if</SPAN> msagradio <SPAN class="operator token">==</SPAN> <SPAN class="string token">"True"</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="comment token">#Get Date/Time needed</SPAN>
self<SPAN class="punctuation token">.</SPAN>SBar<SPAN class="punctuation token">.</SPAN>SetStatusText<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Building MSAG Geo Search Report.....'</SPAN><SPAN class="punctuation token">)</SPAN>
now <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
filedate <SPAN class="operator token">=</SPAN> now<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"%m%d%Y"</SPAN><SPAN class="punctuation token">)</SPAN>
filemonth <SPAN class="operator token">=</SPAN> now<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"%m%Y"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Get Agency Demographics from GBO Report Settings Table</SPAN>
fc1 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"gboReportSettings"</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc1<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"PROPERTY"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"VALUE"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> ad <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"AgencyName"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; agencyname <SPAN class="operator token">=</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"AgencyState"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; agencystate <SPAN class="operator token">=</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"AgencyDeptName"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; agencydept <SPAN class="operator token">=</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"REPORTDIRECTORY"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reportpath <SPAN class="operator token">=</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"AgencyMail"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mail <SPAN class="operator token">=</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"AgencyMailCity"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mailcity <SPAN class="operator token">=</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"AgencyPhone"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; phone <SPAN class="operator token">=</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"AgencyFax"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fax <SPAN class="operator token">=</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"AgencyEmail"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; email <SPAN class="operator token">=</SPAN> ad<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">trim</SPAN><SPAN class="punctuation token">(</SPAN>fieldvalue<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldvalue<SPAN class="operator token">=</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>fieldvalue<SPAN class="punctuation token">.</SPAN>strip<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> fieldvalue<SPAN class="punctuation token">:</SPAN> fieldvalue<SPAN class="operator token">=</SPAN><SPAN class="string token">' '</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> fieldvalue

<SPAN class="comment token">#Get fields from gisMSAG table in GBO and set fields to display on report</SPAN>
fc3 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"gisMSAG"</SPAN>
msagf <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>f<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>fc3<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">print</SPAN> msagf
dirs <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
sname <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
low <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
high <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
com <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
eob <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
esn <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
sr <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">21</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
zips <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">22</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
mapgrid <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">23</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
desc <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">24</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
rem <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>msagf<SPAN class="punctuation token">[</SPAN><SPAN class="number token">25</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
msagfields <SPAN class="operator token">=</SPAN> dirs<SPAN class="punctuation token">,</SPAN>sname<SPAN class="punctuation token">,</SPAN>low<SPAN class="punctuation token">,</SPAN>high<SPAN class="punctuation token">,</SPAN>com<SPAN class="punctuation token">,</SPAN>eob<SPAN class="punctuation token">,</SPAN>esn<SPAN class="punctuation token">,</SPAN>sr<SPAN class="punctuation token">,</SPAN>zips<SPAN class="punctuation token">,</SPAN>desc<SPAN class="punctuation token">,</SPAN>rem

<SPAN class="comment token">#Query to retreive data from Address Points for edited in last # of days</SPAN>
story <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
results<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'LOW'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'HIGH'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DIR'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'STREET NAME'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EOB'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'COMMUNITY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ZIP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ESN'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'SRNUM'</SPAN><SPAN class="punctuation token">]</SPAN>
story<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>fields<SPAN class="punctuation token">)</SPAN>
query <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>selectedfield<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">" LIKE UPPER('%"</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>searchvalue<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"%')"</SPAN>
self<SPAN class="punctuation token">.</SPAN>SBar<SPAN class="punctuation token">.</SPAN>SetStatusText<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>query<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc3<SPAN class="punctuation token">,</SPAN>msagfields<SPAN class="punctuation token">,</SPAN>query<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor5<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> mg <SPAN class="keyword token">in</SPAN> cursor5<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msagdir <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msagsname <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msaglow <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msaghigh <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msagcom <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msageob <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msagesn <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msagsr <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msagzip <SPAN class="operator token">=</SPAN> mg<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; display <SPAN class="operator token">=</SPAN> msaglow<SPAN class="punctuation token">,</SPAN>msaghigh<SPAN class="punctuation token">,</SPAN>msagdir<SPAN class="punctuation token">,</SPAN>msagsname<SPAN class="punctuation token">,</SPAN>msageob<SPAN class="punctuation token">,</SPAN>msagcom<SPAN class="punctuation token">,</SPAN>msagzip<SPAN class="punctuation token">,</SPAN>msagesn<SPAN class="punctuation token">,</SPAN>msagsr
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; story<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>display<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> story
self<SPAN class="punctuation token">.</SPAN>SBar<SPAN class="punctuation token">.</SPAN>SetStatusText<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Gets Past query.....'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#Count Records in Cursor5</SPAN>
rowCount <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor5<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rowCount <SPAN class="operator token">=</SPAN> rowCount <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN>
<SPAN class="keyword token">print</SPAN> rowCount
count <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Total Records from Selection: "</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>rowCount<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
story<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>count<SPAN class="punctuation token">)</SPAN>

styles <SPAN class="operator token">=</SPAN> getSampleStyleSheet<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
styleN <SPAN class="operator token">=</SPAN> styles<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Normal'</SPAN><SPAN class="punctuation token">]</SPAN>
styleH <SPAN class="operator token">=</SPAN> styles<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Heading1'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># bodytext&nbsp; style used for wrapping&nbsp; data on flowables</SPAN>
styles <SPAN class="operator token">=</SPAN> getSampleStyleSheet<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
styleN <SPAN class="operator token">=</SPAN> styles<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"BodyText"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">#used alignment if required</SPAN>
styleN<SPAN class="punctuation token">.</SPAN>alignment <SPAN class="operator token">=</SPAN> TA_LEFT

styleBH <SPAN class="operator token">=</SPAN> styles<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Normal"</SPAN><SPAN class="punctuation token">]</SPAN>
styleBH<SPAN class="punctuation token">.</SPAN>alignment <SPAN class="operator token">=</SPAN> TA_CENTER
styleBH<SPAN class="punctuation token">.</SPAN>fontSize <SPAN class="operator token">=</SPAN> <SPAN class="number token">24</SPAN>

sdName <SPAN class="operator token">=</SPAN> Paragraph<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"<b>"</SPAN><SPAN class="operator token">+</SPAN>agencyname<SPAN class="operator token">+</SPAN><SPAN class="string token">"</b>"</SPAN><SPAN class="punctuation token">,</SPAN> styleBH<SPAN class="punctuation token">)</SPAN>

styleBH2 <SPAN class="operator token">=</SPAN> styles<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Normal"</SPAN><SPAN class="punctuation token">]</SPAN>
styleBH2<SPAN class="punctuation token">.</SPAN>alignment <SPAN class="operator token">=</SPAN> TA_CENTER
styleBH2<SPAN class="punctuation token">.</SPAN>fontSize <SPAN class="operator token">=</SPAN> <SPAN class="number token">12</SPAN>
self<SPAN class="punctuation token">.</SPAN>SBar<SPAN class="punctuation token">.</SPAN>SetStatusText<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Gets to Field Labels.....'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#Replace field label names.....</SPAN>
<SPAN class="keyword token">if</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>dirs<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Prefix Direction"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>com<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Community"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>sname<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Street Name"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>low<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Low Number"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>high<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"High Number"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>com<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Community"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>eob<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Even/Odd/Both"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>esn<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ESN"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>sr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> "State Road <SPAN class="comment token">#"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>zips<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Zip Code"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>mapgrid<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Map Grid"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>desc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Description"</SPAN>
<SPAN class="keyword token">elif</SPAN> selectedfield <SPAN class="operator token">==</SPAN> str<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN>rem<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; fieldlabel <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Remarks"</SPAN>

self<SPAN class="punctuation token">.</SPAN>SBar<SPAN class="punctuation token">.</SPAN>SetStatusText<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Gets to Title.....'</SPAN><SPAN class="punctuation token">)</SPAN>
componentA <SPAN class="operator token">=</SPAN> Paragraph<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'<i>MSAG Geo Search Report - '</SPAN><SPAN class="operator token">+</SPAN>fieldlabel<SPAN class="operator token">+</SPAN><SPAN class="string token">' Containing "'</SPAN><SPAN class="operator token">+</SPAN>searchvalue<SPAN class="operator token">+</SPAN><SPAN class="string token">'"</i>'</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; styleBH2<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#<font color=red></SPAN>
headerdata<SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>sdName<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN>componentA<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>

table <SPAN class="operator token">=</SPAN> Table<SPAN class="punctuation token">(</SPAN>headerdata<SPAN class="punctuation token">,</SPAN>colWidths <SPAN class="operator token">=</SPAN> <SPAN class="number token">745</SPAN><SPAN class="punctuation token">)</SPAN>

table<SPAN class="punctuation token">.</SPAN>setStyle<SPAN class="punctuation token">(</SPAN>TableStyle<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'LINEBELOW'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>colors<SPAN class="punctuation token">.</SPAN>black<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#('BOX', (0,0), (-1,2), 0.25, colors.black),</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#('BOX', (0,1), (-1,2), 0.25, colors.black),</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ALIGNMENT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'CENTER'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#('GRID', (0,0), (-1,-1), 0.25, colors.black),</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

footerdata<SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>agencyname <SPAN class="operator token">+</SPAN><SPAN class="string token">"-"</SPAN><SPAN class="operator token">+</SPAN>agencydept<SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Phone:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "</SPAN><SPAN class="operator token">+</SPAN>phone<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN>mail<SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Fax:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "</SPAN><SPAN class="operator token">+</SPAN>fax<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN>mailcity<SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>email<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>

footertable <SPAN class="operator token">=</SPAN> Table<SPAN class="punctuation token">(</SPAN>footerdata<SPAN class="punctuation token">,</SPAN>colWidths <SPAN class="operator token">=</SPAN> <SPAN class="number token">249</SPAN><SPAN class="punctuation token">)</SPAN>

footertable<SPAN class="punctuation token">.</SPAN>setStyle<SPAN class="punctuation token">(</SPAN>TableStyle<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'LINEABOVE'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>colors<SPAN class="punctuation token">.</SPAN>black<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#('BOX', (0,0), (-1,2), 0.25, colors.black),</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#('BOX', (0,1), (-1,2), 0.25, colors.black),</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ALIGNMENT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'LEFT'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ALIGNMENT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'RIGHT'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'BOTTOMPADDING'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#('GRID', (0,0), (-1,-1), 0.25, colors.black),</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">header</SPAN><SPAN class="punctuation token">(</SPAN>canvas<SPAN class="punctuation token">,</SPAN> doc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; canvas<SPAN class="punctuation token">.</SPAN>saveState<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; P <SPAN class="operator token">=</SPAN> Paragraph<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"This is a multi-line footer. It goes on every page. "</SPAN> <SPAN class="operator token">*</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> styleN<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; w<SPAN class="punctuation token">,</SPAN> h <SPAN class="operator token">=</SPAN> P<SPAN class="punctuation token">.</SPAN>wrap<SPAN class="punctuation token">(</SPAN>doc<SPAN class="punctuation token">.</SPAN>width<SPAN class="punctuation token">,</SPAN> doc<SPAN class="punctuation token">.</SPAN>topMargin<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp; table<SPAN class="punctuation token">.</SPAN>wrapOn<SPAN class="punctuation token">(</SPAN>canvas<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">650</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">500</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; table<SPAN class="punctuation token">.</SPAN>drawOn<SPAN class="punctuation token">(</SPAN>canvas<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">25</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">550</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp; canvas<SPAN class="punctuation token">.</SPAN>restoreState<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">footer</SPAN><SPAN class="punctuation token">(</SPAN>canvas<SPAN class="punctuation token">,</SPAN> doc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; canvas<SPAN class="punctuation token">.</SPAN>saveState<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; P <SPAN class="operator token">=</SPAN> Paragraph<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"This is a multi-line footer. It goes on every page. "</SPAN> <SPAN class="operator token">*</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> styleN<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; w<SPAN class="punctuation token">,</SPAN> h <SPAN class="operator token">=</SPAN> P<SPAN class="punctuation token">.</SPAN>wrap<SPAN class="punctuation token">(</SPAN>doc<SPAN class="punctuation token">.</SPAN>width<SPAN class="punctuation token">,</SPAN> doc<SPAN class="punctuation token">.</SPAN>topMargin<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp; footertable<SPAN class="punctuation token">.</SPAN>wrapOn<SPAN class="punctuation token">(</SPAN>canvas<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">650</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">500</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; footertable<SPAN class="punctuation token">.</SPAN>drawOn<SPAN class="punctuation token">(</SPAN>canvas<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">25</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pagenum <SPAN class="operator token">=</SPAN> canvas<SPAN class="punctuation token">.</SPAN>getPageNumber<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; text <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Page %s"</SPAN> <SPAN class="operator token">%</SPAN> pagenum
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; canvas<SPAN class="punctuation token">.</SPAN>drawString<SPAN class="punctuation token">(</SPAN><SPAN class="number token">380</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">10</SPAN> <SPAN class="punctuation token">,</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; canvas<SPAN class="punctuation token">.</SPAN>restoreState<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>exists<SPAN class="punctuation token">(</SPAN>reportpath<SPAN class="operator token">+</SPAN>filemonth<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; os<SPAN class="punctuation token">.</SPAN>makedirs<SPAN class="punctuation token">(</SPAN>reportpath<SPAN class="operator token">+</SPAN>filemonth<SPAN class="punctuation token">)</SPAN>

doc <SPAN class="operator token">=</SPAN> BaseDocTemplate<SPAN class="punctuation token">(</SPAN>reportpath <SPAN class="operator token">+</SPAN> filemonth <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"MSAGGeoSearchReport.pdf"</SPAN><SPAN class="punctuation token">,</SPAN> pagesize <SPAN class="operator token">=</SPAN> landscape<SPAN class="punctuation token">(</SPAN>letter<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
fileopen <SPAN class="operator token">=</SPAN> reportpath <SPAN class="operator token">+</SPAN> filemonth <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"MSAGGeoSearchReport.pdf"</SPAN>
frame <SPAN class="operator token">=</SPAN> Frame<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">65</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">790</SPAN><SPAN class="punctuation token">,</SPAN> doc<SPAN class="punctuation token">.</SPAN>height<SPAN class="punctuation token">,</SPAN> id<SPAN class="operator token">=</SPAN><SPAN class="string token">'normal'</SPAN><SPAN class="punctuation token">)</SPAN>


template <SPAN class="operator token">=</SPAN> PageTemplate<SPAN class="punctuation token">(</SPAN>id<SPAN class="operator token">=</SPAN><SPAN class="string token">'test'</SPAN><SPAN class="punctuation token">,</SPAN> frames<SPAN class="operator token">=</SPAN>frame<SPAN class="punctuation token">,</SPAN> onPage<SPAN class="operator token">=</SPAN>header<SPAN class="punctuation token">,</SPAN>onPageEnd<SPAN class="operator token">=</SPAN>footer<SPAN class="punctuation token">)</SPAN>
doc<SPAN class="punctuation token">.</SPAN>addPageTemplates<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>template<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>


elements<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">#columns = [45,45,45,270,40,150,45,45,55]</SPAN>
t <SPAN class="operator token">=</SPAN> Table<SPAN class="punctuation token">(</SPAN>story<SPAN class="punctuation token">,</SPAN> rowHeights<SPAN class="operator token">=</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">,</SPAN> repeatRows<SPAN class="operator token">=</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> hAlign <SPAN class="operator token">=</SPAN> <SPAN class="string token">'CENTER'</SPAN><SPAN class="punctuation token">)</SPAN>
t<SPAN class="punctuation token">.</SPAN>setStyle<SPAN class="punctuation token">(</SPAN>TableStyle<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ALIGN'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'LEFT'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'GRID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.25</SPAN><SPAN class="punctuation token">,</SPAN> colors<SPAN class="punctuation token">.</SPAN>black<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'BOX'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> colors<SPAN class="punctuation token">.</SPAN>black<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'TEXTCOLOR'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> colors<SPAN class="punctuation token">.</SPAN>red<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'FONTSIZE'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">12</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'RIGHTPADDING'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">15</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'SPAN'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'TEXTCOLOR'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> colors<SPAN class="punctuation token">.</SPAN>red<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'INNERGRID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0.25</SPAN><SPAN class="punctuation token">,</SPAN> colors<SPAN class="punctuation token">.</SPAN>black<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

data_len <SPAN class="operator token">=</SPAN> len<SPAN class="punctuation token">(</SPAN>story<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> each <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>data_len<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> each <SPAN class="operator token">%</SPAN> <SPAN class="number token">2</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bg_color <SPAN class="operator token">=</SPAN> colors<SPAN class="punctuation token">.</SPAN>white
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bg_color <SPAN class="operator token">=</SPAN> colors<SPAN class="punctuation token">.</SPAN>lavender

&nbsp;&nbsp;&nbsp;&nbsp; t<SPAN class="punctuation token">.</SPAN>setStyle<SPAN class="punctuation token">(</SPAN>TableStyle<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'BACKGROUND'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> each<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> each<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> bg_color<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

elements<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>t<SPAN class="punctuation token">)</SPAN>
doc<SPAN class="punctuation token">.</SPAN>build<SPAN class="punctuation token">(</SPAN>elements<SPAN class="punctuation token">)</SPAN>
self<SPAN class="punctuation token">.</SPAN>SBar<SPAN class="punctuation token">.</SPAN>SetStatusText<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Geo Search Report Finished.....'</SPAN><SPAN class="punctuation token">)</SPAN>
self<SPAN class="punctuation token">.</SPAN>SBar<SPAN class="punctuation token">.</SPAN>SetStatusText<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>query <SPAN class="operator token">+</SPAN> <SPAN class="string token">" - END Print"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
subprocess<SPAN class="punctuation token">.</SPAN>Popen<SPAN class="punctuation token">(</SPAN>fileopen<SPAN class="punctuation token">,</SPAN> shell<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

XanderBakker

The thing I notice is the strange way the list of field is defined. Since you did not post the complete code, it is difficult to see if this is really wrong. You are not specifying strings, but variables and including two reserved words (dir and zip). I don't think that will work, unless you defined those variable somewhere before referring to names of the fields and thereby overwritten the dir and zip objects (which remains strange, since just before the SearchCursor statement, you define a list of field names).

NathanHeick

I would try removing the sql_clause and retesting it.

Nathan

DanPatterson_Retired

Well, the field names look the same, the LIKE query has single quotes around them, you have the %s around the numbers.... and assuming that 55 does exist, I have no clue. Try %5% does that bring up 55? are any other numbers experience this bizarre behaviour?

ChrisStanley

I set the query to print in my status bar and both look the same:

I have a status bar entry set before the script runs since something is causing it to fail and then one at the end just before the script finishes and opens a PDF.

This one comes up when I put in a value of 55 and the script stops just after this during the cursor.

This one works and comes up at the end of the script and then opens the PDF with the search results. The - END Print part is just extra string I put in to show when it printed.

They both look the same to me except for the numbers being searched.

DanPatterson_Retired

At this stage, I would throw a print statement, capturing the query to make sure it is properly formatted in both cases

ChrisStanley

Also, if I need to post the whole thing I can, I was just mainly wanting to make sure I wasn't missing something and couldn't figure out why 61 will work and 55 will not. It's very weird.

Thanks

Chris

ChrisStanley

OK, see if that's better, I didn't realize it would put it in there that way.....thanks

Chris

DanPatterson_Retired

Chris /blogs/dan_patterson/2016/08/14/script-formatting

Currently it is kind of hard to read

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.