Microsoft KB Archive/914823

= Microsoft Speech Server basic reports may report &quot;No data&quot; for some items when the items are hosted on a Report Server in SQL Server 2005 Reporting Services =

Article ID: 914823

Article Last Modified on 5/5/2006

-

APPLIES TO


 * Microsoft Speech Server 2004 R2 Standard Edition
 * Microsoft Speech Server 2004 R2 Enterprise Edition

-





SYMPTOMS
Microsoft Speech Server 2004 R2 basic reports may report &quot;No data&quot; for some items when the following conditions are true:
 * The items are hosted on a Report Server in Microsoft SQL Server 2005 Reporting Services.
 * Certain parameters have a value of &quot;%&quot;. These parameters include the Language, TaskName, and QAName parameters.



CAUSE
This problem occurs because the SQL code that is used to perform the language filtering query treats the filtering query differently in SQL Server 2005 Reporting Services than it does in SQL Server 2000 Reporting Services. The default value for many parameters is &quot;%&quot; because the value enables the broadest reporting on the call data in the database.



RESOLUTION
To resolve this problem, you must modify the SQL queries that perform the parameter filtering. To do this, you must perform a global find and replace operation on the text in the .rdl files. You can use the Report Designer or any text editor to replace this text. Follow these steps:   In all reports except the &quot;Dialog Overview&quot;, &quot;Prompts&quot;, and &quot;Turn Analysis&quot; reports, replace the following text.

Original text ISNULL(NULLIF(@Language, '%') New text  ISNULL(CAST (NULLIF(@Language, '%') AS NVARCHAR(20))   In the &quot;Turn Analysis&quot; report (TurnAnalysis.rdl), replace the following text.

Original text ISNULL(NULLIF (@QAName, '%') New text  ISNULL(CAST (NULLIF(@QAName, '%') AS NVARCHAR(64))   In step 1, you replaced text in the &quot;Tasks&quot; report (Tasks.rdl) and the &quot;Errors&quot; report (Errors.rdl). Additionally, replace the following text in these files.

Original text ISNULL(NULLIF(@TaskName, '%') New text  ISNULL(CAST (NULLIF(@TaskName, '%') AS NVARCHAR(64)) Note You do not have to modify the &quot;Dialog Overview&quot; report (DialogOverview.rdl) or the &quot;Prompts&quot; report (Prompts.rdl). 



MORE INFORMATION
To make sure that the parameters are correctly applied to the query, you should also follow the steps that are listed in the &quot;Resolution&quot; section for any user-defined custom reports that have been derived from the basic reports.

Note The values that are specified for the NVARCHAR statements in the &quot;Resolution&quot; section reflect the likely maximum length (in characters) of certain parameters.

Step 1 modifies the Language parameters. A value of 20 should cover all applications that have multiple languages.

Steps 2 and 3 modify the QAName and TaskName parameters. The maximum expected number of characters for a QAName parameter or a TaskName parameter is 64. If your application has QA controls or task names that have names that are longer than 64 characters, you should modify the replacement value in steps 2 and 3 to equal maximum number of characters in the QA control names or in the task names.

Keywords: kbprb KB914823

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.