My main report contains DisrepNum and various fields relating to that discrepancy report.
I want to create a subreport using a table that contains the DisrepNum and a FollowUpDate field. After linking the DisrepNum field, I will hide it in the subreport. The problem is that I cannot figure out how to display the FollowUpDate values horizontally.
In other words, if I follow up on a particular report seven different times, I want to see those seven dates listed horizontally below the line containing the report information. Crosstab queries and Columns don't seem to do this for me.
I want to create a subreport using a table that contains the DisrepNum and a FollowUpDate field. After linking the DisrepNum field, I will hide it in the subreport. The problem is that I cannot figure out how to display the FollowUpDate values horizontally.
In other words, if I follow up on a particular report seven different times, I want to see those seven dates listed horizontally below the line containing the report information. Crosstab queries and Columns don't seem to do this for me.