If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Error

Started by Prakash Bhai, 13 Sep 2010 04:36:14 AM

Previous topic - Next topic

Prakash Bhai

Hi All,

When I validate a report I am getting this error RSV-VAL-0034 Failed to validate the variable functions. CRX-API-0016 The expression input string is empty: ""..

But the report is running fine.

MFGF

Hi,

What parameters and prompts are defined within the report?  Are any of the prompts optional, and/or have static choices which may be inappropriate?

MF.
Meep!

sflore1@springisd.org

I am trying to create a static prompt to select the campus type (i.e., high school, middle school)...then use that response to control which campuses or buildings on displayed on next prompt.  I created the static prompt on the prompt page and allowed 3 values to pick (i.e., 1 - high school, 2-middle school, 3-elementary).   Then I went to the campus prompt query and added a case statement as follows and when validating this ....i get the error on RSV-VAL-0034
case ?Campus_Type?
when 1 then ([RC General Info].[Building - MS-RC] < 25 )
when 2 then ( [RC General Info].[Building - MS-RC]  between 25 and 100 )
else ( [RC General Info].[Building - MS-RC]  > 100 )
end

Campus_Type is the name of the static Prompt....the parameter is CampusType
When user selects 1 then I want only buildings less than 100 to display on this campus prompt.


Lynn

Look up the section in the Report Studio user guide called "Create a Cascading Prompt".