Data Source - Data Report Designer

I'm using DE. I found the Initialize event. But I need to change the
DataSource that is mapped to the DE Connection. Can I change the connection
in DE at run time using code? If not, then I will change to DOA as soon as I
can figue out how. I am using DB open and close throughtout my program, and I
would like to do it here also. I will try DB Open and RS open in the
initialize event in the Data Report. Now, I have to figure out how to map to
the RS fields. Is there a help in MSDN any place?

Thanks. With your help I know I will get there.

"Ralph" wrote:

>
> "Thom" <Thom.TakeThisOut@discussions.microsoft.com> wrote in message
> news:32D9D546-E32D-4BB0-8E6A-CE761AD2310A@microsoft.com...
> > Is there a way to change the Database Source at run time in the Microsoft
> > Data Report Designer? If so. How?
>
> Yes.
> Just reset the DataSource Property
>
> Set DataReport1.DataSource = rs
> DataReport1.Show
>
> Are you perhaps using DE?
> If so remove the DataMember property from any bounded controls in the report
> and and make your change in the Initialize Event...
>
> -ralph
>
>
>
 >> Stay informed about: Data Source - Data Report Designer 

GOT IT! In Initialize event of Data Environment:
Conection1.Connectionstring = App.Path & "DB Name"

THANKS RALPH!

"Thom" wrote:

> I'm using DE. I found the Initialize event. But I need to change the
> DataSource that is mapped to the DE Connection. Can I change the connection
> in DE at run time using code? If not, then I will change to DOA as soon as I
> can figue out how. I am using DB open and close throughtout my program, and I
> would like to do it here also. I will try DB Open and RS open in the
> initialize event in the Data Report. Now, I have to figure out how to map to
> the RS fields. Is there a help in MSDN any place?
>
> Thanks. With your help I know I will get there.
>
> "Ralph" wrote:
>
> >
> > "Thom" <Thom.TakeThisOut@discussions.microsoft.com> wrote in message
> > news:32D9D546-E32D-4BB0-8E6A-CE761AD2310A@microsoft.com...
> > > Is there a way to change the Database Source at run time in the Microsoft
> > > Data Report Designer? If so. How?
> >
> > Yes.
> > Just reset the DataSource Property
> >
> > Set DataReport1.DataSource = rs
> > DataReport1.Show
> >
> > Are you perhaps using DE?
> > If so remove the DataMember property from any bounded controls in the report
> > and and make your change in the Initialize Event...
> >
> > -ralph
> >
> >
> >
 >> Stay informed about: Data Source - Data Report Designer