Report problem - Help required

[urchin556]

Hi friends,

I have a report which has 3 breakgroups ..means i have 3 repeating frames in my layout. The 3rd frame displays all the employees of the company.My problem is I want to show all the dept for the displayed employees at header level i.e. Withing first frame and those should be concatenated by ':'.
How to show that at header level.
I cannot switch the fields from one breakgroup to another And I cant do anything in my main query also.
Any help will be appreciated.

Regards,
Urchin

 

[nagornyi]

Put acrual dept_no field into the upper level group and use it for the header. In the lower level group create formula column of char type that would return the dept_no like
begin
return :dept_no;
end;
and use that formula field with the employee name.

 

[ameima]

if you already have say G_1, G_2 and employee is G_3

Make a group in between for department, the new G_3,
(WIth the wizard simply close all the levels when adding fields to each group, then a new level will be created)

Employee becomes level 4 now

Per each department (G_3) you want to show each employee:

repeating frame for department (R-3), we put in the G2 repeating frame (source = G_3) (parent = R2), then within that frame you place R_4 for employee. You can also use the wizard with the GROUP LEFT or GROUP ABOVE option

Good luck
Arjen

 

[nagornyi]

3a and 3b shoud be generated by sejparate queries, both linked to the parent query in the data model. Trying to get them by the same single query brings cartesian product of the data, so they are multiplied.