Re: .NET Change DB at runtime
From: Francis Lui (iulf_at_nospam.com)
Date: 05/29/04
- Next message: Francis Lui: "Re: Export error : Access denied...Maybe used by another prog."
- Previous message: Francis Lui: "Re: Crystal Reports Upgrade Introduced A Bug"
- In reply to: Jerry: ".NET Change DB at runtime"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 29 May 2004 03:11:04 -0700
The SetLogon() convenience methods were introduced in the monthly hot fixes
1.5 years ago. If you download and install the monthly hot fixes from
http://support.businessobjects.com, you should be able to see them.
Hope this helps,
Francis
"Jerry" <jerryg_no_spam@ptd.net> wrote in message
news:_OecnSXDebKI0T_dUSdV9g@ptd.net...
> Hi,
>
> I've used Crystal reports from the full product but this is the first time
> I've tried to use it with VisualStudio.NET. I'm hoping somebody can help
me
> with this problem cuz all my books assume I have the full implementation
of
> Crystal.
>
> It's pretty simple really - I've designed a report within Visual Studio
> based on a stored procedure within my development server. Works great.
But
> when I move this application to the production server I will want the
report
> to happily pull data from that server.
>
> I have my database connection information in my web.config file and I
would
> like each report to use the database settings that I read from the
> Web.config. This way I can easily make the changes when the software is
> installed.
>
> I've seen some examples using SetLogon as
>
> Set myReport as New CrystalReport1
> myReport.Database.Tables(1).Setlogon xxx,xxx,xxx
> me. CrystalReportViewer1.ReportSource = myReport
> me.CrystalReportViewer1.Databind()
>
> That looked simple enough - until I got "Tables(1)" and found no such
method
> as .SetLogon :-(
>
> Every database that I intend to report from will have the same tables and
> stored procedures. I intend to develop all of my reports off of tables
and
> stored procedures and will be referencing them using the GUI features
while
> in VS.NET. I simply want to set the database properties on the fly.
>
> Any help would be very very very much appreciated.
>
> Thanks
>
>
- Next message: Francis Lui: "Re: Export error : Access denied...Maybe used by another prog."
- Previous message: Francis Lui: "Re: Crystal Reports Upgrade Introduced A Bug"
- In reply to: Jerry: ".NET Change DB at runtime"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
