Crystal Reports Formulas & Visual Interdev

[wf]

I'm trying to send a formula to crystal report from visual interdev like this one, but I have problems.

strUrl = "

http://lrst/scrreports/NewAgency.rpt?user0=xyz&password0=abc&sf={apellido_benef}

like 'strLastName%'"

My problem really is in the selection formula.

Any help?

 

[LV]

I think, the problem is the syntax.
If you're building your strUrl in javascript,
then it should look like this:

strUrl = "

http://lrst/scrreports/NewAgency.rpt?user0=xyz&;password0=abc&sf={apellido_benef}

like '" + strLastName + "'";

 

[wf]

Is there any way to initialize a sf in visual interdev?.

What is happening is that I have a selection formula that I passed to my report. My report runs good. But then I want to run muy report without a sf and then I get nothing when I'm supposed to get all the records in the table.

But if I run my report without the sf as the first time ir runs well.

Anyone knows what shoul I do?



PD: Thanks LV for your previous answer. It works fine.

 

[LV]

I assume that you use Crystal WCS and call your reports directly with the URL.
The alternative is to use the Report Designer Component (CRAXDRT.DLL). This way you have your report as an object and get control on it's properties (record selection formula as well).

As for calling the report without setting the SF,
try to pass something like this:

strUrl = "

http://lrst/scrreports/NewAgency.rp...bc&sf={apellido_benef}={apellido_benef}"