Showing a username in the footer

Let's examine two more session parameters which are very useful in real-life reports. Reports are often printed and handed over to other members/teams to have a look at. For a person who is looking at a printed report, the most important thing is to know the time when the report was run. That is why we usually put the timestamp in the report footer.

However, it is also useful to record who ran the report. This helps us to go back to the person in case of any queries. This recipe shows you how to display the user's name and the machine on which the report was run in the footer.

Getting ready

Pick up any of the existing reports.

How to do it...

In this recipe we will use a macro to show the user's username in the report footer, as follows:

1. Go to Query Explorer and create a new query subject called User.

2. In that query subject, add a new data item. Call it Machine and define it as:

   #sq($machine)#

3. Then, add another data item and call it User. Define it as:

   #sq($account...