Database change- NEED HELP 1

[old123]

crystal Version 9
Data Connection ODBC AS400

Iam a beginner in Crystal Reports .
ALl of my reports were working fine untill this change.

The SA decided to change the database tables names to seperate our data from other offices. Earlier the datbase was shared with all the departments.

All the file names are changed & the library is changed.

I tried modifying the databse link thru datbase expert. It lets me add the new table however it does'nt let me drop the old table name. I am using views in most of my files.

Any suggestions. I need to resolve this asap.

 

[Turkbear]

HI,
You should be able to recreate the views using the new table specs and the reports ( which only 'know' the view's name) should work ok..If not, try a verify database on each to update the metadata.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[old123]

it lets me add the new view however it does'nt let me drop or delete the old tables. also if i do verfify database. it gives me messgae "database is up to date

 

[TheBlondOne]

Sounds like you need to set the location for each of the tables and point them to the new views. Crystal won't let you delete any tables from the report where fields from that table are being used in the report.

To do that you need to go to database >> set databases locatation.

Then you should see a box appear with the list of tables in the report.

You can then click onto each one individually, select set location and then locate the new view which is replacing the old view.

HTH




-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[old123]

Thanks for responding, I did that yesterday & changed the datsource. My report works fine now however it still shows the old table name. Is there any way to change it to the new name to avoid confusion & this way it shows the replaced name.

 

[TheBlondOne]

How do you mean "It shows the old table name"? is this when you go into the TOC subreport where you've got your grouper,page,datetime field?

If it is then as far as i'm aware you can't change the old name to the new name without deleting the table and re-adding it.

What might be worth a try is to create another blank report (exactly the same as the TOC subreport), using the new TOC table and link this report into the main report like you did with the TOC subreport.

Then if that all works fine which it should do, you can then delete the old subreport.

Let me know if you were on about something different.

HTH


-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[old123]

Iam not sure if are in same page.
& there is no subreport in my report.

I created new reports with new tables & they work fine & show me the new names , problem is with the old reports & i have almost 75 reports.

Let me explain myselg again.

Earlier database had table name FM310 in library Fleet , FM305 in Library YR2000 & there are 100 os tables like that.
Our database got seperated from other depts & the table names are PT310 & PT305 in library PT.

All the fields names are same only tables names are changed.

I changed the datasource to new one PT310 & PT305. It works fine in terms of getting current data as cutoff date was 25th aug & all the new data is in PT310 & PT305.

My issue is whenever i go to database fields or formulas or section name ( or anywhere) in the report it tsill shows the old name FM310 & FM305.

i want it show PT310 & PT305 as the data is coming from these tables. These are the replaced tables.

I hope I make sense.

 

[TheBlondOne]

Sorry I posted into the wrong post. My fault.

As far as i'm aware when you set the location for the database it will only add the new table to the report and not replace the table name. So when you do go into formula's, visual linking etc... you will still see the old table name even though the report is not looking for that table.

Don't think there is a way around this unfortunately.

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[BruceBussell]

Starting in Crystal 9, to Rename a table or view that has been changed in Set Datasource Location:

Go to Database \ Database Expert and then click on each table or view that has been changed, and then press F2 and it will let you rename the selected table or view to your new name. Then the new name(s) will appear in the Crystal Formulas, etc.

 

[TheBlondOne]

Good tip BruceBrussell. Didn't know that one.

* for you.

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )