Change db fields

[audface]

I hope there is a solution for this. My problem is every single time I change the table or even add new/change name in my SQL server, I have to remove and reload the entire database in to my report and reconfigure all my fields to every single RDC report. It is so frustrating. This also happens when I change to a new ODBC name.

Thank you.

 

[dgillz]

I do now know how you do this within VB and the RDC, but in regular crystal you click on database, verify database and you are done. Takes about 10 seconds per report. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[audface]

Well, unfortunately, to change any field in the report affects much formulas and join procedures between a number of tables. Since I have so many reports, I'll have to go one by one to redo it. Guess it this the way CR goes.

Thank you for the reply.

 

[dgillz]

NO! That is not the way crystal works!

You click on database, verify database and any field referenced within another formula that it does not recognize, it will prompt you for, ONCE. After you have defines what field to use it will automatically update every single formula.

Did you try my solution? Again I am no VB expert, but I am sure this is available. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[techies]

Hi,

You can use the CR API Verify() to do this.

oReport.Database.Tables.Item(1).SetDatasource yourRecordset
oReport.Database.Verify

This should do it.

cheers,
Techi