Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
please help me out.
I have a problem at my dashboard(submitted business), a list box named Agent code at top left corner is not connecting with all sheet objects.
Please identify what am I doing wrong at script.
Attached is the screen shots.
Below is table script :
[connection string]
LAAG_AGENT:
LOAD
"AAG_AGCODE" as AgentCode,
"AAG_NAME" as AgentName,
"PCL_LOCATCODE" as Branch,
"AAG_AGCODE";
SQL SELECT AAG_AGCODE,
AAG_NAME,PCL_LOCATCODE,AAG_AGCODE
FROM "FQADRI"."LAAG_AGENT";
PCL_COMPLOCATION:
LOAD
"PCL_LOCATCODE" as Branch,
"PCL_LOCATDESC",
"PCL_BRANCHACTIVE";
SQL SELECT PCL_LOCATCODE,
PCL_LOCATDESC,
PCL_BRANCHACTIVE FROM
"ASIF_IQBAL"."PCL_COMPLOCATION";
LMMI_MIS_FINAL:
LOAD
ISSUED,
SUBMITTED,
"POLICYNO",
"MMI_TRANTYPE",
"PRODUCT",
"AAG_AGCODE" AS AgentCode,
"AGENT_NAME",
"SC_CODE",
"SC_NAME",
"EBDM_CODE",
"EBDM_NAME",
"UM_CODE",
"UM_NAME",
"ABM_CODE",
"ABM_NAME",
"BM_CODE",
"BM_NAME",
"SBM_CODE",
"SBM_NAME",
"GM_CODE",
"GM_NAME",
"RM_CODE",
"RM_NAME",
"SD_CODE",
"SD_NAME",
"TILL_DATE" as Date;
SQL SELECT *
FROM "ASIF_IQBAL"."LMMI_MIS_FINAL";
[ connection string ]
LAAG_AGENT:
LOAD "AAG_AGCODE" as AgentCode,
"CDG_DESIGCODE";
SQL SELECT "AAG_AGCODE",
"CDG_DESIGCODE"
FROM ILASSNAP."LAAG_AGENT";
LCDG_DESIGNATION:
LOAD "CDG_DESIGCODE",
"CDG_DESCRIPTION",
"CDG_SHORT";
SQL SELECT *
FROM ILASSNAP."LCDG_DESIGNATION";
if list box is displaying in one sheet mean surely it will display in all sheet ..right click and select the select fields. see in that weather the listbox is added or not ..if its added mean it might me hidded some where in our sheet object check that
Check out in the settings>general, maybe another alternative state is assigned to this list box.