Hello,
I am reporting user accounts based on various filters, exporting that to CSV for further processing. Everything works fine, but I am interested in adding some extra columns (that are not collected from AD) but can be defined by formula. I can do it later in Excel from CSV, but that is extra work that I would like to have done directly by Enterprise Reporter.
Is something like that possible?
Thanks.
It depends on the type of calculation you want to do.
If you edit a report in the Report Manager and right click on a field that is already added to the report, you can change the field from just showing…
Thanks a lot, SQL query direct modification worked for me.
This is the example of what I added into SELECT clause: IIF([tblDomainUser].[LastLogonTimestamp] > 1, 'logged on', 'never logged on') AS EverL…
