Re: Connecting to SQLServer Tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brian Bischof (BrianNoSpam_at_BischofSystems.com)
Date: 03/24/04 

Date: Tue, 23 Mar 2004 21:28:16 -0800

Gary,

When you create a new report using the Report Wizard, in the Data tab there
are options that let you select ODBC and OLE DB connections. You can also
connect to Excel and XML files. Expand the various nodes to see all the
connectivity options you have.

If you are connecting with datasets, you have to perform these steps:
1) Instantiate the report object.
2) Call SetDataSource() and pass it the populated dataset object
3) Assign the report object to the viewer

Do this anywhere on the form (in the Load() event or in response to a button
being clicked).

HTH,

Brian Bischof

A Crystal Reports.NET book for programmers? Its here!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented

http://www.crystalreportsbook.com/123aspx.asp

"Gary" <gb@nospam.com> wrote in message
news:ugZiVxTEEHA.2600@TK2MSFTNGP09.phx.gbl...
> I'm trying to get started with Crystal but it only lists datasets as
> "current connections". How can I access Tables. I've seen examples that
> use ODBC and OLEDB connections to get to .MDB datasets but I can't seem to
> get it connected to SQL Server.
>
> If I have to just connect to datasets, where do I put the code to load the
> datasets?
> Help
> Gary
>
>

Relevant Pages

  • Re: Report on connections
    ... You could add a User cell to each shape and then run your ... FromSheet and ToSheet onto a report. ... The Visio SDK has a Code snippet "Drawing Navigator Using Connections" ... A simple example would be two processes A and B with B being dependent ...
    (microsoft.public.visio.general)
  • Re: Wiki software for genealogy (long)
    ... store information ... ... it needs to allow connections to be made flexibly ... ... spreadsheet, scribbled note, or a dry 60-page report full of source ... While software capabilities have improved, no one tool or piece of software ...
    (soc.genealogy.britain)
  • Re: Report on connections
    ... the code snippet is in the SDK - Microsoft Code Librarian Viewer ... connections report. ... transformed by an XSLT file into a proper report. ... A simple example would be two processes A and B with B being dependent on ...
    (microsoft.public.visio.general)
  • Re: Report on connections
    ... The navigator is a good place to start, but I found the filter too restricting since I couldn't guarantee that all connections would be created in the same direction. ... Theoretically, you could use the reports tool to merge two XML outputs, transformed by an XSLT file into a proper report. ... A simple example would be two processes A and B with B being dependent on A. ...
    (microsoft.public.visio.general)
  • Getting the RecordSource at Runtime. Access2000
    ... The fact that two connections cannot be open to the same ... I need to get the reports recordsource ... 1)Select a report from a VB listbox. ... appAccess.DoCmd.OpenReport sReport, acViewDesign ...
    (microsoft.public.access.reports)