Default "can grow" properity

Hi all,

I found that the default "can grow" in Crystal Reports 10 is different from the one in Crystal Report 9.

In version 9, when "can grow" is disable, the words in the field are chopped off and doesn't not warp around to the next line.

In version 10, when "can grow" is disable ,the text would overlap the field next to it if the text is too long, to make it field behave the same as version 9, I have to enable the "can grow" property and set the limit to 1.

I am wondering if I can change the default "can grow" property to behave like version 9, so that I don't have to go to each of the report to change each fields' "can grow" property (that is a nightmare!!).

Wellesi am woring on CRXI i don't have any problem with can grow option.|||Maybe it is just version 10 in Visual Studio's problem.|||I figured out that I can programmatically set the can grow properity, but I can't find the way to set the limit for the can grow properity. Does any expert know how to set the limit?

//myReport is a report object, myField is a field object.
((FieldObject)myReport.ReportDefinition.ReportObjects["myField"]).ObjectFormat.EnableCanGrow = true;

Decrease the size of a Sql 2000

i had set the size of a new database to 5 GB and transactional log file to 50
MB. Now i realized that the database would grow to this size might be in the
next 20years and so want to decrease it to 100 MB ( the DB back up file is
only 20MB) and set it to "Autmatically Grow File" for both MDB and LDB files.
I could not find any option anywhere in help to do this. When i enter a value
of 100 MB in space allocated under the DataFile properties Tab it gives me a
message "file size cannot be decreased, it can only be increased.". Please
tell me if there is any way to do this.
thanks
> i had set the size of a new database to 5 GB and transactional log file to
50
> MB. Now i realized that the database would grow to this size might be in
the
> next 20years and so want to decrease it to 100 MB ( the DB back up file is
> only 20MB) and set it to "Autmatically Grow File" for both MDB and LDB
files.
> I could not find any option anywhere in help to do this. When i enter a
value
> of 100 MB in space allocated under the DataFile properties Tab it gives me
a
> message "file size cannot be decreased, it can only be increased.". Please
> tell me if there is any way to do this.
Hi!
Do please check the DBCC SHRINKFILE command in Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||I suggest you do this from Query Analyzer using the DBCC SHRINKFILE command (which is documented in
Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:F8D6293E-7949-4E1F-B68C-B27E912164C1@.microsoft.com...
>i had set the size of a new database to 5 GB and transactional log file to 50
> MB. Now i realized that the database would grow to this size might be in the
> next 20years and so want to decrease it to 100 MB ( the DB back up file is
> only 20MB) and set it to "Autmatically Grow File" for both MDB and LDB files.
> I could not find any option anywhere in help to do this. When i enter a value
> of 100 MB in space allocated under the DataFile properties Tab it gives me a
> message "file size cannot be decreased, it can only be increased.". Please
> tell me if there is any way to do this.
> thanks
>

Decrease the size of a Sql 2000

i had set the size of a new database to 5 GB and transactional log file to 5
0
MB. Now i realized that the database would grow to this size might be in the
next 20years and so want to decrease it to 100 MB ( the DB back up file is
only 20MB) and set it to "Autmatically Grow File" for both MDB and LDB files
.
I could not find any option anywhere in help to do this. When i enter a valu
e
of 100 MB in space allocated under the DataFile properties Tab it gives me a
message "file size cannot be decreased, it can only be increased.". Please
tell me if there is any way to do this.
thanks> i had set the size of a new database to 5 GB and transactional log file to
50
> MB. Now i realized that the database would grow to this size might be in
the
> next 20years and so want to decrease it to 100 MB ( the DB back up file is
> only 20MB) and set it to "Autmatically Grow File" for both MDB and LDB
files.
> I could not find any option anywhere in help to do this. When i enter a
value
> of 100 MB in space allocated under the DataFile properties Tab it gives me
a
> message "file size cannot be decreased, it can only be increased.". Please
> tell me if there is any way to do this.
Hi!
Do please check the DBCC SHRINKFILE command in Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||I suggest you do this from Query Analyzer using the DBCC SHRINKFILE command
(which is documented in
Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:F8D6293E-7949-4E1F-B68C-B27E912164C1@.microsoft.com...
>i had set the size of a new database to 5 GB and transactional log file to
50
> MB. Now i realized that the database would grow to this size might be in t
he
> next 20years and so want to decrease it to 100 MB ( the DB back up file is
> only 20MB) and set it to "Autmatically Grow File" for both MDB and LDB fil
es.
> I could not find any option anywhere in help to do this. When i enter a va
lue
> of 100 MB in space allocated under the DataFile properties Tab it gives me
a
> message "file size cannot be decreased, it can only be increased.". Please
> tell me if there is any way to do this.
> thanks
>

Decrease the size of a Sql 2000

i had set the size of a new database to 5 GB and transactional log file to 50
MB. Now i realized that the database would grow to this size might be in the
next 20years and so want to decrease it to 100 MB ( the DB back up file is
only 20MB) and set it to "Autmatically Grow File" for both MDB and LDB files.
I could not find any option anywhere in help to do this. When i enter a value
of 100 MB in space allocated under the DataFile properties Tab it gives me a
message "file size cannot be decreased, it can only be increased.". Please
tell me if there is any way to do this.
thanks> i had set the size of a new database to 5 GB and transactional log file to
50
> MB. Now i realized that the database would grow to this size might be in
the
> next 20years and so want to decrease it to 100 MB ( the DB back up file is
> only 20MB) and set it to "Autmatically Grow File" for both MDB and LDB
files.
> I could not find any option anywhere in help to do this. When i enter a
value
> of 100 MB in space allocated under the DataFile properties Tab it gives me
a
> message "file size cannot be decreased, it can only be increased.". Please
> tell me if there is any way to do this.
Hi!
Do please check the DBCC SHRINKFILE command in Books OnLine.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||I suggest you do this from Query Analyzer using the DBCC SHRINKFILE command (which is documented in
Books Online).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:F8D6293E-7949-4E1F-B68C-B27E912164C1@.microsoft.com...
>i had set the size of a new database to 5 GB and transactional log file to 50
> MB. Now i realized that the database would grow to this size might be in the
> next 20years and so want to decrease it to 100 MB ( the DB back up file is
> only 20MB) and set it to "Autmatically Grow File" for both MDB and LDB files.
> I could not find any option anywhere in help to do this. When i enter a value
> of 100 MB in space allocated under the DataFile properties Tab it gives me a
> message "file size cannot be decreased, it can only be increased.". Please
> tell me if there is any way to do this.
> thanks
>