Solved

Can Grow Field and Font Size Problem

Posted on 2002-03-19
7
445 Views
Last Modified: 2013-12-03
I have a VB6 App in which I am using Designers to Produce Reports. In the Detail Section of one of the reports I am setting the Font name and Font Size of a number of Fields
dynamically. The majority of these fields are then being shown correctly (i.e) with the correct font.

My problem however is that I have one Field which has the 'Can Grow' property set to true and this field ignores any changes to the Size of the Font. Unfortunately this field has to be able to grow otherwise the report will not work.

Can anybody provide me with a work around for this problem please ?
0
Comment
Question by:SimonWillis
  • 3
  • 3
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 6879804
What code are you using to produce/print the report?

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 6879889
0
 

Author Comment

by:SimonWillis
ID: 6879969
I am using Crystal Reports V8, however the last article that you included sounds very much like the problem I am getting.

In the detail section of the report I reference the fields font property directly. ie.


Field1.Font.Size=12

this really is the crux of the problem. when I change the can grow option to false then the font size does change, otherwise nothing happens.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 6

Expert Comment

by:dbirdman
ID: 6880024
I'm not sure if this is the case with Crystal Reports, though I've used the Excel Automation objects with VB to format cells, and found that sometimes the order of the commands makes a difference.  You might try the Font Size change before and after the other command.

Good Luck.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 100 total points
ID: 6881230
I was looking for another topic and came across this article from CR.

http://support.crystaldecisions.com/library/kbase/articles/c2007181.asp

good luck
mlmcc
0
 

Author Comment

by:SimonWillis
ID: 6882154
Thanks for the info, I have used the runtime library a couple of times for proof of concept but I didn't really want to go down tha route due to the licensing restrictions.

I tried stripping everything out of the except the font statements and I still get the problem i.e.

Private Sub Section3_Format(ByVal pFormattingInfo As Object)
' Detail Section
fldName.Font.Size = 14

End Sub

but the problem still occurrs when cangrow is set.

It may be that this is a known bug in Crystal reports 8 as well as CR.NET. If so then I may have to chat with crystal decisions about some kind of workaround.
0
 

Author Comment

by:SimonWillis
ID: 6893473
Thanks, I have about as much info as I could get now. Cheers !
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now