I’m getting some unwanted duplicate labels when I’m generating them from “Query results” tab with queries other than the one the label has been built upon.
Use-case:
Let’s say that have a specimen NOU051934 (3 collectors, 2 determinations, 2 preparations one in NOU one in P). We have a query NOU-label on which we created the NOU-label report. I carefully read the Specify-6-Report-and-Label-Manual.pdf, particularly the “Fields that cause duplicates” section to do so.
Whether I use the NOU-label query from the Query tab or the NOU-label form from the Report tab, behavior is just fine : in this case I get 2 labels when I query by catalog number (one for NOU, one for P), and just 1 label if I add the NOU herbarium criteria for instance.
Then I just “Save as” the NOU-label query as NOU-label-2. The query result is exactly the same, but then a click on View report button with NOU-label report will always produce 6 labels (3 for NOU, 3 for P) no matter whether I select only the NOU herbarium preparation or both NOU & P preps. Same behavior with any other query but NOU-label => always 6 labels are printed.
Why is it so ?
Thanks for the clarification,
Philippe V., from NOU & CAY herbarium
@pverley you can resolve this by checking the always checkbox for the field that is causing the duplication in the query associated with your report in Specify 6 - usually collector last name or preparations or something like that. Let me know if this doesn’t make sense.
It does make perfect sense. I have aggregated tables in the query associated to the labels, for preparations, determinations and collectors. But I also have single fields associated to these tables, and as suggested, I checked the “always” checkbox, for instance the “is current” for the determination or the “is primary” for the collectors. Doing so, it remove duplicated labels associated with determinations and collectors. But I still have every preparation when printing my label from a query result selecting a single preparation. I do not manage to find the fields causing that (yet!).
Maybe it has something to do with the Storage table since in our case there are always as many storage entries than preparations for a give collection object ?
Yes, it appears that the 1. Herbarium and 3. Collection storage fields are causing that duplication. If you remove those, or uncheck show for those fields it should resolve the issue. There is also a way that you can have the system only print labels for certain preparations by using the prompt checkbox. For instance, if you only wanted to print labels for sheets you could check the prompt checkbox for the preparation type field and then when running the query you will be prompted to select a preparation type in order to print labels.
Indeed, using the Reports prompt form with either the Prep/Type of the 1. Herbarium fields works just fine. This way I can choose exactly for which preparation I print the label.
But it looks like that there is no way to achieve this from the Query Results panel. Either I uncheck the show checkbox of the aforementioned fields and the label is not printing well since I need these fields in the report; or I keep the fields but then when I click on the View report menu button all the preparations are printed.
Not a big deal though since 99% of the time we do want to print all the labels. And now I know that for “cherry-picking” specific labels, I can use the Report prompt form. Solved !
