Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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.

IT4EVR (Programmer) (OP)
13 Apr 07 15:06
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.

lbass (TechnicalUser)
13 Apr 07 15:22
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.

IT4EVR (Programmer) (OP)
13 Apr 07 15:37
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 (TechnicalUser)
13 Apr 07 15:41
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

IT4EVR (Programmer) (OP)
13 Apr 07 16:16
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 (TechnicalUser)
13 Apr 07 16:18
No and no.

lbass (TechnicalUser)
13 Apr 07 16:19
PS. If these are labels, you could consider rotating them 90 degrees so that you can manually narrow the columns.

IT4EVR (Programmer) (OP)
13 Apr 07 17:56
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 (Programmer) (OP)
14 Apr 07 14:50
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 (TechnicalUser)
14 Apr 07 15:48
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.


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!

Back To Forum

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