locked
Increase string size in Crystal Reports for VS 2010 RRS feed

  • Question

  • User1945425479 posted

    Hi guys,

    I have a field in my dataset with type nvarchar(1000). when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report. How can I increase the string length to 1000? (I already checked the "Can grow" option).

    Thanks,

    Sam  

    Wednesday, September 1, 2010 2:58 PM

Answers

  • User1224194097 posted

    when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report.

    It seems like field DataType was changed in the dataset after assigning the datasource. Set DataSource location again and verify database which should refresh the field datatype and its length.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 1, 2010 6:56 PM

All replies

  • User1224194097 posted

    when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report.

    It seems like field DataType was changed in the dataset after assigning the datasource. Set DataSource location again and verify database which should refresh the field datatype and its length.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 1, 2010 6:56 PM
  • User1945425479 posted

    Did that, still not working - gives me a string of length 100. 

    Thursday, September 2, 2010 6:45 PM
  • User1945425479 posted

     

    fixed it, the problem is from the dataset, the attribute length was set to 100.

    Thursday, September 2, 2010 8:27 PM