Reports not generating correctly despite setting layer criteria

[Kira Bennett]

Hi

 

So I am having trouble generating reports like I want to. I have done this before and didn't have an issue last time - this is my current process and what I am trying to do;

 

- I have a landscape site plan with a number of planting zones. Each planting zone is split onto its own layer with all the corresponding plants placed on that layer only.

- When I come to create a report for this, I click on the layer for the planting zone, for example layer 'Planting Zone 2', then click Tools>Create Report. I then select the Preformatted Report 'Planting List Simple'. It generates a report of all plants inside the document, so I go to the criteria settings and set 'layer' as 'Planting Zone 2' - but it doesn't update the report to only show the 7 plants on that layer, instead it continues to show all 200+ plants on the worksheet. 

 

Please help, what am I doing wrong?

 

Thank you so much

Kira

 

[Pat Stanford]

Please post a screen shot of the Edit Criteria dialog box or post the file so we can see what is happening.

[Kira Bennett]

Hey

 

Let me know if this shows enough

 

Note: In planting zone 3 there are 193 plants, as is correct on the criteria objects preview at the bottom. But when I click okay the worksheet doesn't update and shows all plants in the drawing.

 

 

 

[Pat Stanford]

The Criteria dialog box looks right, but the information in the formula bar looks wrong.

 

Right click on the database header row and choose Edit Database Forumula.  In the formula bar you should see something like:

 

=DATABASE((L='Planting Zone 3'))

 

If there is not all of the above, or there is additional stuff after the parens, then the formula is wrong and that is probably why it is returning all the objects in the drawing.

 

But also look at the Criteria window. It says there are 197 objects that meet the Planting Zone 3 layer criteria.  Make sure that the objects are all on the correct layers also.

[Kira Bennett]

Hey Thank you so much for the help and getting back to me. So I edited the formula in the Database header box as advised for Planting Zone 3 and it correctly produced the worksheet for that layer.

I then attempted to do this with 'Planting Zone 2' (all plants are on their own layer separate to Planting Zone 3) and the problem of all plants being detected on the report occurred again. I pasted the formula in the header box (image 1 below) changing the location to Planting Zone 2 (where 9 plants are included on the layer, but when I press ok it still produces a record including the plants in Planting Zone 3' aaahh...... so sorry I can't find a way round this myself.

 

 

I tried to edit the criteria again to be Layer>Planting Zone 2, but then it did this?? (image 2 below)

 

[Pat Stanford]

It looks like you are typing it into cell A2 rather than right clicking on the Row Header and choosing Show Database Formula or using the Criteria builder.

 

[Kira Bennett]

Hey Pat,

 

Thank you for confirming this, I was pasting this information into the wrong box, but now it is working as I would like - Thank you so so much for the help and speedy reply. You have been great 🙂