Crosstab can grow

[IT4EVR]

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...

 

[lbass]

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

 

[IT4EVR]

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.

 

[lbass]

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

 

[IT4EVR]

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?

 

[lbass]

No and no.

-LB

 

[lbass]

PS. If these are labels, you could consider rotating them 90 degrees so that you can manually narrow the columns.

-LB

 

[IT4EVR]

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/

 

[IT4EVR]

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?

 

[lbass]

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