When using a Constituent Query Follow the Steps Below to create your Export Definition:
- Go to Administration > Export Definitions
- Click Add to add a new Export Definition
- Select the source view of Constituent
- To output the constituencies: In the left column, Constituencies. From the middle column, drag Constituency to Selected Fields
- An export criteria window will pop. In Number to export, leave the number at 1. Under Filter, choose Selected constituencies. From the left column, drag Constituency to Include Records Where. Set this to be equal to the first constituency you would like to report on. Your export criteria should look like this:
- Click OK
- Click the pencil icon at the top of the selected fields column to rename this field in Selected Fields to indicate what Constituency is being outputted.
- Next, to add additional constituencies, highlight the Constituent node in Selected fields and drag over Constituency again.
- A new Export Criteria window will pop. Follow step 5-7 again for your next constituency.
- Repeat for all remaining constituencies.
- Add any additional information you need in your export definition.
- On the Set save options tab, name your export definition and click Save.
- Go to Administration, Export
- Click Add to add a new export
- Name your export process and add a description
- Under Export type, select Export Definition
- Under Selection, choose your revenue query from Step 1.
- Under Export Definition, choose your export definition from Step 2.
- Click Save
- Once your process is saved, click Start Process to generate your list of donations by constituency.
- Go to Administration > Export Definitions
- Click Add to add a new Export Definition
- Select the source view of Revenue
- To output the constituencies: In the left column, expand Constituent, highlight Constituencies. From the middle column, drag Constituency to Selected Fields.
- An export criteria window will pop. In Number to export, leave the number at 1. Under Filter, choose Selected constituencies. From the left column, drag Constituency to Include Records Where. Set this to be equal to the first constituency you would like to report on. Your export criteria should look like this:
- Click OK
- Click the pencil icon at the top of the selected fields column to rename this field in Selected Fields to indicate what Constituency is being outputted.
- Next, to add additional constituencies, highlight the Constituent node in Selected fields and drag over Constituency again.
- A new Export Criteria window will pop. Follow step 5-7 again for your next constituency.
- Repeat for all remaining constituencies.
- Add any additional information you need in your export definition.
- On the Set save options tab, name your export definition and click Save.
- Go to Administration, Export
- Click Add to add a new export
- Name your export process and add a description
- Under Export type, select Export Definition
- Under Selection, choose your revenue query from Step 1.
- Under Export Definition, choose your export definition from Step 2.
- Click Save
- Once your process is saved, click Start Process to generate your list of donations by constituency.