Not Suppoprted

[seethu]

Hi,
Iam trying to dispay a field actiontext varchar(1000). for the first time it is displaying.the next time when i try to
display the same field with different parameter iam having a problem like NOT SUPPORTED.
For this report iam using a stored procedure in SQL server.If i execute the stored procedure with different parametres it works fine.only problem is in crystal reports

Is there any restrion in crystal report for displaying datafield with length of varchar(1000).

can any one help me out
thanks much
seethu

 

[MalcolmW]

fields longer than 254 characters are treated as memo fields, and there is very little you can do with them in CR other than print them, or suppress their printing based on another (non-memo) field/formula.
I'm not clear what you mean by "display the same field with a different parameter" though. Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[seethu]

Hi Malcom,
My result is
actiontext varchar(1000)
summary varchar(1000)
sponsor(1000)

these three fields iam displaying based on my passing parameters like 1 and 2

if 1 then iam displaying one result set
if 2 iam displaying another resultset

actiontext iam displaying in detail section.If iam trying to display for the first time either 1 or 2 its displaying.if i change the parameter next time then iam getting that crystal not supported.


thanks much
seethu

 

[MalcolmW]

in your stored proc, why don't you just
SELECT CASE WHEN @parameter = 1 THEN actiontext
WHEN @parameter = 2 THEN summary
ELSE ''
END AS TheMemoField,
sponsor
FROM etc? Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net