Search:
Type: Posts; User: PNorm
Search:
Search took 0.02 seconds; generated 5 minute(s) ago.
-
and (
{vdvReceipt.CreateDate} => {?InputDate} and Dateadd("d",+7, {?InputDate}) =< {vdvReceipt.CreateDate}
)
I have found the formula to add 7 days to get the end point of...
-
Hello,
I want to take a date and get 7 dates in the future to limit the range.
I have this coded so far:
and (
{vdvReceipt.CreateDate} => {?InputDate} and ...
-
Got this figured out.
The keys were to keep track of the lastpage and lastline. I will post a more complete explaination later.
Thank you for everyone's help.
-
April 27th, 2011, 09:44 AM
Ok, I think I have it worked out:
and {View_track.WHEN} in
(
if (Month(currentdate) * 100) + Day (currentdate) >= (Month({View_track.HIRE}) *100) + Day ({View_track.HIRE})
then...
-
April 27th, 2011, 09:27 AM
Hello, I am trying to make this work for figuring out on the when clause of the record select. When date of hire is
{View_track.WHEN} in Date(Year(Currentdate) - 1, month({View_track.HIRE}),...
-
April 25th, 2011, 02:25 PM
I found this from searching "computing correct age from birth date". I modified it so the date of hire was the birthdate. The ?CDate is the date that the user will pick to run the report as of. This...
-
April 25th, 2011, 10:02 AM
Hello, I want to use date_hire and current date to come up with the years of service.
Can I use Dateserial(CurrentDate) - dateserial(Date_hire)?
-
April 22nd, 2011, 03:25 PM
This works:
datevalue(Month({View_EMPData.HIRE})) = DateValue(Month({?Date }))
-
April 22nd, 2011, 03:23 PM
I have started this project. I have a formula started. It worked up until I tried to add in logic to get all the date hires in the current morth:
Datevalue(year(currentdate),...
-
April 22nd, 2011, 10:05 AM
Hello,
I am looking for ideas on how to best code Aniversary YTD formula in order to capture the EE's vacation accruals since their Aniversary Date: Month/Date + (CurrentYear - 1) to Date.
Thank...
-
April 22nd, 2011, 10:01 AM
Another thing to do is look up the specific error code and state number this will help in giving more information about the error:
http://www.sqlerror.de/db2_sql_error_-206_sqlstate_42703.html
-
April 22nd, 2011, 08:29 AM
The report is called from an application (Mas 500). I don't have access to the code.
I have the report working with moving Report headers to page headers then I can get it to perform write on a...
-
April 21st, 2011, 02:28 PM
Ok, This seems to be elusive. I put the Page header into a group header. Checked Repeat Group on each page for Group header. Now, I still am trying to suppress the group header in the main when the...
-
April 18th, 2011, 04:01 PM
Ok, Change in situation:
RH
PHa
PHb
GHA
GHB
DetailsA
DetailsB
DetailsC
GFA
-
April 12th, 2011, 12:35 PM
Anyone ever create a vendor on-time delivery report in Mas 500? Looking for a mentor.
-
April 12th, 2011, 09:32 AM
Ok, I fixed the page issues. But the last page footer is disappearing on the main report. I had to put Show_header:=False in the Report_footer A before my subreport is printed.
This is the last...
-
April 12th, 2011, 09:28 AM
This line:
ADDRESS.ADDRESS_ID = INDIVIDUALADDRESS.ADDRESS_ID
and this line:
and CAST(SUBSTRING(KEY_REPRESENTATION, charindex('=',KEY_REPRESENTATION)+1, LEN (KEY_REPRESENTATION) -...
-
April 8th, 2011, 03:08 PM
Got the blank page fixed.
-
April 8th, 2011, 01:12 PM
That works pretty well. Thank you.
I do have a couple of situations:
Page footer is printing on subreport.
Also the appearance of a blank page between Main and sub.
Any advice would be...
-
April 8th, 2011, 11:25 AM
Thanks. I will try it and get back to you.
-
April 7th, 2011, 08:49 AM
Interesting....
What we want to do is:
I have a current existing report that shows all purchase order information that was ordered. Then I have created a separate report that pulls the po...
-
April 6th, 2011, 11:32 AM
Can you make a container to pass a whole line of information to the main that consists of several fields?
-
April 4th, 2011, 04:29 PM
Hello,
Anyone know of a good barcode font? I have an application that I need to generate barcodes for PO information. The mfg numbers can contain ',' that are ok. The font I have does not translate...
-
April 4th, 2011, 03:29 PM
Ok to close found that this acceptable tolerance on the report.
Thank you.
-
March 30th, 2011, 08:20 AM
Thank you for the information. I am not sure if I understand. I am only wanting to reference the total page count from when the document is rendered.
Or if there is a better way to suppress...
|
Click Here to Expand Forum to Full Width
|