crystal report cross-tab

  • Thread starter Thread starter willemp
  • Start date Start date
W

willemp

i have the need for a bit of an complex cross-tab report.

the following information needs to be shown in 1 report.

projectname
department
hours quarter 1,2,3 and 4
and offcourse all sort of summerized fields.

i want all the projectnames listed and then for every department it has
to show the quarter 1,2,3 and 4

DEP1 DEP2 and so forward
Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
projectA 1 2 6 12 55 77 18 99
projectB 5 11 88 99 4 23 22 66

and this with the buildin crystal report designer in visual studio .Net

I hope it is clear and possible, so far i have not been able to figure
out how to get these fields out there. It keeps making too many
crosses,

Is a simular kind of report possible without cross-tab ?
 
Certainly this is possible without a cross tab, create a temp table (or a
datatable) and manually populate it, then it will be just a regular report.

I would imagine that for your crosstab report, you have a query that outputs
something close to the desired data?

i.e

Select Projects.ProjectName, Tasks.TaskName, Departments.DepartmentName,
Sum(Tasks.TaskActualHours), datepart(qq,Tasks.TaskActualCompleteDate)
From ... <complete your joins>
Group By

Now you would have data that looked like

B2BWebservice | Security | A Team | 325 | 1
B2BWebservice | Cataloge | A Team | 248 | 2
B2BWebservice | eCommerce | A Team| 19 | 3

CommercialWeb | Security | B Team | 400 | 1
CommercialWeb | Cataloge | B Team | 65 | 2
CommercialWeb | eCommerce | B Team| 110 | 3


The crosstab wizard in crystal should understand this.
 
my query did not output data as your query does, i will try it with a
simular query as yours.
 
that seems to have done the trick, thank you.

however for future reference is it possible to build a report when you
only have monthly hours and not quarter numbers, so that you have to
summerize them yourself ?
 
Back
Top