Home > Archive > Visual Basic Crystal Reports > June 2005 > Upd DataSource w/o redoing report
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Upd DataSource w/o redoing report
|
|
|
| I'm using an xml data source for my report. When the datasource needs to
change I have to change to the "new database" and when I do that all of my
datafields in the report disappear and I have to do them all over.
Is there any way of getting around this?
thanks,
T
| |
| John Mishefske 2005-06-07, 3:58 am |
| Tina wrote:
> I'm using an xml data source for my report. When the datasource needs to
> change I have to change to the "new database" and when I do that all of my
> datafields in the report disappear and I have to do them all over.
I've had the same issue and I'm sure there is a proper way to do this but I'm still pretty
new to CR at this point. (CR9/VB6)
I've used the "Set Datasource Location" option (right click on your current datasource)
and click on the current datasource name. Then click on Properties and highlight the
TableName.
Then use the "Replace" box to indicate a new "table" name (view/query). I clicked on
History, selected the database, entered the password and selected the new view/query.
Your controls on the report should remain but use different values from the updated data
source.
Is there a better way? Seems pretty novice to leave the Datasource location pointing to a
datasource name that isn't accurate....
--
'---------------
'John Mishefske
'---------------
| |
| John Mishefske 2005-06-10, 4:02 am |
| John Mishefske wrote:
> Tina wrote:
>
>
>
> I've had the same issue and I'm sure there is a proper way to do this
> but I'm still pretty new to CR at this point. (CR9/VB6)
>
> I've used the "Set Datasource Location" option (right click on your
> current datasource) and click on the current datasource name. Then click
> on Properties and highlight the TableName.
>
> Then use the "Replace" box to indicate a new "table" name (view/query).
> I clicked on History, selected the database, entered the password and
> selected the new view/query.
>
> Your controls on the report should remain but use different values from
> the updated data source.
>
> Is there a better way? Seems pretty novice to leave the Datasource
> location pointing to a datasource name that isn't accurate....
For those reading along.. it looks like the "Verify Database" is the proper way to do this.
--
'---------------
'John Mishefske
'---------------
|
|
|
|
|