Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: vsudaya on 18 Nov 2005 08:17:24 AM

Title: invalid expression
Post by: vsudaya on 18 Nov 2005 08:17:24 AM
Hi all,

I am gettingÃ,  RSV-RND-0051 invlalid expression error whenever i validate the report in report studio. my report is running without any errors.

I created a data item with expression of Count(ROWS) on the particular query I want to work with.

I Created a boolean variable to determine whether to hide the list or not called 'DisplayMainList'.
When it's 'Yes' I want to hide the list and show the message "No Data exists - Choose different parameters". When it's 'No', I keep it normally showing the list.


Thanks and Advance
vsud
Title: Re: invalid expression
Post by: sir_jeroen on 18 Nov 2005 08:19:41 AM
You must try Rowcount()
Title: Re: invalid expression
Post by: vsudaya on 18 Nov 2005 08:26:40 AM
Hi,

I used Rowcount, but its giving foowing error

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-228'. UDA-SQL-0219 The function "Rowcount" is not available as an external, database, or built-in function.

Thanks
vsud
Title: Re: invalid expression
Post by: sir_jeroen on 18 Nov 2005 12:40:42 PM
What kind of database? What's the processing mode? Database / Limited local?
Title: Re: invalid expression
Post by: vsudaya on 21 Nov 2005 12:21:24 AM
Hi,

The database is Oracle 9i, and processing mode set to Limited Local

Thanks
vsud
Title: Re: invalid expression
Post by: BIsrik on 22 Nov 2005 08:43:30 AM
if ur intentions to show some text when there is no data u can use this expression in layout calc and place it in list footer:

if( rownumber() is null) then( text) else('')

If u want to go by ur way...instead of saying count(rows) give the expression as count(query column). it will work then...

Srik

Text only | Text with Images