URL Parameters

[ssudha]

How to pass negative values as parameters in URL reporting of Crystal Enterprise 8.0?

 

[Naith]

You can ToText your values in your URL to pass negative values.

 

[ssudha]

Thanks for the reply.
If i am passing a negative value with help of ToText function the negative value is getting truncated to 0 instead i want it to be same negative value.
Ex: I am calling a report that uses a stored procedure with amount as a parameter.Its datatype is number. Negative values can also be passed here. Your solution worked but the ToText made my negative parameter as 0. Please help !

 

[Naith]

Can you verify that the format of your ToText is like (ToText{Field}) with no other formatting?

Also, can you see if the URL is being populated with 0 as well, or is it retaining the negative value?

Thanks,

Naith

 

[ssudha]

Hi Naith,
I have verified as you said. The URL is sent as:

http://172.16.14.29/Col/overandperi...me(2003,4,7,00,00,00)"&promptOnRefresh=0

The above URL is generated from a JSP page that will request the required report based on the selected user values. The form will contain a text field to enter the amount. The user can enter -ve values also. ToText didnot give any syntax errors but the amount is read as 0 at the Report. The report is published in CE 8.0 standard. I am using CR8.5 Developer to design the reports.

Thanks in advance,

Sudha

 

[Naith]

I can see the value is populating the URL appropriately. If you cut this URL out, and paste it into a new browser window so that it directly calls the report, do you have the same or different behaviour?

If the behaviour is the same, in the URL address window, delete "ToText(-10000)" and replace it with "-10000" with and without quotes. Press enter and report the [in]consistency.

If all variations return zero values, execute the SQL with the -10000 value directly on the database - skipping Crystal entirely. Do you get negative values or zeroes now?

Naith

 

[ssudha]

Thanks Naith,
It worked with "-10000". I converted the previously int datatype on amount to String now in the JSP page and generated the URL leaving the number datatype in the stored procedure as is. The report is working fine now. Once again thanks for the patience. Your idea really worked.

Regards,

Sudha