Author |
Message |
| kd5 | SciFi/Fantasy/Horror Geek |
Registered: May 24, 2010 | Posts: 374 |
| Posted: | | | | I'm not so much interested in printing a 'Watched By' report (which would constantly change) as I am in just pulling up that information to view. We have an option in DVD Profiler to set 'Watched By' dates, but no way to use or report the information that we've entered. Unfortunately, I don't possess the skills to create such a report myself, nor am I skilled in the use of scripts. If a report does not yet exist to pull up information regarding the 'Watched By' dates we've entered, would someone with such skills be interested in creating one?
Thank You! -kd5- | | | Time is the fire in which we burn. (Soran) |
|
Registered: March 14, 2007 | Posts: 1,339 |
| Posted: | | | | you may want to post this in the reports forum... you'll have a better chance of getting someone to make it for you there. | | | -JoN |
|
Registered: January 1, 2009 | Reputation: | Posts: 3,087 |
| Posted: | | | | Would be the date of "last watched" enough for you? |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,217 |
| Posted: | | | | See ExampleDownload it and put it in the reports-directory I quickly changed a report for locations to show the "Last Watched" Possible problem: If more than one user "watches" in your DB, the report will show the latest date without regard which user this date is assigned to. cya, Mithi | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki | | | Last edited: by Mithi |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | I think the Database Query plugin will do exactly what you want. You can find a link in my signature. | | | Get the CSVExport and Database Query plug-ins here. Create fake parent profiles to organize your collection. |
|
| kd5 | SciFi/Fantasy/Horror Geek |
Registered: May 24, 2010 | Posts: 374 |
| Posted: | | | | Quoting ruineddaydreams: Quote: you may want to post this in the reports forum... you'll have a better chance of getting someone to make it for you there. Thanks, I posted this in the Reports forum as well, but so far I've only received responses here... -kd5- | | | Time is the fire in which we burn. (Soran) |
|
| kd5 | SciFi/Fantasy/Horror Geek |
Registered: May 24, 2010 | Posts: 374 |
| Posted: | | | | Quoting Mithi: Quote: See Example Download it and put it in the reports-directory
I quickly changed a report for locations to show the "Last Watched"
Possible problem: If more than one user "watches" in your DB, the report will show the latest date without regard which user this date is assigned to.
cya, Mithi Nice report, is there a way to sort by Date Watched to readily see newest/oldest? Thanks for your efforts! -kd5- | | | Time is the fire in which we burn. (Soran) | | | Last edited: by kd5 |
|
| kd5 | SciFi/Fantasy/Horror Geek |
Registered: May 24, 2010 | Posts: 374 |
| Posted: | | | | Quoting Mark Harrison: Quote: I think the Database Query plugin will do exactly what you want. You can find a link in my signature. Took me awhile to find the option within Database Query, but it looks like it might do what I need it to do, I'll have to look at it further. Thanks! -kd5- | | | Time is the fire in which we burn. (Soran) |
|
Registered: January 1, 2009 | Reputation: | Posts: 3,087 |
| Posted: | | | | Quoting kd5: Quote: Quoting Mithi:
Quote: See Example Download it and put it in the reports-directory
I quickly changed a report for locations to show the "Last Watched"
Possible problem: If more than one user "watches" in your DB, the report will show the latest date without regard which user this date is assigned to.
cya, Mithi
Nice report, is there a way to sort by Date Watched to readily see newest/oldest? Thanks for your efforts! -kd5- You could sort your collection after last viewed and then print the report, that's how you should be able to have it in the wanted sorting. (at making the report, choose the first option "sort as current listing") |
|