Showing results for 
Search instead for 
Did you mean: 

sub report group performance issue

0 Kudos

hey I am working on report which display list of user orders , if I select company like amazon , ebay etc a list of company users must be displayed according to some criteria.

1) first a user of the selected company must be appear followed by the same user if have any orders from others companies.

To reach the above scenario I have created a group for user id and in group footer I added sub report to display order for that users ( from other companies). It is working as exacted but it takes time to load because of sub report.

is there any methods to display the user order of selected company all together first and then orders from other company for the same users rather than sub report ?

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Yes. Assuming that the parameter allows the selection of only a single company, I would create a formula to group on that looks something like this:

if {MyTable.CompanyField} = {?Company Parameter} then

Then to display the company names, you'll use this formula:

substr({@CompanyGroup}, 2, length({@CompanyGroup})-1)

There should also be a formula button in the Group Options that you can use to modify the group display - you'll use the second formula there as well to get the group tree to display the correct names.