Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crosstab can grow

Status
Not open for further replies.

IT4EVR

Programmer
Feb 15, 2006
462
US
For some reason the Can Grow property is disabled on all the column and row fields in my crosstab report. Is there a way to make a particular field expand if necessary.

Also, is there a way to format a particular column field? Because in the designer there is only one placeholder for the column field, all column fields get same width, font, etc.

Thanks...
 
All you can do is drag the boundaries of the summaries or labels to make the column wider--no conditional widths are possible.

Yes, you can format individual cells or columns/rows, but you need to be more specific about your needs.

-LB
 
In one of the columns I have text that could span 1 or more lines. I don't want to have all rows default to 5 lines of text to account for the possibility that some rows will have that much text. I just want it to grow if there is more than one line.
 
Not possible, as mentioned earlier. You could however conditionally reduce the font by using a conditional formula in the format field->font->size->x+2 and entering something like:

if len(currentfieldvalue) > 20 then 6 else 10

-LB
 
Thanks for getting back to me. That may or may not work for me. Can you programmatically increase the row height ?

Also, I have a column field where I have specified the order that the columns will display in the crosstab. Is there a way to specify certain width of individual columns?
 
PS. If these are labels, you could consider rotating them 90 degrees so that you can manually narrow the columns.

-LB
 
That being the case, I'm probably going to have to setup the data in a crosstab type format BEFORE I load it into Crystal/
 
Ok, I was able to stage the data on the server so that it displays in crosstab-like fashion BEFORE I send it to Crystal Reports.

Now this should be an easy one but I want to apply borders around cells whether they are null/empty string or not or whether they have data or not. Right now it only applies borders to cells with data.

Would I use the Highlighting Expert?
 
If a cell is null, it isn't there--therefore no borders or other formatting can be applied. You could instead add a text box or insert boxes/lines.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top