Jump to content
edmeldc

Inforview Object Error

Recommended Posts

Hi All,

I created an object in the univ designer using this select statement:

case when @Select(Incident Detail\AcraCategory) = 'Prep-Tool' and @Select(Incident Detail\AcraStatus) = 'Resolved (ACRA)' then count(@Select(Incident Detail\Incident Number)) end

When i parse the data in the univ designer its okay, but when i add it to my report in inforview it gives me an error though all objects required is already added.

Can anyone tell me how to resolve this error. Thanks in advance.

post-7451-1401096857_thumb.png

Share this post


Link to post
Share on other sites

The error comes from MS SQL, one of the fields you have is 'ntext' in the DB and does not support the comparison operators. Create some local variables in the report (measure/dimensions) and assign the Text fields you're comparing to them, then create a new variable with the 'case' statement you're using and use that variable in the report - instead of the object you defined at the Universe level.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...