INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

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!

*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

Update database field size

Update database field size

(OP)
Hi,
I have a report with construction details.. it has below fields

Transaction# - Datatype Number(10)
Construction_company - Datatype Varchar2(15)
Amount - Datatype Number(20)

Now the changes are made to the size of these fields in database. The field names are same.

Transaction# - Datatype Number(20)
Construction_company - Datatype Varchar2(25)
Amount - Datatype Number(30)

Do i have to make changes to report so report doesnt fail..? If i dont have to make changes then will the report show whole transaction# of size 20 or will show only 10 digits..? Same applies to other fields as well, do i have to make changes to other fields, if not then how many digits will be displayed..?

RE: Update database field size

You need to verify the database.

www.R-Tag.com Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

RE: Update database field size

(OP)
what if the verify database is not done?? will the report fail?? if not then what will be displayed??

RE: Update database field size

Are there any reason to not verify it ?
The report keeps information about each field and will get the data using this information. If the field length is 20 chars and you change it to 40 the report will cut the data to 20.

www.R-Tag.com Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

RE: Update database field size

The report will probably run, but what will happen may depend on the database. It may be fine or it may truncate those fields, or it may even shift all fields over 10 characters. I have never tested this scenario but I have seen strange results when a table structure changes. Why don't you just test it and tell us what happens.

Also, if you can open the report (even if you can't run it or verify it) you can always go into "File > Report Options" and check "Verify on first refresh". That way the report will verify itself at runtime. This will slow down the report at runtime because it can never SAVE the new structure, but it might help if your field sizes change on you frequently.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
http://www.kenhamady.com/

RE: Update database field size

(OP)
Thank you so much for your replies, the report is on client portal so i want to avoid the update to avoid reposting it. I have option 'verify on first refresh' checked by default. Hopefully it will show the updated values on report. I will post here once i get more info.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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