[OPEN-ILS-GENERAL] Reports including in-house use

[Jane Sandberg]

Mike Rylander, you are a gentleman and a scholar.  That was the trick!  Thanks!

On Wed, May 18, 2016 at 11:10 AM, Mike Rylander <mrylander at gmail.com> wrote:
> Jane,
>
> You should be able to enable nullability, start with the In-house Use
> source, and select a "parent nullable" (right join) link to items.
> Does that work for you?
>
> Regards,
>
> --
> Mike Rylander
>  | President
>  | Equinox Software, Inc. / Open Your Library
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  miker at esilibrary.com
>  | web:  http://www.esilibrary.com
>
>
> On Wed, May 18, 2016 at 12:31 PM, Jane Sandberg <sandbej at linnbenton.edu> wrote:
>> Hi colleagues,
>>
>> I am trying to create a report in the reporter that lists all items
>> and how many in-house uses they have.
>>
>> * I can use In-house Use as my initial source, but then I don't get
>> any items with 0 in-house uses.
>> * I can use Item as my initial source, but it doesn't seem to be
>> linked to the In-house use table for reporter purposes.
>>
>> I was thinking of filing a launchpad bug that a link to in-house use
>> is missing from the item source.  However, I want to make sure that I
>> am not missing something!
>>
>> Thanks!
>>
>>   -Jane
>>
>> --
>> Jane Sandberg
>> Electronic Resources Librarian
>> Linn-Benton Community College
>> sandbej at linnbenton.edu / 541-917-4655



-- 
Jane Sandberg
Electronic Resources Librarian
Linn-Benton Community College
sandbej at linnbenton.edu / 541-917-4655