Changing Data Source

building reports crystal reports
1

hi, iv got an existing report that uses a Tables as the data source. i need to switch the datasource to a stored procedure which is exactly the same as the Tables except passing Parameters through .net Application.

if i add SP to existing report, And remove table its asking old filed are remove popup message if i click ok button, old Field is removing,

how to keep it same field from SP and remove Table from Datasource.

any suggestions? thanks in advance

dsrinivasmca83 (BOB member since 2012-04-18)

2

me too looking for the solution as I came to the same scenario.

Thanks,

Tims_Bo :india: (BOB member since 2008-07-26)

3

Insert the SP and change the fields accordingly since the data fields would be with the same name.

Change the same in the Formulae and Parameters .

ash0550 :canada: (BOB member since 2011-09-12)

4

Click on database and select Set Datasource Location.

Thanks,

Tims_Bo :india: (BOB member since 2008-07-26)