Parameters not exporting 1

[ianholmes]

I have written an SP, with a variable described as
(@Ident nvarchar(100))

In Crystal Reports XI,
I have @Ident defined in Parameter Fields
Type string
Static
Allow custom values True
Allow multiple values False
Allow discrete values True

When I run the report on my PC, it works great :
I enter different parameters,
& the correct data comes back no problem.

However, when I port it over into a .net application,
& select the report,
it only works with the last entered parameter
from my PC session.

Any other parameter value gives a log in error.
It is as if this last value has been hard-coded
into the RPT file !

I have unselected File > Report Options >
Save Data with Report,
but it makes no difference.

It sounds like a Global Setting within my Crystal Reports environment, but I cannot see anything obvious.

Can anyone help please ?

 

[campia]

Is your report connected to the correct db or to the temporary db??That could be a reason...

andré

 

[ianholmes]

In fact, we need to SET TO NULL at the parameter prompt, before saving the RPT.