If you are unable to create a new account, please email support@bspsoftware.com

 

RQP-DEF-0375 Prompt 'Query3.0_Description_Description' has an unknown data type

Started by yengah, 19 Aug 2009 10:26:18 PM

Previous topic - Next topic

yengah

Full subject: RQP-DEF-0375 Prompt 'Query3.0_Description_Description' has an unknown data type during SQL generation.


Hello,

Just setting the context to the problem - I have 2 sources APO Applications and ATO Aliases. The ATO Aliases source contains application name aliases to some of the applications in the APO Applications source.

In one of my older "Application List" reports I created, I used one single query to list applications and their respective aliases (and other application properties too) in a list object. In this older report, I managed to successfully display the data item 'Description' (of the application).

However, I created a second report which uses 3 queries - one query to get single-valued application data items (e.g. application name and description), and another query to get the alias, which is a multi-valued application data item. The 3rd query is the resultant join of the first 2 queries mentioned just before. I created a list object which links to query 3, showing application name, description, and alias. For the alias, I used a repeater as this data item is multi-valued.

When I ran the report, I get the error: RQP-DEF-0375 Prompt 'Query3.0_Description_Description' has an unknown data type during SQL generation.

I am wondering why on the second report I get this problem with the description data item, whereas in my first report, I do not.

(The description data item has the following properties: Data type = 'Text Blob' & Prompt type = 'Generated Prompt')

I couldn't find any posts related to the above error.

Any help would be much appreciated.

Thank you.