Re: Crystal Report
From: Iain (iains_at_pciltd.co.uk)
Date: 12/10/04
- Next message: w: "HELP needed with chart"
- Previous message: StarQuake: "Re: No border around field with null value"
- In reply to: Brian Bischof: "Re: Crystal Report"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Dec 2004 09:27:22 -0000
Plus, I am informed by one of my colleagues that, if you wish to print
pictures from the database, the ODBC connection doesn't work, but the OLE/DB
one does.
So I'd go for the OLE/DB.
As for creating the connection, select Create New Connection, then OLE/DB,
then Microsoft OLE DB provider for SQL server, then select the server from
the list, enter the database user and password and select the database.
There are then tweaks you can apply, but we don't. Voila, a list of the
tables to link to the report...
Iain
"Brian Bischof" <Brian@NoSpamBischofSystems.com> wrote in message
news:OxWbunj3EHA.824@TK2MSFTNGP11.phx.gbl...
> Personally, I hate ODBC because it requires me to maintain the DSN. This
> impacts me in two ways: first is that I reformat my computer every six
> months to "clean out the garbage" and get the speed back to normal. So I
> have to setup my DSNs again. Second is that when I deploy to another
> computer I have to add the DSN's to their computer. MS created the File
> DSN
> to make this easy, but these are very buggy and should be avoided. Thus, I
> like OLE DB and use it for all my apps.
>
> Just my 2 cents.
>
> Brian Bischof
> www.CrystalReportsBook.com
>
>
> "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
> news:%23O2eRBi3EHA.3616@TK2MSFTNGP11.phx.gbl...
>> It's hard to say which is easiest.
>> I am sitting in front of my pc with CR loaded and permissions on my
>> database. It's just as easy for me to use ODBC as it is OLEDB. The ODBC
>> connection requires a DSN on the machine that is running the report,
> whether
>> that is my machine using CR or a web server launching the report, etc.
>> Having the DSN is nice in that if you want to use a different database (I
>> use a test database sometimes for development), you set up the DSN to
> point
>> to one database, build your report from the DSN. When you want to
>> switch,
>> you change where the DSN points, you don't have to touch the report. I
>> suppose there are advantages and disadvantages to every method. You have
> to
>> determine which method fits your situation best.
>>
>> --
>> Bob Holmes
>>
>> <anonymous@discussions.microsoft.com> wrote in message
>> news:1e2c01c4de13$56cd8170$a501280a@phx.gbl...
>> > Hi Bob,
>> >
>> > I am using Crystal report that was provided by the Visual
>> > Studio.Net. I am using the CR designer. My database is Ms
>> > SQL Server 2000. I dont know whether I have to use ODBC
>> > or OLEDB. What do you think. Which one is the most
>> > easiest to connect to database. And how to do it.
>> >
>> > Thanks
>> > >-----Original Message-----
>> > >You might have to a little more specific about what you
>> > are doing. Are you
>> > >using the CR designer or are you using code to control a
>> > CR object, etc? If
>> > >you are using the designer, you can select your
>> > datasource from a list. You
>> > >have to decide if you are using and ODBC connection, or
>> > an OLEDB, etc.
>> > >
>> > >--
>> > >Bob Holmes
>> > >
>> > >"Dav" <dappyl@lycos.co.uk> wrote in message
>> > >news:284801c4de0c$51620a50$a301280a@phx.gbl...
>> > >> How to connect SQL-Data database into crystal report
>> > >> database connection. I couldn't find how to connect
>> > from
>> > >> sql server 2000. I only can find from access.
>> > >
>> > >
>> > >.
>> > >
>>
>>
>
>
- Next message: w: "HELP needed with chart"
- Previous message: StarQuake: "Re: No border around field with null value"
- In reply to: Brian Bischof: "Re: Crystal Report"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
