Hello
I am setting up a drillable report for our sales department.
The main report contains only a grouping (Total Company > Territory > Country). I store the GroupName in a Formula as you can see below
stringVar GroupNameCountry:=GroupName ({Customer.Country}) ;
GroupNameCountry
The next step: Within each group I will add several linked subreports. The subreports are linked by the GroupName. For example, if the user is at the territory level of the grouping, the subreport will be filtered (Selection Expert) with the Territory GroupName (See example below)
Total Company (Main Report Group)
- Total Invoice Value (Subreport)
- Number of inactive customer (Subreport)
Territory (Main Report Group)
- Total Invoice Value (Linked Subreport; Filtered by Group Name of Territory)
- Number of inactive customer (Linked Subreport; Filtered by Group Name of Territory)
Country (Main Report Group)
- Total Invoice Value (Linked Subreport; Filtered by Group Name of Territory and Country)
- Number of inactive customer (Linked Subreport; Filtered by Group Name of Territory and Country)
The system is working. However, the report is VERY slow! Two questions:
- Has anyone an idea how to make report faster?
- Is there a better/more elegant way to accomplish my objective?
If you need further information, please ask
Regards
Sven
IP Logged