crosstab auto row height & suppress grand total fields

[yosteevo]

crosstab auto row height & suppress grand total fields

I am using Crystal Reports 2008.

I have a crosstab configuration that utilizes a database field that produces Long Text results.
These results can be anywhere from 10 – 1000+ character spaces in length.

I would like to figure out a way to configure a crosstab to auto-grow the row height to only the amount of space each row needs.

This will eliminate the extra dead space in my report.

I also would like to suppress the Grand Total row in this crosstab as well. It too is creating dead space.




Thank you.
Stephen

 

[Madawc]

For the first problem, create something like

Left({Long.Text}, 50)

Then use @ShortName rather than {Long.Text} for your crosstab.


Fot totals, left-click and choose Crosstab Expert. The [Customize Style] tab includes options to suppress some or all of the Grand Totals.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[yosteevo]

Thank you Madawc Williams.

I did get the suppression of the totals fields in my cross-tab to work properly.
I needed to select each row field within the cross-tab expert and manually check the additional checkbox for "Suppress Subtotal" in the (Rows section under the Customize Style Tab from within the cross-tab expert.

As far as auto height/grow function for cross-tab cell fields goes, I talked with SAP and they have had many inquiries about this missing feature.
They may add this function in future releases of Crystal Reports.
For now all I can do is post this as a needed function in the feedback section of SAP's site: (Idea Place / SAP Community Network).

https://ideaplace.brightidea.com/ct/c_es.bix

Thanks

Stephen