Kindly see what's wrong with my selection formula...

[dlkraft]

I'm using the web reporting system. Works well, except,
in my two part record selection formula only one of the
parameters is being understood. I'm trying to
get:{aphist.period]='11'. I also want:{aphist.Glyear}='2000'

Only the ={aphist.Glyear}='2000' is working, the system is ignoring the column ->{aphist.period]='11'

Here's my link:

<a href=&quot;./inap_test.rpt?sf={aphist.Glyear}='2000'&amp;
{aphist.period}='11'&amp;init=actx&quot;>INAP test report</a>

Advice please!

 

[FowlerConsulting]

You can not use the '&amp;' you have to use the URL encode verion of the character. Steven Fowler, Principal
steve.fowler@fowlerconsulting.com

http://www.fowlerconsulting.com

- Development, Training, and Consulting

 

[dlkraft]

Thanks for responding! I have checked these forums at length and found that &amp; is urlencoded as %26.

But two questions arise...

1 Do I simply have to make the substitution as below, swapping the &amp; out:

<a href=&quot;./inap_test.rpt?sf={aphist.Glyear}='2000'%26
{aphist.period}='11'&amp;init=actx&quot;>INAP test report</a>

2. Or do I have to replace ALL possible characters with their urlencoded equivalents?


Thanks!

 

[FowlerConsulting]

In you example you will also have to change the = sign.
There are many URL reserved characters that you will want to change.

There are both JavaScript and VBScript functions to convert a string to urlendcoded value. Then use the result to build up your URL.



Steven Fowler, Principal
steve.fowler@fowlerconsulting.com

http://www.fowlerconsulting.com

- Development, Training, and Consulting

 

[FowlerConsulting]

If this help please give me a vote ;-) Steven Fowler, Principal
steve.fowler@fowlerconsulting.com

http://www.fowlerconsulting.com

- Development, Training, and Consulting