Issue with Sub-Report/Joins...not displaying properly . please Help

[PD81]

I have a table which store all the capabilities object in one table which is distinguished by Capabilities Parent table.
I have created a sub report which displays the issues related to the capabilities in each level. But When I link it to the main report it just shows
the issues for the top Level Capabilities.


In my sub report I am displaying following information.
Displaying in Group 1
Issue. Name

Displaying in Grp2
issue_1.Name

Displaying in Grp3
issue_2.name


I have added alias tables of capabilities to disguise the levels (parent/child)
The joins are as below :-

capabilities.objectid --> Attachment.startid-->Issue.objectid
capabilities.objectid --> Capabilities_Parent.parentid
Capabilities_Parent.Childid --> Capabilities_1(Alias).objecid
capabilities_1.objectid --> Attachment_1.startid-->Issue_1.objectid

and so on...for next levels
But the sub-report display only top level.i.e the group1 Issue not the other Grp2 and grp3 issues


-cheers
Puneet

 

[lbass]

What kind of joins are you using? Maybe try using left outer joins instead of equal joins and see if that helps.

-LB

 

[PD81]

Hi LB,
Thanks so much for your response. Your solution always help me I am expecting to solve this time as well.

Yes I am using Left outer join to joins the tables. there is no problem when I run the subreport seperately it gives me the correct output. I assume there is some problem how the sub-report is linked to the main report.
1) I tried linking the top level Capabilities.objectid with the top level of sub report's Capabilities.objectid
but its does show me the issues related to that top level not the 2nd and 3rd level which are in grp1 and grp2..

please help


-cheers
Puneet

 

[PD81]

any help on this is really appreciated. I have a review from the client on this reports. I need to display all the issues associated with all levels

-cheers
Puneet

 

[lbass]

Please identify the fields you are grouping on in the main report, identify the section in which the subreport is located, and the field you are linking on.

-LB

 

[PD81]

Thanks LB,
As per me everything is correct only issue (i assume)is how I have linked subreport to the main report. I sub report I have 4 level of parent childs groups I have just linked the childid of the the top level with the parentid of main report.
If you can give me ur mail id I can send you the report with data to have a look. Please let me know..I am just stuck and not progressing.
thanks

cheers
puneet

-cheers
Puneet

 

[lbass]

We have to stay in the forum. Please answer my questions, using actual field names.

-LB