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

Template question

All about the Wine Cellar 3D program

Template question

Messagepar Mikeyd » 07 Décembre 2012, 01:21

Need help in modifying a template. I used the list template as a start. Within the master data area, I removed some field titles along with their text box names. I then put the text box, some with a different name in a row. Then the corresponding fields in a row below. I didn’t change any of the properties.
My problem is no matter how many records I select, when I print preview, only 1 record will show.
It would seem that I have removed a link somewhere but I can’t figure out where.
I have attached two pics.
Thanks in advance.
Michael
modify template.jpg
my changes to list template
modify template.jpg (112.15 Kio) Consulté 7029 fois

print output.jpg
print output.jpg (111.75 Kio) Consulté 7029 fois
result
Mikeyd
 
Message(s) : 23
Inscription : 22 Novembre 2012, 22:57

Re: Template question

Messagepar Alexandre » 07 Décembre 2012, 11:02

Hello, please attach modified report for test so i can explain what is wrong
Alexandre
Administrateur
 
Message(s) : 173
Inscription : 06 Juin 2011, 13:57

Re: Template question

Messagepar Mikeyd » 09 Décembre 2012, 03:53

After tinkering around, I adjusted the size of the Master Data box and got a lot closer to what I want. See the Current Cellar file.
What I can't figure out now is, Grid view has "name"(Winery) column in alphabetical order, but prints from the Id column in numerical order and that field is not even in the template.
Edit: OK, I fixed that by going to the settings.
My other problem relates to the "year" (Vintage) column. In modify mode, if the [Title."year"] is formatted in Date/Time strange years come up. Formatted as Text then the year shows correctly.
The print template pulls data from the "Year" table (?) If no data is entered in the "Year" database it will show as 0 in print. I was trying to somehow enter NV (non vintage) by creating an expression for [Title."year"] if <1, then NV. But that's not working.
Also wondered how to create a way to get a total number of bottles by summing all [Titles."number total"]of the report. Is that doable?
I tried to attach my current cellar.wc3dfr3 but get an error message that extension is not allowed.
Again, I appreciate your help.
Mikeyd
 
Message(s) : 23
Inscription : 22 Novembre 2012, 22:57

Re: Template question

Messagepar Alexandre » 09 Décembre 2012, 11:58

Now you can put Wine Cellar 3D files in forum. You can put them in a zip also for save space.

please, put template i will show you how to achieve your demand
Alexandre
Administrateur
 
Message(s) : 173
Inscription : 06 Juin 2011, 13:57

Re: Template question

Messagepar Mikeyd » 09 Décembre 2012, 19:18

I have attached the print template and the corresponding program file for examination.

Current Cellar - Copy.zip
the program database
(3.89 Kio) Téléchargé 569 fois

print template.zip
and the print template
(2.81 Kio) Téléchargé 561 fois


Thanks for your time.
Michael
Mikeyd
 
Message(s) : 23
Inscription : 22 Novembre 2012, 22:57

Re: Template question

Messagepar Alexandre » 10 Décembre 2012, 15:15

use "number full" instead of "number total" is better i think.

i have add what you asked:
-sum of all bottles.
-Display "unknow" if no year or date buy is specified.

modified template:
print template .wc3dfr3
(23.58 Kio) Téléchargé 472 fois


sample:
print template .1.jpg
print template .1.jpg (98.64 Kio) Consulté 7014 fois


Let me know if you have others problems
Alexandre
Administrateur
 
Message(s) : 173
Inscription : 06 Juin 2011, 13:57

Re: Template question

Messagepar Mikeyd » 11 Décembre 2012, 03:39

Absolutely perfect. I had tried using the IIF and SUM expressions. When I clicked the function in the edit box, I added what I thought would be the right terms but always got an error message.
Finally, I opened the FS Report help Program.
I put the Fast Report help file on another page and found an example similar to what I wanted and realized I was inserting commas instead of carrots. Using the example, I was able to get a sum, but the total was just for the page. Your expression is perfect.
Thank you so much for your advice.

Michael
Mikeyd
 
Message(s) : 23
Inscription : 22 Novembre 2012, 22:57


Retour vers Wine Cellar 3D

Qui est en ligne ?

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

cron