Report design
Report design
Hi
I'm working on a report design to fit my log book, and I've got a few things that I can't sort out.
1) Dive end time:
I would like to have a time for the end of the dive "hh:mm". I've got the start time and the dive time, but how do I add those times, so that I get my end time?
2) 2 sided printing:
I'm trying to get the layout designed to prin on both sides of the paper. I can get it to work like in an other post, by using the odd page feature. But this only works if you print a single log, I want the possibility to print several logs. I've tried to make a layer for even pages, like the one for odd pages, but alle the even pages just remain blank when I do a print preview
Also the layout is designed to fit A5 format, and the page setup is made for A4 so that I can get 2 logs on each paper.
I'm working on a report design to fit my log book, and I've got a few things that I can't sort out.
1) Dive end time:
I would like to have a time for the end of the dive "hh:mm". I've got the start time and the dive time, but how do I add those times, so that I get my end time?
2) 2 sided printing:
I'm trying to get the layout designed to prin on both sides of the paper. I can get it to work like in an other post, by using the odd page feature. But this only works if you print a single log, I want the possibility to print several logs. I've tried to make a layer for even pages, like the one for odd pages, but alle the even pages just remain blank when I do a print preview
Also the layout is designed to fit A5 format, and the page setup is made for A4 so that I can get 2 logs on each paper.
70% of our planet surface is covered by water ......
Do I need to say more ??
.... Dive! Dive! Dive!
Do I need to say more ??
.... Dive! Dive! Dive!
first
dive time end in hh:mm
maybe there is a shorter more efficient code.
Code: Select all
str$(hour(juliantodate(datetojulian(locdatetime("1 "+LogEntrytime)) + (val(str$(LogDivetime,4))/24/60))),2,0) + ":" + (if(len(atrim$(str$(minute(juliantodate(datetojulian(locdatetime(LogEntrytime)) + (val(str$(LogDivetime,4))/24/60))),1,0)))=1,"0","") + atrim$(str$(minute(juliantodate(datetojulian(locdatetime(LogEntrytime)) + (val(str$(LogDivetime,4))/24/60))),2,0)))
Thanks Erik
Actually I already solved this problem, I got a code exactly like yours, by using report template I downloaded as a guide. Maby it was yours??
Now I just need to solve the isue with 2 sided printing .... it's starting to bug the hell out of me.
Actually I already solved this problem, I got a code exactly like yours, by using report template I downloaded as a guide. Maby it was yours??
Now I just need to solve the isue with 2 sided printing .... it's starting to bug the hell out of me.
70% of our planet surface is covered by water ......
Do I need to say more ??
.... Dive! Dive! Dive!
Do I need to say more ??
.... Dive! Dive! Dive!
Hi
Now I have a new issue.
I can't print the user fields for some reason. When I use them in the layout it just comes out as a blank field when I print. I can get it to print the name field but not the value field ????
Any suggestions
Now I have a new issue.
I can't print the user fields for some reason. When I use them in the layout it just comes out as a blank field when I print. I can get it to print the name field but not the value field ????
Any suggestions
70% of our planet surface is covered by water ......
Do I need to say more ??
.... Dive! Dive! Dive!
Do I need to say more ??
.... Dive! Dive! Dive!
Hi
Make sure that you have a dive selected during the design time, which contains all the data you want to include in your report. E.g. when you open the print dialog, the dive range is from dive 1 to your last dive. The first dive of the range (in this case dive 1) will be used as example data during the design time. If this dive does not contain any user defined field data, the designer will just show a blank field. So make sure you have selected a start dive number in the print dialog which contains data in the user fields.
I just tried it and it should work (make sure you have the field LogUserDefValue01 for the content and LogUserDefName01 for the field name).
Kind regards,
Sven
Make sure that you have a dive selected during the design time, which contains all the data you want to include in your report. E.g. when you open the print dialog, the dive range is from dive 1 to your last dive. The first dive of the range (in this case dive 1) will be used as example data during the design time. If this dive does not contain any user defined field data, the designer will just show a blank field. So make sure you have selected a start dive number in the print dialog which contains data in the user fields.
I just tried it and it should work (make sure you have the field LogUserDefValue01 for the content and LogUserDefName01 for the field name).
Kind regards,
Sven
-
- Posts: 25
- Joined: Tue Apr 08, 2008 10:49
- Location: Sydney, Australia
Calculating dive exit time
this is how i have done it ... probably a bit more convoluted but i understand this way.
Take dive entry time and substitute "." for ":" then convert it to a value
convert this to decimal hours and add dive time converted to decimal hours then convert it back to HH.MM
the rest is just formatting ... always the most difficult part.
If i knew how to attach a file i have done a report file with it explained a bit better[/list]
Code: Select all
"Dive exit time = " + StrSubst$(Fstr$(Int(Int(Int(Val(StrSubst$ (LogEntrytime,":","."))) + Frac(Val(StrSubst$ (LogEntrytime,":",".")))*100/60) + Frac(Int(Val(StrSubst$ (LogEntrytime,":","."))) + Frac(Val(StrSubst$ (LogEntrytime,":",".")))*100/60) + LogDivetime/60) + ( Frac(Int(Int(Val(StrSubst$ (LogEntrytime,":","."))) + Frac(Val(StrSubst$ (LogEntrytime,":",".")))*100/60) + Frac(Int(Val(StrSubst$ (LogEntrytime,":","."))) + Frac(Val(StrSubst$ (LogEntrytime,":",".")))*100/60) + LogDivetime/60)*60)/100, "&&.&&"), ".", ":")
convert this to decimal hours and add dive time converted to decimal hours then convert it back to HH.MM
the rest is just formatting ... always the most difficult part.
If i knew how to attach a file i have done a report file with it explained a bit better[/list]
Here is the report file from bowlofpetunias: Diveexittime.zip
Is this the layout you want to produce?
This is currently not possible, because the print engine prints one dive after another. In this case it must print the first part of dive 1, then the first part of dive 2, then start a new page (back) and go back to dive 1 to print the 2nd part of it and go to dive 2 and print the rest of it.
For this case I would have to extend the print code inside of Diving Log so it sends the data of dive 1 and dive 2, and then again dive 1 and dive 2 to print the back. I'm not 100% sure, but this should be possible but some effort.
Duplex printing is only possible at the moment with one dive per page, I'm sorry.
This is currently not possible, because the print engine prints one dive after another. In this case it must print the first part of dive 1, then the first part of dive 2, then start a new page (back) and go back to dive 1 to print the 2nd part of it and go to dive 2 and print the rest of it.
For this case I would have to extend the print code inside of Diving Log so it sends the data of dive 1 and dive 2, and then again dive 1 and dive 2 to print the back. I'm not 100% sure, but this should be possible but some effort.
Duplex printing is only possible at the moment with one dive per page, I'm sorry.
-
- Posts: 19
- Joined: Thu Apr 19, 2007 09:58
This is what I wanted to do:
Two A5 prints on a single sheet of A4 paper
and then I want to have a back side in the same way as the front.
I thing the sugestion from No Waiting, is the best solution at the moment.
Two A5 prints on a single sheet of A4 paper
and then I want to have a back side in the same way as the front.
I thing the sugestion from No Waiting, is the best solution at the moment.
70% of our planet surface is covered by water ......
Do I need to say more ??
.... Dive! Dive! Dive!
Do I need to say more ??
.... Dive! Dive! Dive!