Historical Reports Gives VB List Box Error on Detailed Call Reports

From DocWiki

Revision as of 04:16, 23 June 2010 by Pshree (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Historical Report Gives VB List Box Error on Detailed Call Reports

Problem Summary On selecting Detailed Call CSQ Agent Report on a system that has more than 32765 distinct calling or

called numbers in the database, Historical Report gives VB List Box Error

Error Message The number of filter parameter values exceeded maximum entries (32765) that VB listbox can hold.

Only the first 32765 filter parameter values will be available for selection.

Possible Cause This is a limitation with VB.

The default value is 32765 as the maximum limit of the list box is 32765. If there are more than 32765 entries, the list box of the HRC shows only up to 32765 distinct values. The rest of the values are omitted.

Recommended Action The workaround is to limit the query to pull less than 32765 entries into the VB Box.

You can customize the entries of the HRC list box 'Available' such as it shows "first 'n' entries/first 32765 entries/last 32765 entries/32765 entries between 'x' and 'y'". For this, you need to modify the xml file for the report.

On the PC where the Historical Reports client is installed, navigate to <Install Dir>\Cisco UCCX Historical Reports\ReportTemplates\<language>. Open ICD_Detailed_Call_CSQ_Agent_en_us.xml (Replace en_us with local language). Locate the line <SQL>SELECT distinct callednumber FROM db_cra.dbo.contactcalldetail</SQL> Change this line to read <SQL>SELECT distinct top 32000 callednumber FROM db_cra.dbo.contactcalldetail</SQL> Locate the line <SQL>SELECT distinct originatordn FROM db_cra.dbo.contactcalldetail</SQL> Change this line to read <SQL>SELECT distinct top 32000 originatordn FROM db_cra.dbo.contactcalldetail</SQL>

You can use 'between' keyword in the SQL query to get values between two entries.


Release 7.0(1)
Associated CDETS # CSCtg06706

Rating: 0.0/5 (0 votes cast)

Personal tools