Field Growing When it Shouldn't

[challer]

I recently upgraded to Crystal 8.0 from 7.0.

In a VB 6 application, I have a report defined under the designers folder. This report was created using Active Data. The VB application creates a recordset and sets the datasource of the report to the recordset, e.g. crReport.Database.SetDataSource rs.

Everything still works after I converted to crystal 8, but I have a field in the detail section with the 'Can Grow' option checked. When I view the report, the field is expanded an extra line on every record. This did not happen when the report ran under Crystal 7.0.

Any ideas why this is happening?

 

[kenhamady]

The "Can Grow" means that it will go to a second line when it needs to, based on width of object and width of the field data. V8 probably measures slightly differently than V7.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[challer]

I don't want it to grow unless it has to.

After further investigation I found that I could create a new report using the ODBC connection method rather than the Active data method. The field "Grows" as expected, only when the field needs to wrap. If I create a new report using Active data, the field grows for each record in the report.

Do you know if there is a way to make the original report print without the field growing? I don't want to have to recreate this report.

Thanks in advance,
Clay

 

[kenhamady]

>>If I create a new report using Active data, >>the field grows for each record in the >>report.

A new V8 report with Active Data wraps incorreclty? It shouldn't grow unless it needs to wrap. I am not sure why the recordset would make a difference, unless the fields are seen wider through Active Data?

Try this (a long shot, but can't hurt). Open the report in V8, Save it (in V8 format) and close it. Now re-open the report, manually resize the field smaller, let go, then manually size the field back to where it was.
Save the report again and see if this has any effect. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[challer]

Thanks for the suggestion! Unfortunately, it did not work.

Clay

 

[balves]

I am seeing the same behavior using Crystal V8 and the RDC in VB 6. It's annoying.

Could be a "feature" so that you always get the entire value of the field displayed.

You either have to widen the field or lengthen the field so that the data is totally displayed. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer

 

[kenhamady]

A new V8 report with Active Data wraps incorreclty? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[challer]

>> A new V8 report with Active Data wraps incorreclty? << Yes.

However, A new V8 report with ODBC wraps correctly!

Clay

 

[kenhamady]

The the problem may be with how the data is retrieved for the recordset. Are the field lengths specified for the recordset? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[challer]

Uuuuuh!!!

I'm creating the recordset in code. And sure enough, I was defining the field as adChar. I changed it to adVarChar and it is now working correctly!

Thanks

Clay