Crystal Report 9.2 Fixed Datasource Location

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 374,006 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,741 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Visual Basic 4 / 5 / 6 advertiser:

Thread Tools Display Modes

Views: 417 | Replies: 4

•

Join Date: Jan 2007

Posts: 2

Reputation: tekrum is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

tekrum

Offline

Newbie Poster

Crystal Report 9.2 Fixed Datasource Location

May 6th, 2008

Does anyone knows how to make datasource location of a report fixed like in VB you can use app.path. Can anyone suggest how to do it?

Thanks in advance!

•

Join Date: Nov 2006

Posts: 658

Reputation: QVeen72 is an unknown quantity at this point

Rep Power: 3

Solved Threads: 90

QVeen72

Offline

Practically a Master Poster

Re: Crystal Report 9.2 Fixed Datasource Location

May 7th, 2008

Hi,

From VB6, just before Viewing the report, Set the DB location for each tables used in the report..
What is your Database..? Access/Oracle/SQL...?

Regards
Veena

•

Join Date: Jan 2007

Posts: 2

Reputation: tekrum is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

tekrum

Offline

Newbie Poster

Re: Crystal Report 9.2 Fixed Datasource Location

May 7th, 2008

I have an access database. How do I do that?

•

Join Date: Nov 2006

Posts: 658

Reputation: QVeen72 is an unknown quantity at this point

Rep Power: 3

Solved Threads: 90

QVeen72

Offline

Practically a Master Poster

Re: Crystal Report 9.2 Fixed Datasource Location

May 8th, 2008

Hi,

Before Viewing the report , set DB location for all the Tables used in the report:

 Help with Code Tags 
 vb Syntax (Toggle Plain Text) 
Dim tt As CRAXDDRT.DatabaseTable
For Each tt In m_Report.Database.Tables
 tt.Location = "C:\NewDB.mdb"
Next
Dim tt As CRAXDDRT.DatabaseTable
For Each tt In m_Report.Database.Tables
 tt.Location = "C:\NewDB.mdb"
Next

Regards
Veena

•

Join Date: Apr 2008

Posts: 14

Reputation: freshface001 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 1

freshface001 freshface001 is offline

Offline

Newbie Poster

Re: Crystal Report 9.2 Fixed Datasource Location

May 12th, 2008

in visual basic 6, using Data control for accessing the access database. give the data base name(*.mdb) in "DataBaseName" property of data control.and select the table in the "RecordSource" property of data control. then place no_of text fields or lables in the same form(appear Data control) for viewing the values of the access database data by selecting datasource as data controll name and select field name in the "DataFiled" property of text box or label.