CR Report - OpenDocument prompt-ex and NULL values

building reports crystal reports
1

Dear ALL,
I’m using Opendocument in order to open a Crystal report. The repor has a multiple prompt where I can set NULL in the prompts parameter.
How I can specify null values on Opendocument string ?

This string doesn’t works fine :
http://SERVER_NAME:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AbpSeIvDGNpHnMKvC7YaJp4&promptex-[ZSD_DEMPL_MF_CID]=NULL

Also this string doesn't works fine :

http://SERVER_NAME:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AbpSeIvDGNpHnMKvC7YaJp4&promptex-[ZSD_DEMPL_MF_CID]=ALL

Also this one doesn't work(as specifed on this PDF http://trustedbi.com/files/xi3-1_url_reporting_opendocument_en.pdf - Pag. 30) :

http://SERVER_NAME:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AbpSeIvDGNpHnMKvC7YaJp4&promptex-[ZSD_DEMPL_MF_CID]=

The Crystal report is based on BEX query and the prompts are applied on the BEX Query and not onto Crystal report

Any Idea?

Best Regards,
ZAV
:wave: :wave: :wave:

zavatta_fighter (BOB member since 2005-05-10)

2

It should be like below:

/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&sType=rpt&iDocID=Fh7QV1ZkzgUAXTIAAECZpXUDAAwpEYRi&lsSDateRange=REL_M&lsSReportName=ESS&lsSFrom%20Date=no_value&lsSTo%20Date=no_value&lsSPARA=no_value

vijesh.chandra :india: (BOB member since 2009-05-29)

3

Dear vijesh.chandra,
It doesn’t work fine, probably your example report a list of BO prompt… In my example I have the prompts applied on query Bex as you can see on my string —> &promptex-[ZSD_DEMPL_MF_CID]=NULL

Any other idea ?

Best Regards,
ZAV
:wave: :wave: :wave:

zavatta_fighter (BOB member since 2005-05-10)