Posted 6 April 2022, 2:22 am EST
I’m new with ActiveReports. I have the following javascript:
{
“name”: “Other_Organization_Managers_PDF”,
“excelReport”: “Other_Organization_Managers_EXCEL”,
“title”: “Organization Managers”,
“connectionStringName” : “ReportsConnection”,
“directions” : “Please select a Domain OR Organization. You can change the organization to any organization. If you select the check box to include sub-organizations the report will include all child organizations information as well.”,“parameters”: [
{ “name”: “domain”,
“directions”: “Please select a Domain:”,
“type”: “Dropdown”,
“required”: false,
“query” : “SELECT DOMAIN_ID, DOMAIN_NAME, DOMAIN_ABBREVIATION FROM dbo.DOMAIN”,
“text” : “DOMAIN_NAME”,
“value” : “DOMAIN_ID DOMAIN_NAME ‘-’ DOMAIN_ABBREVIATION” },
{
“name”: “Orgs”,
“directions”: “Select an Organization:”,
“type”: “Search”,
“required”: false,
“query” : “SELECT O.NAME AS ORG_NAME, O.ID AS ORG_ID, O.STATE, O.COUNTRY FROM DBO.ORGANIZATIONS O WHERE O.ACCOUNT_STATUS = ‘E’, O.DOMAIN_ID”,
“default” : [{ “dataType” : “SQL”,
“query” : “SELECT O.NAME AS ORG_NAME, O.ID AS ORG_ID, O.STATE, O.COUNTRY FROM DBO.USERS U JOIN DBO.ORGANIZATIONS O ON U.ORGID = O.ID WHERE U.ID = @CURRENT_USER_ID”}],
“columns” : [ {“text” : “Organization”, “value” : “ORG_NAME” },
{“text” : “State”, “value” : “STATE” },
{“text” : “Country”, “value” : “COUNTRY” }],
“parameters” : [ {“text” : “Search Text”, “value” : “ORG_NAME”} ],
“pageSize” : 10,
“selectLimit” : 1,
“maxResults” : 500,
“value” : “ORG_ID”
},
{
“name”: “Level”,
“directions”: “Include Sub-Organizations?”,
“type”: “MultiSelect”,
“orientation” : “HORIZONTAL”,
“values”: [{“text” : “”,
“value” :{“checked”: 9, “unchecked”: 1}}],
I want to enforce the either or selection of Domain or Organization. How can I do that here? Thank you. We’re using ActiveReports 14 and a SQL Server DB is the backend.
