Why report columns exclude each other

[Ufoto 14]

Hello,

I am trying to create a very simple report - a table which shows the system name, last connection and logged on user. 

However every time I add the last connected column, logged on user disappears as possible selection for a new column and vice versa.

Is this some sort of limitation? Is there a way to avoid it and create such report? 

 

Thank you in advance!

[MichalJ 434]

Hello, yes, it´s a limitation of the database structure.

Do you have a set of particular useful reports, that would be relevant for being added? 

[Ufoto 14]

Hello, 

This is just something I needed at the moment because it is very useful information for a person administrating the devices. Now I suppose I will have to create two separate reports - system name/last communication, and another one system name/logged on user.

This isn't such a big issue, but it brings out another problem I have with the ESMC reporting - why scheduled reports can't be combined into a single file? For example, I am often interested in more than one set of data, but with the existing reporting, if I want to check different types of reports, the ESMC is only capable of sending them as separate attachments. So for example if I am interested in 10 different reports, I will have to review 10 attachments one by one. Isn't it possible for the ESMC to combine these reports into a single pdf file? The order of the reports in the file can be the same as configured in the task. If there is product idea forum, is this worth raising, or are the product limitations not allowing this at all?

 

[Whirley-Tech 0]

If ERA has a limit due to the database, then is your suggestion to pull multiple reports then use Excel or PowerBi to generate the report we want?

If so, couldn't we use a database connection in PowerBi or Excel Power Pivot to do this? I'm not very versed in either, but that doesn't mean I'm not willing to learn if we can better and more concise reports.