I created the same report a while back. SInce I cant attach the rpt. file I will paste the SQL. Looks Messy but it works. Copy and paste this code into a new report that you create so that you can see how it works.
SELECT
"REPORTS"."V_EMPLOYEE"."FIRSTNAME" || ' ' ||...
I forgot to tell you, if you want to change the way the data formats to example from 10.00 to 1000 then in the derived field you have to use a calculation like this:
sum(distinct "REPORTS"."V_YTD_INFO"."YTDGROSS$" * 100)
I did this for my gross amount, so if an employee made 3444.23, on my...
I had to format one of my derived fileds the same way, on my field name in the report I had to add this:
DEFERRAL_AMT \L9 \PL0
the deferral_amt is the name of my field
the \L9 is the lenght of the field
the \PL0 means populate with preceding zeros left aligned.
so my data comes out like this...
Hey there,
you can try this.
In the Link the tables box, where you link the employee file#'s for both tables there is a checkbox in the bottom where you can select "Include unmatched records". Did this before and it worked, I just had to play around with it a little. Hope it helps.
RichardBott,
I had the same issue a while back and I couldnt figure out why. I too also added an extra to the form, a combobox. Anyways, reason why I wasnt getting anything was because on that combobox that I added there was a field that I was not including on my query. Query used to create that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.