[OPEN-ILS-GENERAL] Report Generation

[Chauncey Montgomery]

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-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