Datasource not updating

[cfcProgrammer]

Hi,

I could really use your help!!
I've already searched through most of the posts and nothing really fits my issue...

I have created a new report but not from the wizard. I opened an existing report that the new one will be based on and saved it under the new name. I need to change the datasource so I went into Database -> set datasource location and pointed to the new stored procedure. well the current data source window was updated with the new stored procedure but not in both places. It filters like this...

report -> 
       datasource name (THIS DID NOT CHANGE)
        -> properties 
        -> datasource table name
             ->properties
                ->Table name (THIS CHANGED WHEN I UPDATED)

The datasource name should have changed to the new stored procedure name it should not still contain the original/old stored procedure.

Any help would be greatly appreciated. I am using Crystal 9.0
Thank you very much...
cfcprogrammer

 

[Turkbear]

Hi,
The names Crystal uses do not change when the datasource changes ( unless you take some extra steps) so that formulas etc. that use the original name do not need changing..

The report should be returning the correct data ..





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

 

[cfcProgrammer]

There are alot of formulas that will need to be modified is there a way to get around that so that all referenced fields will now be referencing the new stored procedure. The stored procedures are identical...

 

[Turkbear]

Hi,
The formulas would not need changing if the new SP had the same name as the old..If the name of the SP was changed, not just the datasource, then you will need to re-edit the formulas...





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

 

[cfcProgrammer]

I made a mistake in my original description... the datasourse table name did not change but when filtered down to the table name that changed. These should be the same now... sorry for the confusion.

report -> 
       datasource name 
        -> properties 
        -> datasource table name(THIS DID NOT CHANGE)
             ->properties
                ->Table name (THIS CHANGED WHEN I UPDATED)

 

[cfcProgrammer]

in reference to my last posting... the datasource table name is still not updating.. I tried setting up a new connection but still it only updates the table name not the datasource table name... shouldn't it update both?