I am trying to convert reports from 7.6.8 to 7.7.03. The last report I need to convert prompts the user for selection criteria.

The datasource is SQL. The report displays multiple fields; one of which is varchar(max) in SQL. The focus master file desciption is USAGE=TX50, ACTUAL=TX.

In 7.7.03 - depending on the size of result set of the selection criteria my pdf will open. However, the text field never prints on the report.

In 7.6.8 - regardless of the size of the result set, the pdf opens. The entire text field is displayed, regardless of length.

Thank you in advance for your assistance.

This message has been edited. Last edited by: Deana,

This really seems to be an issue with that particular version of webfocus.
What I'd do is register a call with IB tech support to see if this is already a known problem and/or can be remedied.

The solution was to change the definition from TX50 to AnV where n is the max size of the field. I believe the max is 4098. Thank you.

After running into other fields which contained data with more characters than the max for AnV fields, I did more research.

I added 'ENGINE SQLMSS SET CONVERSION LONGCHAR TEXT' to the edasprof.prf. This appears to have fixed my problem, allowing me to use USAGE=TX50, ACTUAL=TX for the sql varchar(max) fields.