PayPal - la solution de paiement en ligne la plus simple et la plus sécurisée !

Report help

All about the Wine Cellar 3D program

Re: Report help

Messagepar Alexandre » 04 Mars 2016, 12:45

Yes, right click on a title (bottle) you will see "copy" then after right click and choose "past" finally press "edit" in left bar for modify date buy and path.

i have updated template, try it

also empty bottle are not show, for modify it in code remove or comment with //
Code : Tout sélectionner
  if <ActualEmpty> = 1 then
    Exit;
Pièces jointes
ideal template 2-5-16.wc3dfr3
(5.16 Mio) Téléchargé 481 fois
Alexandre
Administrateur
 
Message(s) : 173
Inscription : 06 Juin 2011, 13:57

Re: Report help

Messagepar Michael Dillon » 05 Mars 2016, 05:15

I down loaded the template and after a quick review, that is perfect. I will be down in Death Valley CA this next week, drinking wine and generally having a good time but when I get back I will update all my paths.

As I usually view each rack as I add or remove wine by filtering the search and then print a report for that individual rack. I can get all the info on one page that way. I am thinking about incorporating your newest code in the first ideal template you created.

Thanks again,

Michael
Michael Dillon
 
Message(s) : 9
Inscription : 26 Février 2016, 04:17

Re: Report help

Messagepar Alexandre » 05 Mars 2016, 11:10

You're welcome, feel free to post if you have questions.

Something like that?

Execute them for easily import them in WC3D or choose "open with WC3D" instead of saving them
Pièces jointes
ideal template 2-5-16 West.wc3dfr3
(1.74 Mio) Téléchargé 461 fois
ideal template 2-5-16 North.wc3dfr3
(1.74 Mio) Téléchargé 463 fois
ideal template 2-5-16 East.wc3dfr3
(1.74 Mio) Téléchargé 467 fois
Alexandre
Administrateur
 
Message(s) : 173
Inscription : 06 Juin 2011, 13:57

Re: Report help

Messagepar Michael Dillon » 24 Mars 2016, 23:55

Just wanted to thank you again for your help. I am back from Death Valley and have been updating my cellar. Your last templates, ideal…..North, East and West were perfect. However I ended up using your first Ideal template 2-5-16.wc3dfr3 because I had already changed about ¾ of the paths and redesigned the graphic before you loaded the last templates. If I didn’t have so many bottles, over 200, I might consider changing.
I added Total in Cellar to the page footer but I get inaccurate numbers. Is because I have two pages and have to add an other expression? I attached the North template for review.
total in cellar.PNG
total in cellar.PNG (17.57 Kio) Consulté 6636 fois
Pièces jointes
East.wc3dfr3
(144.98 Kio) Téléchargé 441 fois
Michael Dillon
 
Message(s) : 9
Inscription : 26 Février 2016, 04:17

Re: Report help

Messagepar Alexandre » 25 Mars 2016, 12:02

if i make sum of every title "in cellar" i get same number.
i have changed stetch for see all location

you want number in rack picture only that it?
Pièces jointes
East.wc3dfr3
(145 Kio) Téléchargé 432 fois
Alexandre
Administrateur
 
Message(s) : 173
Inscription : 06 Juin 2011, 13:57

Re: Report help

Messagepar Michael Dillon » 25 Mars 2016, 20:23

What I would like is, if there are two or more pages in the report, the last page would show the total of all pages.
Michael Dillon
 
Message(s) : 9
Inscription : 26 Février 2016, 04:17

Re: Report help

Messagepar Michael Dillon » 25 Mars 2016, 20:45

A problem I have encountered on the template I uploaded is, when I filter ‘rack location equals East’, two listings are missing. If I don’t use a filter they show up. I can't see anything that would interfere with the filter.

filtered.PNG
filtered.PNG (29.67 Kio) Consulté 6627 fois


31.PNG
31.PNG (13.16 Kio) Consulté 6627 fois


42.PNG
42.PNG (21.57 Kio) Consulté 6627 fois
Michael Dillon
 
Message(s) : 9
Inscription : 26 Février 2016, 04:17

Re: Report help

Messagepar Alexandre » 26 Mars 2016, 11:54

i'm sorry i don't understand what you want, showing number of bottle only on the last page?
for filter it's strange, try to remove filter then clear "rack location" on 31 then save, and put location again, apply filter is it solve problem?
Alexandre
Administrateur
 
Message(s) : 173
Inscription : 06 Juin 2011, 13:57

Re: Report help

Messagepar Michael Dillon » 26 Mars 2016, 18:42

I understand that each page will have a total. I am thinking an additional item for total sum.
Example, page 1 has 25 bottles and page 2 has 20 then the sum would be 45 at the bottom of page 2.

Also, could you explain your statement “ i have changed stretch for see all location”? where did you make that change?

The filter "reboot' worked. Thank you
Michael Dillon
 
Message(s) : 9
Inscription : 26 Février 2016, 04:17

Re: Report help

Messagepar Alexandre » 29 Mars 2016, 11:20

Stretch are for location, if you have lot of bottle they are write on multiple lines.

for number i'm affraid we cannot know how much bottles we have on each page also i see why total number are wrong, i need more time for find a clean solution.

here is a report with time showed at bottom and i have fixed some style glitch
Pièces jointes
East.wc3dfr3
(141.87 Kio) Téléchargé 340 fois
Alexandre
Administrateur
 
Message(s) : 173
Inscription : 06 Juin 2011, 13:57

PrécédentSuivant

Retour vers Wine Cellar 3D

Qui est en ligne ?

Utilisateur(s) parcourant ce forum : Aucun utilisateur inscrit et 1 invité

cron