Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Crosstab can grow

Crosstab can grow

Crosstab can grow

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.


RE: Crosstab can grow

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.


RE: Crosstab can grow

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.

RE: Crosstab can grow

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


RE: Crosstab can grow

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?

RE: Crosstab can grow

No and no.


RE: Crosstab can grow

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


RE: Crosstab can grow

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/

RE: Crosstab can grow

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?

RE: Crosstab can grow

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.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close