sub report group performance issue

[meemz]

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 ?

[DellSC]

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:

{@CompanyGroup}
if {MyTable.CompanyField} = {?Company Parameter} then
  "*"+{MyTable.CompanyName}
else
  "z"+{MyTable.CompanyName}

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.

-Dell