cannot use table field to filter data

[Former Member]

Hello,

            i have a problem with a table column ( sql nvarchar(1000)).

I have a report with a subreport; on the linked table i have added a new table; this table is used to create a sub report.

On a subreport i have insert a filed linked on a  column "Note" from linked table.

I see the data but if i try to ad a filter based on NOTE i can't see the column on the field data value.

What's the problem? Why i can't use the NOTE Column on filter but i can use any other table field to filter data?

Thank's

[former_member11696]

Hello,

Typically in older version of CR there was a limit to what you could use in String field and if it was allowed to be used for linking.

Do you really want to link on a string field of that length? Everything must be exact.

What version of Crystal are you using?

Don

[Former Member]

Hello, I use 8.5 version.

The column table is nvarchar(1000) but i dont use it for link with other table i want use it to filter data. for the link i use a column named batch_id.

When i add a "note" on the subreport (linking table with batch_id) i can't see the new value on the report field list.

ex. subreport field:

batch_id

descript

value

note

.....

I can see and filtering with:

batch_id

descript

value

.....

but NOT Note!!!

Thank's

[former_member11696]

Hello,

That would explain it... In CR 8.5 ( 10+ years old ) any text field longer than 256 characters was considered a Memo field and the only thing you could do with it is to put it in the report. As of CR 9 and above this was no longer a limitation.

Only option is to upgrade, there is absolutely no way to make this work in CR itself.

Thanks

Don

[Former Member]

Hello,

Thanks for your response, I understand.

Can I create a view in SQL entering the command SUBSTRING (field, 1, 255)?

[former_member11696]

Yes, As long as CR 8.5 doesn't see this as a memo field when it connects to the DB it should work.

You could try larger numbers also, I don't recall if it was limited to 256 or it may have been more. Testing will tell for sure. I have not used 8.5 in 5 years so I don't recal the specific details now.

Thanks

Don