[OPEN-ILS-GENERAL] Report Generation

[Dan Wells]

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-bounces at list.georgialibraries.org [mailto:open-ils-general-bounces at 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