This is correct assuming the [emd_id] is numeric:
TrainerName: DLookUp("[Name]","Active Employee Query","[trn_emp2class].[trainer]=" & [emp_id])
If it's a string, this is correct:
TrainerName: DLookUp("[Name]","Active Employee...
Regarding the report layout, all pages are two-columns of even width except for the first page, as is the case for many NLs. The first page has a horizontal header and possibly a vertical 1/4 pg width TOC on the left. There are variations on this layout, but the rest of the pages are all...
I have three detail sections in my test report. The first is text. The second is a chart sub-report (charts can't go in detail sections, why I don't know). The third is text again. The chart starts immediately after section 1 as desired, but the third section writes over the chart. Is this...
Ido,
Your tip almost worked, but the section containing the sub-report the chart was overwritten. The two other sections flowed as desired. Could I trick CR into leaving room my placing a hidden field? Is there another way?
Thanks again.
I am trying to create a 'newsletter' report with a two-column page layout. The report pulls data from 25-30 different tables, displayed in charts or tables, mixed with text. The report needs to be printed as hard copy, requiring an 8 or 12 page format. We'll also be generating PDF files, and...
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.