Skip to Content
0
Former Member
Sep 29, 2011 at 11:26 AM

OpenDocument Datatype error

14 Views

Hi,

I'm trying to use OpenDocument syntax to generate a report and save as pdf file but facing an error.

The error is about prompt syntax, in Web Intelligence when prompts shows up, users can select Product via selecting product names like, Coffee, Soda but generated SQLs like below. SQL Calls product names with their IDs.

Where (

Product IN (8,3)

)

The problem starts here when I generate following URL for opening document and save it;

http://<server>:<port>/OpenDocument/opendoc/openDocument.jsp?iDocID=<CUID>&sIDType=CUID&lsSEnter+Product=Coffee&sRefresh=Y&sOutputFormat=P

It throws "failed to convert varchar "Coffee" datatype to int.."

Is there any way to avoid that error ?

Is there a workaround without removing numeric indexes ?

Thanks and Regards

David