Database field size(very general ques)

[davi123]

while cretaing reports, what size i have to set for database feilds.

Let say D1 is database field of size 100, then should I set the feild size 100 in crystal reports so that it can display all the 100 char even if all records having 50 char long data in D1 database field. Should I have to consider that in future there can be 100 char long data in that database field. I am so confuesd.

Thanks in advance

 

[Naith]

Crystal will simply inherit your datatype attributes when you point it at your database, providing they are set reasonably at database level (e.g. no varchar(4000)).

If your datasource changes in the future, verify the report against the database to pick up all changes.

Naith

 

[davi123]

Let me explain you my problem

I am using cross tab object. I am adding database fields to cross tab as row, column and summary fields.

row fields size in database is VARCHAR2(100), VARCHAR2(25)
column field size in database is VARCHAR2(12)

what size i have to set for row,column in crosstab. do i have to set it according to database field size. if i set it to database field size then all columns will not appear on one page. If I don't set it according to database field size then I afraid what if in future user enter the data which of 100 char for row, 25 char for column.

 

[hengisglasgow73]

The option to let each column 'Can Grow' should be avaialble on the format field dialog. I think this might only be avaialble in preview mode only.

So In preview right click on on of your column headers and select format field. Then click the can grow check box. now adjust the width of the field to ~15 characters. You should see the columns where it is required to strech - it does.

This will grow each column if needed when the data drives the required width.
Hope that helps

 

[davi123]

Hi hengisglasgow73,

but, in cross tab Can Grow is disable for feild. I am using Crystal report.NET. Do you know how to set Can Grow in case of cross tab. This is what i am looking for. In crystal report.net How I can preview the report.

Thanks