cannot change parameter

[brettemerton]

Hi,

I am quitte new in Crystal Reports and i am working with CR 2008.
Now i have the following problem.
I cannot edit a parameter field.
The field is used in a formula:
{SGNL1.FIRMSG} = 12 and right({SGNL1.REKNSG}, len({?Pm-VICNREL0.CNWBCD})) = {?Pm-VICNREL0.CNWBCD}
When i look in the sql query i can also not find the parameter field:
SELECT "SGNL1"."BTWNSG", "SGNL1"."REKNSG", "SGNL1"."FIRMSG"
FROM "S44E9808"."ACSYSND"."SGNL1" "SGNL1"
WHERE "SGNL1"."FIRMSG"=12

Can anybody help?

Greetings,

Victor

 

[Madawc]

Please clarify what you mean by "cannot edit". I assume you are using the formula in your report record selection.

Not every command in the report record selection shows up as SQL.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

The {?pm-word} is the field used for linking a subreport to a main report. You might have better luck seeing your seleciton formula pass to the SQL if you used:

{SGNL1.FIRMSG} = 12 and
{SGNL1.REKNSG} like "*"+{?Pm-VICNREL0.CNWBCD}

I didn't test this, but it seems correct.

-LB

 

[brettemerton]

Thnx for your help, indeed it had to do with a subreport link. I forgot to link both reports and that is why my report was not working. Solved now