Search:

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.

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...

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}),...

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...

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)?

This works:
datevalue(Month({View_EMPData.HIRE})) = DateValue(Month({?Date }))

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),...

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...

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

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...

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...

Ok, Change in situation:
RH
PHa
PHb
GHA
GHB
DetailsA
DetailsB
DetailsC
GFA

Anyone ever create a vendor on-time delivery report in Mas 500? Looking for a mentor.

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...

This line:
ADDRESS.ADDRESS_ID = INDIVIDUALADDRESS.ADDRESS_ID

and this line:
and CAST(SUBSTRING(KEY_REPRESENTATION, charindex('=',KEY_REPRESENTATION)+1, LEN (KEY_REPRESENTATION) -...

Got the blank page fixed.

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...

Thanks. I will try it and get back to you.

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...

Can you make a container to pass a whole line of information to the main that consists of several fields?

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...

Ok to close found that this acceptable tolerance on the report.

Thank you.

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...