Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Marked Solved
Views: 9646

Aug 24th, 2007

Runtime error :20525 unable to load the report

Expand Post »

any problem here with the code coz am getting the error as unable to load the report

error no:20525

and it shows the property read only

can u clear it plzzzz

CrystalReport1.ReportFileName = App.Path + "\REPORTS\Nature_Of_Complaint.rpt"
CrystalReport1.ParameterFields(0) = "natureofcomplaint;" & cmbReport.Text & ";true"
CrystalReport1.ParameterFields(1) = "fromdate;" & dtpFrom.Value & ";true"
CrystalReport1.ParameterFields(2) = "todate;" & dtpTo.Value & ";true"
CrystalReport1.Action = 1

Similar Threads

Unable To Load JIT Compiler in Web Browsers
CrystalReports.Engine: Load report failed in ASP.NET
problem connection vb6 & crystal report 11 in Visual Basic 4 / 5 / 6
Run-Time error 1004 - Unable to set the RowHeight property of the range class in Visual Basic 4 / 5 / 6
VB6 Runtime error 7 Out of memory in Visual Basic 4 / 5 / 6

anto_nee

Reputation Points: 12

Solved Threads: 4

Junior Poster in Training

Offline

76 posts
since Aug 2007

Permalink

Aug 24th, 2007

Re: Runtime error :20525 unable to load the report

Hi,

What is the back end DB...? If SQLServer/Oracle, then u have to pass connection string...

REgards
Veena

QVeen72

Reputation Points: 84

Solved Threads: 140

Posting Shark

Offline

923 posts
since Nov 2006

Permalink

Aug 24th, 2007

Re: Runtime error :20525 unable to load the report

try crystalreport1.sqlquery instead of CrystalReport1.ParameterFields,
it can query the report in one line just like an ordinary sql statement in vb.
hope this helps.......

ryan_vietnow

Reputation Points: 28

Solved Threads: 71

Posting Pro

Offline

578 posts
since Aug 2007

Permalink

Aug 26th, 2007

Re: Runtime error :20525 unable to load the report

no guys

i think this is cause by the version

when i connect cr7 its working

but with cr9 i cant connect

but i have to check the connection string

am using sql server

can u write a connection string for me

anto_nee

Reputation Points: 12

Solved Threads: 4

Junior Poster in Training

Offline

76 posts
since Aug 2007

Permalink

Aug 27th, 2007

Re: Runtime error :20525 unable to load the report

Hi,

Working with CR9 is quite different, It is and RDC compared to lower versions which are "OCX". u need to use CR Viewer, Place the CR Viewer on the Form and use this code:

vb Syntax (Toggle Plain Text)
Dim m_Report As CRAXDDRT.Report
Dim m_Application As New CRAXDDRT.Application
Set m_Report = Nothing
Set m_Report = m_Application.OpenReport(App.Path & "\MyRep.rpt", 1)
With CRViewer1
    .EnableExportButton = True
    .EnablePrintButton = True
    .EnableCloseButton = True
    .ReportSource = m_Report
    .Height = Me.ScaleHeight - 1000
    .Width = Me.ScaleWidth
    .Left=200
    .Top =200
    .ViewReport
End With
Dim m_Report As CRAXDDRT.Report
Dim m_Application As New CRAXDDRT.Application
Set m_Report = Nothing
Set m_Report = m_Application.OpenReport(App.Path & "\MyRep.rpt", 1)
With CRViewer1
    .EnableExportButton = True
    .EnablePrintButton = True
    .EnableCloseButton = True
    .ReportSource = m_Report
    .Height = Me.ScaleHeight - 1000
    .Width = Me.ScaleWidth
    .Left=200
    .Top =200
    .ViewReport
End With

Regards
Veena

QVeen72

Reputation Points: 84

Solved Threads: 140

Posting Shark

Offline

923 posts
since Nov 2006

Permalink

Aug 27th, 2007

Re: Runtime error :20525 unable to load the report

thank you very much veena its workng fine

and i have one prob with passing the parameters

hw can i? codes........

and another one thing

why we cant open the report in a seperate window. do u hav any code for that

anto_nee

Reputation Points: 12

Solved Threads: 4

Junior Poster in Training

Offline

76 posts
since Aug 2007

Permalink

Aug 27th, 2007

Re: Runtime error :20525 unable to load the report

i was totally confused

hw can i write the connection string

hw to pass the parameter

anto_nee

Reputation Points: 12

Solved Threads: 4

Junior Poster in Training

Offline

76 posts
since Aug 2007

Permalink

Aug 27th, 2007

Re: Runtime error :20525 unable to load the report

Hi,

You cannot show it as a Seperate Window as our prev Versions, Instead U can add one More Form and a Viewer, and Call to show that form here, It would Look like a Seperate Window..

To pass Parameter:

vb Syntax (Toggle Plain Text)
m_Report.ParameterFields.Item(1).AddCurrentValue "MyParameter"
m_Report.ParameterFields.Item(1).AddCurrentValue "MyParameter"

To Change Connection :

vb Syntax (Toggle Plain Text)
dim dCon As CRAXDRT.ConnectionProperties
Set dCon =m_Report.Database.Tables.Item(1).ConnectionProperties
dCon("DSN") ="MyDSNName"
dCon("Database") ="MyDBName"
dCon("User OD") ="MyUserID"
dCon("Password") ="MyPassword"
dim dCon As CRAXDRT.ConnectionProperties
Set dCon =m_Report.Database.Tables.Item(1).ConnectionProperties
dCon("DSN") ="MyDSNName"
dCon("Database") ="MyDBName"
dCon("User OD") ="MyUserID"
dCon("Password") ="MyPassword"

Pass these before viewing the report..

REgards
Veena

QVeen72

Reputation Points: 84

Solved Threads: 140

Posting Shark

Offline

923 posts
since Nov 2006

Permalink

Aug 27th, 2007

Re: Runtime error :20525 unable to load the report

thank u

solved

fine working

veenaaaaaaa

i wont forgot u

thanks

regards
anto

anto_nee

Reputation Points: 12

Solved Threads: 4

Junior Poster in Training

Offline

76 posts
since Aug 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: RichTextBox, I need help

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: tours and travels in vb help required

DaniWeb Message

Cancel Changes

User Name
Password