• Report Editor Returning 1900-01-01 when field is null

    I have a report which has a column to show date field. When I execute the query in object browser, the date column shows me blank value(when no data), but while generating the report using report editor, the default value of the column shows 1/1/1900 12…

  • How to handle 500k rows of data in one Report

    I am attempting to export a report in Report Editor that contains a huge amount of data(500K rows) and would like to export the report in excel/csv.
    Version is 8.0 and the erro which I get is System.IndexOutOfRangeException: Index was outside the bounds…

  • Report in xlsx in Report Editor

    Greetings, Background: I am attempting to export a report in Report Editor that contains a datetime field and  would like to export the field in excel/csv as a date format. When the report is exported into csv, my fields displays a string and not as a datetime…

  • One Identity Manager Report Editor : custom colors on the Treemap chart

    Dear all, 

    I would like to define custom colors in the Treemap chart based on argument list (in "Series" Tab --> "Conditions" option. ex : Filed is [Argument] - Date Type is [ String] - Condition [ Containing] - Value [ArgValue]) 

  • Create a report


    I need to know how to create a report who provides me all the deactivated accounts (IsInactive=1). I was looking for in the "Report editor" but I didn't found anything similar.

    I don't know if exist any documentation that teaches…

  • Report Editor - Table Report Header Row


    I created a table report at one time and got a header row to only print on first page.

    You can define it in the properties of the cell to only print on first page.

    I'm now trying to create a new report with a table and cannot do the same for new…

  • Date range in Report Editor


    Can someone tell me how I can get a date range parameter setup in Report Editor?

    I need to get a report to only run against anything that has changed throughout the day.

    Date range would be Today's changes only.

    Thank you,


  • Do Not send a report if empty


    We have several reports that we would only want to email  if Data is present. These are daily/weekly reports would we would NOT want to send if the report is empty. I was not able to find any information relating to this in the manual but wanted…

  • Report field is not exporting as a date in Excel

    Greetings, Background: I am attempting to export a report in Report Editor that contains a datatime field and  would like to export the field in excel as a date format. When the report is exported into Excel, my fields displays a string and not as a date…

  • Filtered by Parameter in Report


    I am in the process of creating reports with various parameters such as company or Employee Type or Employee Status. I would like to display the Parameter values in the Header of the report that were selected by the user when executed.


  • Syntax for Date Range Parameter in Report Editor


    I am not able to locate the correct syntax when using a data parameter where the Range = Yes for the Report Editor. I created a date parameter for my report and set it to Range = Yes but I am receiving errors when executing it because the syntax…

  • Create Report Parameter using Table

    Hi ,

    I am new to the reporting tool and attempting to create a Report Parameter that pulls all the distinct company members from the database so the user can select the desired company name. I have created the report but when using the Data Source =…

  • Query regarding one IM reports.

    Hi Experts,


    How to check what all type default reports available in one IM and to use default reports for different purpose. I am able to see only “Identity Manager 8.0 Report Subscriptions Administration Guide”. is there any other guides for Reports…

  • How update customer logo in existing reports.

    In Q1IM version 8.0, how to update customer logo instead of existing 1IM logo and also how to update web browser title value?

  • How to View a Custom Report in Web Portal - D1IM V7

    I just created a custom attestation report for the UNSAccountB and Entitlements. Now I would like to move the Attestation report to the Web Portal so that it can be printed or available for viewing or saving  the report on the Web Portal.  Is that Possible…