Click here to Skip to main content
15,899,754 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: PictureBox Pan Pin
Brad Fackrell1-Jul-04 10:03
Brad Fackrell1-Jul-04 10:03 
GeneralWMPlayer active x, begining of tracks get cut off Pin
Glen Conaway1-Jul-04 7:30
Glen Conaway1-Jul-04 7:30 
GeneralTrigering Application at specified intervals Pin
kashif_kazi1-Jul-04 4:53
kashif_kazi1-Jul-04 4:53 
GeneralRe: Trigering Application at specified intervals Pin
Dave Kreskowiak1-Jul-04 5:33
mveDave Kreskowiak1-Jul-04 5:33 
GeneralRe: Trigering Application at specified intervals Pin
kashif_kazi1-Jul-04 19:58
kashif_kazi1-Jul-04 19:58 
GeneralRe: Trigering Application at specified intervals Pin
Dave Kreskowiak2-Jul-04 2:46
mveDave Kreskowiak2-Jul-04 2:46 
GeneralRe: Trigering Application at specified intervals Pin
kashif_kazi2-Jul-04 19:59
kashif_kazi2-Jul-04 19:59 
GeneralCrystal Reports Problem Pin
fizzer6661-Jul-04 4:52
fizzer6661-Jul-04 4:52 
Hi everyone,

I have managed to get crystal reports working with my program fine when the database used for the source is put in a fixed directory ie. the programs directory.

I'm now updating my program so that the user can install the program in any directory and the database is called from the application folder. This works great with everything except the crystal reports. The main problem is that originally I had set the crystal report data source to the database in the fixed directory so I thought it would be a simple job to just use the dataset as the data source to get over this problem. I have tried the folowing code on a form with the report viewer:


'First change the directory of the database to the application folder
Try
Me.OleDbConnection1.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= Asset Control.mdb"

Catch eConnection As System.Exception
MessageBox.Show(eConnection.Message)
End Try


'now fill the data adapter
Me.OleDbDataAdapter1.Fill(Me.DsAssetTypeReport1)


'**********************************************************************************

'Change Report Source to application folder
Try
Me.CrystalReportViewer1.ReportSource = "Reports\CRAssetsByAssetType1.rpt"
Catch eConnection As System.Exception
MessageBox.Show(eConnection.Message)
End Try

'***********************************************************************************
End Sub


I think the reportviewer is still trying to open the report from the fixed directory because I get a log On dialog appear. And if the database is in the original directory it will open. Can anyone throw some light on this?
Also am I anywhere near the mark with the code above?

Thanks in advance.

GeneralRe: Crystal Reports Problem Pin
Dave Kreskowiak1-Jul-04 5:45
mveDave Kreskowiak1-Jul-04 5:45 
GeneralRe: Crystal Reports Problem Pin
fizzer6662-Jul-04 4:04
fizzer6662-Jul-04 4:04 
GeneralRe: Crystal Reports Problem [EDITED] Pin
Dave Kreskowiak2-Jul-04 4:15
mveDave Kreskowiak2-Jul-04 4:15 
GeneralRe: Crystal Reports Problem [EDITED] Pin
fizzer6662-Jul-04 4:54
fizzer6662-Jul-04 4:54 
GeneralRe: Crystal Reports Problem [EDITED] Pin
fizzer6665-Jul-04 4:13
fizzer6665-Jul-04 4:13 
GeneralRead the decibel from a mic. Pin
sybux20001-Jul-04 1:36
sybux20001-Jul-04 1:36 
GeneralRe: Read the decibel from a mic. Pin
Dave Kreskowiak1-Jul-04 4:02
mveDave Kreskowiak1-Jul-04 4:02 
QuestionHow to fill the list of one combo box to another combo box? Pin
Ravi S.V.30-Jun-04 21:08
Ravi S.V.30-Jun-04 21:08 
AnswerRe: How to fill the list of one combo box to another combo box? Pin
Dave Kreskowiak1-Jul-04 4:15
mveDave Kreskowiak1-Jul-04 4:15 
GeneralRe: How to fill the list of one combo box to another combo box? Pin
beowulfagate1-Jul-04 20:18
beowulfagate1-Jul-04 20:18 
GeneralRe: How to fill the list of one combo box to another combo box? Pin
Ravi S.V.1-Jul-04 21:11
Ravi S.V.1-Jul-04 21:11 
GeneralRe: How to fill the list of one combo box to another combo box? Pin
Dave Kreskowiak2-Jul-04 2:37
mveDave Kreskowiak2-Jul-04 2:37 
QuestionWindows or Web Service, Which? Pin
leadpencil30-Jun-04 19:53
leadpencil30-Jun-04 19:53 
AnswerRe: Windows or Web Service, Which? Pin
Dave Kreskowiak1-Jul-04 3:28
mveDave Kreskowiak1-Jul-04 3:28 
Questionhow to capture an exe file file name into vb form Pin
saimram30-Jun-04 18:50
saimram30-Jun-04 18:50 
AnswerRe: how to capture an exe file file name into vb form Pin
Dave Kreskowiak1-Jul-04 3:21
mveDave Kreskowiak1-Jul-04 3:21 
Generalurgent......Pocket Pc volume Pin
Prowess30-Jun-04 17:54
Prowess30-Jun-04 17:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.