Click here to Skip to main content
15,913,773 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionMusic Schedule advice? Pin
Mr Oizo25-Sep-07 23:45
Mr Oizo25-Sep-07 23:45 
Questionfocus problem Pin
Tom Deketelaere25-Sep-07 23:07
professionalTom Deketelaere25-Sep-07 23:07 
AnswerRe: focus problem Pin
Hesbon Ongira25-Sep-07 23:56
Hesbon Ongira25-Sep-07 23:56 
GeneralRe: focus problem Pin
Tom Deketelaere26-Sep-07 1:12
professionalTom Deketelaere26-Sep-07 1:12 
QuestionHow to get name of the .exe running in a machine.. Pin
Balagurunathan S25-Sep-07 21:37
Balagurunathan S25-Sep-07 21:37 
AnswerRe: How to get name of the .exe running in a machine.. Pin
Mbire26-Sep-07 0:35
Mbire26-Sep-07 0:35 
GeneralRe: How to get name of the .exe running in a machine.. Pin
Balagurunathan S26-Sep-07 20:27
Balagurunathan S26-Sep-07 20:27 
QuestionCrystal Report XI having an Error Access Denied .SetReportVariableValue("parameter","value") Please Help Urgent... [modified] Pin
vbDigger'z25-Sep-07 18:03
vbDigger'z25-Sep-07 18:03 
Public crxApp As CRAXDRT.Application
Public crxReport As CRAXDRT.Report
Public crxDataBase As CRAXDRT.Database
Public crxTable As CRAXDRT.DatabaseTable
Public crxTables As CRAXDRT.DatabaseTables

Public strSelectionfrm As String
Public strCRSourcePath As String


Private Sub frmCrystalReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Me.MdiParent = frmMain

crxApp = New CRAXDRT.Application

crxReport = crxApp.OpenReport(strCRSourcePath, 0)
crxReport.RecordSelectionFormula = strSelectionfrm

crxDataBase = crxReport.Database
crxTables = crxDataBase.Tables

For Each crxTable In crxTables
crxTable.Location = DataSource
crxTable.SetLogOnInfo("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & reportPath, "myDatabase.mdb", "", "password")
Next crxTable

'Error occur here! i dont know why im access denied.. but if i will ommitt the .SetReportVariableValue() then it works just fine without committing access denied but then i have to set some variable i've declare inside the report..Confused | :confused:


crxReport.SetReportVariableValue("varEduc", "Hello Crystal World")


AxCRViewer1.ReportSource = crxReport
AxCRViewer1.ViewReport()

crxDataBase = Nothing
crxTable = Nothing
crxTables = Nothing
crxReport = Nothing
crxApp = Nothing

Catch ex As Exception
MsgBox(ex.ToString())
Finally
End Try
End Sub

***************

crxReport.SetReportVariableValue("varEduc", "Hello Crystal World")

the varEduc is already declare inside the report which means it is existing variable inside report..

is anybody there who have a good idea or solutions about this??? please??? Sigh | :sigh:


Anybody there Please help me with this headache... D'Oh! | :doh:



-- modified at 3:00 Wednesday 26th September, 2007
QuestionConnecting to Excel Pin
vidya11025-Sep-07 17:43
vidya11025-Sep-07 17:43 
AnswerRe: Connecting to Excel Pin
eyes200725-Sep-07 18:54
eyes200725-Sep-07 18:54 
GeneralRe: Connecting to Excel Pin
vidya11026-Sep-07 17:35
vidya11026-Sep-07 17:35 
QuestionUsing Application reference Pin
Mycroft Holmes25-Sep-07 14:58
professionalMycroft Holmes25-Sep-07 14:58 
AnswerRe: Using Application reference - amended Pin
Mycroft Holmes25-Sep-07 15:15
professionalMycroft Holmes25-Sep-07 15:15 
AnswerRe: Using Application reference - solved Pin
Mycroft Holmes25-Sep-07 15:26
professionalMycroft Holmes25-Sep-07 15:26 
QuestionCan someone give me the code of my project? Pin
*Muskan*25-Sep-07 11:40
*Muskan*25-Sep-07 11:40 
AnswerRe: Can someone give me the code of my project? Pin
GuyThiebaut25-Sep-07 13:02
professionalGuyThiebaut25-Sep-07 13:02 
AnswerRe: Can someone give me the code of my project? Pin
Dave Kreskowiak25-Sep-07 13:04
mveDave Kreskowiak25-Sep-07 13:04 
GeneralRe: Can someone give me the code of my project? Pin
Paul Conrad26-Sep-07 18:28
professionalPaul Conrad26-Sep-07 18:28 
AnswerRe: Can someone give me the code of my project? Pin
Christian Graus25-Sep-07 13:12
protectorChristian Graus25-Sep-07 13:12 
AnswerRe: Can someone give me the code of my project? Pin
Hesbon Ongira26-Sep-07 0:32
Hesbon Ongira26-Sep-07 0:32 
AnswerRe: Can someone give me the code of my project? Pin
ESTAN26-Sep-07 1:34
ESTAN26-Sep-07 1:34 
GeneralRe: Can someone give me the code of my project? Pin
Paul Conrad26-Sep-07 18:29
professionalPaul Conrad26-Sep-07 18:29 
AnswerRe: Can someone give me the code of my project? Pin
icemandark26-Sep-07 3:32
icemandark26-Sep-07 3:32 
QuestionModifying textbox control from MTA Pin
cstrader23225-Sep-07 11:18
cstrader23225-Sep-07 11:18 
AnswerRe: Modifying textbox control from MTA Pin
Dave Kreskowiak25-Sep-07 13:14
mveDave Kreskowiak25-Sep-07 13:14 

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.