invalid expression

[vsudaya]

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

[sir_jeroen]

You must try Rowcount()

[vsudaya]

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

[sir_jeroen]

What kind of database? What's the processing mode? Database / Limited local?

[vsudaya]

Hi,

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

Thanks
vsud

[BIsrik]

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