In this document, I want to illustrate how to have a better reading of a report containing a large list of people, customers, products, or anything that need to be listed.
To facilitate the reading, we create sections but that’s not enough we also want to manage the number of items in each section.
In the document I will show you how to manage a long list of customers sorted in alphabetical order.
The idea is to create a section by letter (or left part of the customer name) and to dynamically change the length to reduce the size of the section.
In addition, we can also easily swap the first name and the last name to have a better visibility of the customers list.
As we want to display customers by the first name or the last name, we need to create a variable named “Full name type” and create an input control to manage the content of this variable.
We create an input control with the following properties:
Now we create the “Full name” variable using the value of “Full name type” variable. Here is the formula:
=If [Full name type] = "First Name + " " + Last Name" Then [First name] + [Last Name] Else [Last Name] + " " + [First name]
Now we create the “Length” variable that is a measure with a numeric value, formula: =1.
This variable is managed by an input control with the following parameters:
We create the variable “Initial” that will be used in the section to filter the table containing the list of customer.
This variable is using the “Full name” variable” and the “Length” variable. The formula is:
=Left([Full Name];[Length])
We can then create the report that contains a table with “Full name” and all other dimensions, attributes or measures that are necessary to display the list of customer.
We create a section based on “Initial variable”.
The report will look like this:
Now we can play with the 2 following input controls to change the report content.
In conclusion, this is an easy way to filter a large list of items and also to swap components of a given item
You can download the Web Intelligence report attached to that publication.
Didier MAZOUE
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
54 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |