Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Report To fill down Post Reply Post New Topic
Author Message
Bonzol
Newbie
Newbie


Joined: 19 Jul 2007
Location: Australia
Online Status: Offline
Posts: 1
Quote Bonzol Replybullet Topic: Report To fill down
    Posted: 19 Jul 2007 at 7:22pm
Hello!

I have a report that is supposed to show all projects that all staff members are related to on each page. for example

Page1:
Bill

Proj Name       hours Worked
Project 1       20
Project 2       2
Project 3       400

Page2:
Fred

Proj Name       hours Worked
Project 5       44
Project 7       4
Project 1       54

My SQL query as follows

Select Projects.ID, Projects.Name, ProjStaff.Hours, Staff.Fname, Staff.Lname from (Projects INNER JOIN ProjStaff on Projects.ID = ProjStaff.ProjID) INNER JOIN Staff on Staff.ID = ProjStaff.StaffID

returns a row for each project that a staff member has worked in as well as the staff name in the same row. I have attempted to do this, however only one project ever shows up at one time.
So can someone please tell me how I actualy display the information in this manner? If you require more information don't hesititate to ask.

Thanks in advance,
Chris.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 19 Jul 2007 at 9:21pm
You should be grouping on the Staff.ID field. Are you doing that?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.