RSV-VAL-0032 expression is not valid. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '0'.

Problem:
RSV-VAL-0032 The following expression is not valid: [AdjRowsReturned] = 0. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '0'. The variable named '[AdjRowsReturned]' is invalid

Resolution:
You might have used the calculated data item in the variable, which needs to be added in the page properties.
- Click on the page and go to properties. Make sure you see 'page' on the top of the properties.
- Click on properties icon under data section, you'll get pop up icon
- Check mark the data item which is used for variable calc.

You are good to go.Find the snapshot.



.

Comments

  1. RaviJune 11, 2013 at 9:35 AM

    Hi,
    I have a query say Xyz under which I created a data item named TotalCount which simply have count([Policy Name]).
    It counts the policy returned by the query.

    I display it on page and could see the accurate count.

    Now I create a boolean variable named IsPolicyFound and in its expression I select the TotalPolicies from Xyz Query. So it looks like

    ([Xyz].[TotalPolicies]>0)

    Now I added TotalPolicies data item to Page Properties with Query Xyz

    After this when I run my report, I could only see the count coming to 1 even though if I have 4 policies displayed on the page.

    I am using cognos 10.2 version.

    Any hint please let me know.

    ReplyDelete

Post a Comment

Popular posts from this blog

How can you extract all user information from Cognos Access Manager Namespace Report Utility and create Cognos Report out of it?

The AM_NamespaceReport Utility allows you to extract the namespace to an XML file. 1. Use the AM_NamespaceReport Utility to extract all users from the namespace to an XML file. am_namespacereport -h > -p > -r > -n > -D > -w > -f all -o > e.g am_namespacereport -h cognoscamsevr -p 4004 -r o=cognos.com –n devcam -D admin -w admin -f all -o c:\temp\usrlst.xml 2. This will extract all user information to an XML file 3. Import the xml file into XLS spread sheet 4. Create ODBC connection using the ms-excel spread sheet driver 5. Create Data Source Connection and proceed creating FM Model & Publish 6. Create Report using Report Studio. 7. Save & Share the report The Access Manager Administration Guide (Appendix A) contains further information on this functionality.
Read more

Cognos 10 Active Report - Swipe Gesture

In order to create a user experience that takes advantage of standard touch interface interactions, the swiping gesture can be implemented on Decks or Data Decks. This functionality is complemented by the Iterator control, which can be configured to appear as page dots to indicate the current selection. The following high-level procedure can be followed to enable swiping and obtain the corresponding page indicator dot look and feel for the Iterator control: •    Ensure that the Iterator and the Deck are driven by the same values •    Create a variable to be used to control the selection •    Configure the Interactive Behaviour of both the Iterator and the Deck so that each control sets (Set Variable Values) and is selected by (Container Select) the same variable •    Enable the desired Slide Animation Direction effect on the Deck •    For the Iterator control, ensure that the Iterator First, Iterator Previous, ...
Read more