By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,301 Members | 1,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,301 IT Pros & Developers. It's quick & easy.

Subreports in Columns

P: 1
I need to create a report that shows each employee with a listing of their current projects in columns according to the project status.

Example:

Employee Name...........Active........Pending.......Marketi ng.......On Hold
John Doe.....................Project 1....Project 5.......Project 2........Project 6
...................................Project 3....Project 7............................Project 8
...................................Project 9
...................................Project 10

I created a separate subreport for each column based on a query on the project's status (active, pending, etc.), but when I print the report, I only get one project per line like this:

Employee Name...........Active..........Pending......Market ing........On Hold
...................................Project 3
...................................Project 9
...................................Project 10
.................................................. ...Project 5
.................................................. ...Project 7
.................................................. .......................Project 2
.................................................. ............................................Projec t 6
.................................................. ............................................Projec t 8

I've played with the subreports to make sure the fields don't overlap, but nothing has an effect. Any suggestions?
Oct 26 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi

If your information is in the rows of a query, you simply can create a Crosstab query uing the column Project Status..

:)
Oct 27 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.