INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Crosstab can grow

Crosstab can grow

(OP)
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...

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.

-LB

RE: Crosstab can grow

(OP)
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

-LB

RE: Crosstab can grow

(OP)
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.

-LB

RE: Crosstab can grow

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

-LB

RE: Crosstab can grow

(OP)
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

(OP)
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.

-LB

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!

Resources

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