DVD Register Forum

laborde

Moderator

Registered: 2013-08-25

Posts: 20

Can this report be created.

I flag all the discs I have watched with a Viewed = Yes value.

What I would like to do is to create a report of all the discs in my collection that are movie discs and that I have not watched. I don't just want a count of them but a list and I don't want to see any discs that are not movie discs and/or have been viewed.

I have not been able to figure out how to do this. It would be easy with something like SQL but there doesn't seem to be a way to do this kind of report in 2.0. Any ideas on how to do this?

modorlofsky

Moderator

Registered: 2013-08-23

Posts: 275

Re: Can this report be created.

Mike,

Here is the procedure to make the desired report (In DVDR2.0):

Use (Settings>Sort & Filter) to set a filter on Movies and the Custom Field you use to indicate whether you have watched the disc. The filter has the effect in SQL of ['Program Classification' = 'Movie' and 'Custom Field 1' = "yes"].  Not that this is a logical AND. See example filter screen below.

Next use the Combo Custom report (My Catalog>Reports>Design Custom>Combo List) that combines discs and movie data into a list report. You can make adjustments to include the attributes you want to see in the report. See the report design below.

Tom Orlofsky

Last edited by modorlofsky (2015-07-05 18:57:01)

laborde

Moderator

Registered: 2013-08-25

Posts: 20

Re: Can this report be created.

Two things I still don't understand. My User Defined 1 would have the value blank since I only fill in a value for the field for Watched. Unless there would be some easy way to go through and add No to all the blank values, I don't see how a value of blank or empty can be specified. Secondly, how do I point User Defined 1 to the specific database field I have in mind?