Latest Contributions by BrianaMercuri

Thank you! This helped me understand what I needed to do. So I got the loop to generate reports working, but I get a System.OutOfMemoryException: Out of Memory error for some of the reports I am trying to run. My layer does have a lot of photos in it, but I thought splitting it up with this loop would help out more. I got about half my reports to run, so not bad. But does anyone know how to fix this memory issue? #import the libraries you need import arcpy from arcpy import da import os #you tell it which layer you want to search through and which field(s) you want fields=["OBJECTID", "Name"] #field list since I wanted more than one tanks=da.SearchCursor("Storage", fields) #cursor #using the cursor you established, you can loop through and do stuff with tanks as cursor: for item in cursor: try: #identify the map document mxd = arcpy.mapping.MapDocument(r'MYPATH.mxd') df = arcpy.mapping.ListDataFrames(mxd)[0] #which layer you need to loop over lyr = arcpy.mapping.ListLayers(mxd, "Storage", df)[0] #create the pdf filename by using the Name field in Storage filename="\\"+str(item[1])+".pdf" #create the path for the pdf to be saved in path=r'OUTFOLDERPATH' + filename #this is where we search through the table to make our selections to run the report on #I get the first value (the OBJECTID) from the cursor list value=item[0] #I identify that I will be searching using OBJECTID field="OBJECTID" #create an expression to use to select the record I want in this iteration #it checks that "OBJECTID" is = whatever value we are on in the cursor list exp=str(field) + "=" +str(value) #now I make my selection from the lyr object, it uses the expression from above point_lyr=arcpy.SelectLayerByAttribute_management(lyr,"NEW_SELECTION",exp) #now I can run the report on the lyr, specify the report template, give it the output path, and tell it to run on the selected items only arcpy.mapping.ExportReport(lyr, r'REPORTPATH.rlf', path, "SELECTED") except: #i do this because i get storage errors continue‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Error from report viewer: Error from Python: Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> File "c:\program files (x86)\arcgis\desktop10.7\arcpy\arcpy\utils.py", line 182, in fn_ return fn(*args, **kw) File "c:\program files (x86)\arcgis\desktop10.7\arcpy\arcpy\mapping.py", line 532, in ExportReport return report_source._arc_object.ExportReport(*gp_fixargs((report_layout_file, output_file, dataset_option, report_title, starting_page_number, page_range, report_definition_query, extent, field_map), True)) RuntimeError: Error in generating report‍‍‍‍‍‍‍‍ ... View more