Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Report Parameters
Migrateduser
<p>I am having some problems with a report parameters. I am trying to filter results based on user input. The problem I am running into is that the user input does not match a column in the SQL select statement. As an example, the column in the select statement is pulling a full heirarchy (propertybuildingfloorspace), but I am only getting input for the property. I cannot add that to the where statement because there is no property column selected. When I try to bind the dataset parameter to the report parameter, I get "Cannot set the string value (parameter) to parameter1. SQL error #1:The index 1 is out of range." I'm not sure if I am explaining this very well but any help would be most appriciated.</p>
Find more posts tagged with
Comments
There are no comments yet