Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Layouts and Reports Page: 1  Previous   Next
Report with a list of DVD's that someone borrowed
Author Message
DVD Profiler Unlimited Registrantnicovoet
Registered: May 27, 2007
Belgium Posts: 58
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Hi,

I'm trying to make a report with the name of the person who loaned the dvd's and the list of DVD's he borrowed with the date he has to return it.

I have been trying different ways but every time each dvd is shown on a different page.
I would like to have it on the same page.
For example:

Name of the Person

Date of today

DVD 1                          Number of dvd 1          date when the dvd has to return
DVD 2                          Number of dvd 2          date when dvd 2 has to return
etc.

I have been trying but I can't seem to find a sollution.
Is this possible and if so can someone please help me make such a Report.

Thank You,

Nico Voet
DVD Profiler Unlimited RegistrantStar Contributorgreyghost
Registered: March 13, 2007
Reputation: Superior Rating
United States Posts: 883
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
There is a report available for download named Title Listing loaned to (v 1.2).
Sort the reports by title and go to page 96. If not exactly what you want, at least a starting point.
 Last edited: by greyghost
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 332
Posted:
PM this userDirect link to this postReply with quote
Quoting nicovoet:
Quote:
I have been trying different ways but every time each dvd is shown on a different page.
I would like to have it on the same page.

DVD Profiler's function is by title. It is not a database that allows you to sort by any field. Sure, you can filter by a lot of stuff, but you are still presented the information only by title.

Therefore you will only see a particular user's name when it next appears with a title. There might be 10 titles between th first time the name appears, and the next.

There is no way I know of to get around that. If you can get the output of the report into a text file that you can import into Excel, then you can sort the list there by the user's name.

In other words, you want a MySQL database of all your discs.  I'm not sure you want to try and build such a database just to be able to do this.

It would be nice to be proven wrong.

UPDATE: I've just noticed that a CSV plugin exists, so you can create a simple report and export it to a CSV file an import it into Excel for further sorting.
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
 Last edited: by MrVideo
DVD Profiler Unlimited RegistrantGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 2,717
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
ProfilerQuery can help you get at least part of the way. It can give you something like this:

You can sort it by "Loaned to" in order to see who has loaned what.
PeofilerQuery doesn't have a print option, but "File -> Save and run" will open the result in your default spreadsheet program and you can use that to further enhance and print your list.
My software
Gunnar
    Invelos Forums->DVD Profiler: Layouts and Reports Page: 1  Previous   Next