Crystal reports query

Hello

would anyone know how to dynamically change the datasource of a crystal report from within VB.

The documentation lists the 'SetDataSource' method but it does not appear to work.?

Thx

[196 byte] By [Gretzky99] at [2008-2-5]

«« DataSet.AcceptChanges() doesn't accept all the changes!
»» generate filename from today

# 1

I have never had much like with Crystal. Its like running into a brick wall... repeatedly.
I perfer to use the SQL reporting tool that ships with MS SQL.

Pinky98 at 2007-9-8 >

top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...

# 2

Hello,

SetDataSource passes a Recordset or Dataset to the specified table in the report when using a 'Push Model'.

For the 'Pull Model' you would need to update TableLogOnInfo with the new datasource information. Specifically ConnectionInfo which has the following members:

DatabaseName String. Gets or sets the name of the database.

Password String. Gets or sets the password for logging on to the data source.

ServerName String. Gets or sets the name of the server or ODBC data source where the database is located.

UserID String. Gets or sets a user name for logging on to the data source.

Samples of this can be found on our .NET developer zone web site:

http://www.businessobjects.com/products/dev_zone/net/gettingstarted.asp?ref=devzone_netzone_nav

Keith - Business Objects

KeithThomson at 2007-9-8 >

# 3

HI Keith,

I am stuck in a problem,

in my ,NEt code, i need to get the query from the Crystal Report object. (I do not need to set the query, but from an existing Crystal report I need to get the query string)

and then do some manupulation on that query,

But I not able to get the QUERY in the .Net -

Pls help, my whole development is stuck because of this,

Thanx Avi.

AviRup at 2007-9-8 >

Visual Studio

Crystal Reports for Visual Studio

Visual Studio Hot Topic

Visual Studio New Topic

Visual Studio

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech