Newbie - display query results

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

I want to display the result of a query:
SELECT EmployeeNumber, FirstName, LastName, DOB, Address FROM Employee

What control I should put onto the detail band of the report?
 
Use text boxes to display field values. Set your report's record source
property to your query.
 
I need to display the query report as master-details report, so I created a
report with master information such as
EmployeeName, Addresss, Phone

then put the sub-report onto that, this sub-report will contina the orders
that the employee created.
However, how do I make the sub-report expand itself?
 
Ah, yes, the subreport expands itself.
But how do I display the header section? I put some text in the
header-section of subreport but it did not show on the main report.
 
Page sections don't display in subreports. You can create a fake page header
by creating a new primary sorting and grouping level in the subreport and
set its Field/Expression to a constant like
=1
Display the =1 group header and set its Repeat Section property to Yes.
 
Back
Top