Unable to preview a report that uses two subreport on non development machine

I have created my reports using ttx file. The main report uses 2 subreports. The subreports have same linking parameter (StationId). I pass data to report using ADO Recordset. The reports work fine on a development machine with crystal report XI installed on them, however, it fails on a test (deployment) machine (both win 2k professional and WinXP). All other reports that do not have subreports work fine everywhere.
I am not sure if there is a problem with the report or I am not ditributing right files?
Do I need to distribute additional file for subreports?

I include following merge module in my installshield program (Installshield Express XI):
CR_11_License ver 1.0
CR_11_reprtengine ver 1.0
CR_11_rdc_runtime ver 1.0.


Here is the code that passes data to the report
(the first field of all the recordset is StationId)
m_objReport is defined as ICRDesigner
objRsMainReportData is defined as Recordset
objRsSubReport1Data is defined as Recordset
objRsSubReport2Data is defined as Recordset
 
Dim objReportUnit As CRAXDRT.Report
Dim objReportHW As CRAXDRT.Report
 
    m_objReport.Database.SetDataSource objRsMainReportData
 
    If Not objRsSubReport1Data Is Nothing Then
        Set objReportUnit = m_objReport.OpenSubreport(m_objReport.Subreport1.SubreportName)
        objReportUnit.Database.SetDataSource objRsSubReport1Data
    End If
    If Not objRsSubReport2Data Is Nothing Then
        Set objReportHW = m_objReport.OpenSubreport(m_objReport.Subreport2.SubreportName)
        objReportHW.Database.SetDataSource objRsSubReport2Data
    End If

Open in new window

nbandariAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
I am not aware of additional dlls that are needed for subreports.

Do you have VERIFY DATABASE ON OPEN set for the subreports?
Check the FILE --> REPORT OPTIONS on the subreports.
Also check the subreport linking to see if it is there.

Check if you have REIMPORT SUBREPORT checked on the subreport linking?

It sounds like either the subreport is trying to hit the database or the subreport doesn't exist on the nondevelopment environment.

mlmcc
0
nbandariAuthor Commented:
1)Do you have VERIFY DATABASE ON OPEN set for the subreports?
Check the FILE --> REPORT OPTIONS on the subreports.
I have VERIFYONEVERYPRINT set in my CRDesigner

I cant find  " VERIFY DATABASE ON OPEN " option in the report option, however, "Verify on first refresh" is set on main reports and subreports.

2)Also check the subreport linking to see if it is there.
The linking is ther

3) Check if you have REIMPORT SUBREPORT checked on the subreport linking
There is no such "REIMPORT SUBREPORT", however, there is a command with this name.

4)It sounds like either the subreport is trying to hit the database or the subreport doesn't exist on the nondevelopment environment.

I do not copy the report to nondevelopment environment.

nbandari

0
nbandariAuthor Commented:
I have found the problem. When I was creating my recordsets I was using a wrong attribute for fields that where varchar. For some reason this was working in development machines and not on test machines.
0
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.