I am using that extracted date, subtracting from current date and displaying it, in years, for how long a person has been in that core section continuously.
Ok, here's my problem... using crystal reports 11 and trying to extract the earliest "start" date based on part of the "section" but only certain ones:
eg. section: start date:
abc-def-ghi-jk 12 jan 2011
abc-def-ghi-lm-no 15 oct 2010...
Having trouble figuring this one out! Here's what the table looks like:
field1 field2 field3 field4 field5
A 1 99 X X
A 10 99 X X
A 3 99 X X
B 1 99 X X
C 4 99 X X...
ok i'll try to explain it a little better. Each of the four subreports pulls a "completed" date from the same access database table based on 4 separate courses (also in same table). The subreports then calculate a course expiry date based on a validity period and display that date - and this...
Currently the subreport (4 of them actually) is in the details line of the main report. This seems to make generation of the report very slow, which is why i was hoping to share instead. Each subreport is generating an expiry date based on courses people take. If there is no way of sharing, is...
I'm using crystal reports XI and am trying to share a date formula (@expiry) in the subreport, with the main report. Being a new user, can someone please tell me what the formulas would be and where to place them in the reports? Thanks in advance.
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.