Dan,
You're correct. I ran a test report on 651 and 901 tags with the subfields a and b. The results display 651 a & b, as well as 901 a and b. Perhaps there is a different way to filter than what I'm using. Or using Excel you could do further data manipulation. Thanks for pointing that out.
CM

On 05/06/2014 09:35 AM, Dan Wells wrote:
One thing I'm not sure you can do in the reporter is group filters.  For 
example, I don't think you could pull 650a and 911b.  Instead, you effectively 
end up with the cross product of 650ab and 911ab.  Sometimes this limitation 
matters, sometimes it doesn't.

Also, if I'm mistaken, I'd love to know about it.

Thanks,
Dan


Daniel Wells
Library Programmer/Analyst
Hekman Library, Calvin College
616.526.7133

-----Original Message-----
From: open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of 
Chauncey Montgomery
Sent: Tuesday, May 06, 2014 9:04 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Report Generation

   Jayaraj,
On your filters for tags and subfields, change the operator to "in list." When 
you build your report, you'll have empty text boxes to enter the information you want to 
filter on.  You can enter more than one element into that filter. For example, with the 
tag, I can enter 600 in the box and click add, then 650 and click add again, and now the 
report should filter on both.  See the attached screenshot for the example.  I hope that 
makes sense. Good luck and keep us posted on the outcome.
CM
--
Chauncey G. Montgomery, MLIS
Director/Fiscal Officer | Community Library
44 Burrer Drive | Sunbury, OH 43074
740-965-3901 | http://community.lib.oh.us


On 05/06/2014 12:31 AM, Jayaraj JR wrote:
Hello,

The recent developments discussed about Report Generation is very
interesting and useful. Special Thanks and Congrats to Chauncey
Montgomery !.

We have a requirement to generate a report which can display the
values contained in the sub fields and tags.ie <http://tags.ie>

Instead of displaying 650 a, we require the value entered in the field
650 a.

and 911 a b c. What modification need to be done below for such a report.

Filters:
Item :: Shelving Location - Location ID Item :: Call Number/Volume -
Owning Library Item :: Call Number/Volume - Is Deleted Item -> Call
Number/Volume -> Bibliographic Record :: Flattened MARC Fields - Tag
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Subfield

Display:
Item -> Call Number/Volume -> Bibliographic Record :: Simple Record
Extracts - Title Proper (normalized) Item -> Call Number/Volume ->
Bibliographic Record :: Flattened MARC Fields - Tag Item -> Call
Number/Volume -> Bibliographic Record :: Flattened MARC Fields -
Subfield


--
Jayaraj J R
Central Library
IISER Thiruvananthapuram
<goog_1668144428>
http://www.iisertvm.ac.in

Reply via email to