Help about CR XI R2 with VB6.0

[Former Member]

Hi,

I'm trying to do a viewer of CR XI R2 for my report. I'm testing the new version of Crystal Report (XI Release 2) and I'm having problem using dynamic parameter when I try to open the report from VB6.

In my computer I have installed VB6 and Crystal Report XI R2 and everything works fine, but when I try to test my little program in other PC, don't work.

In others computers I installed the merge RDC modules for CR XI R2. I created an MSI installer for that with Visual Studio Installer.

When I open for example one report that contain one table and one dynamic paramater with one field of the table the following error appear:

'List of Values failure: fail to get values. [Cause of error. The Report Application Server failed]'. Error source: prompt.dll. Error code: 0x8004380D

In my computer (with VB and CR XI installed) everything works.

Here you have the code that I'm using:

[BEGIN]

Dim crApp As New CRAXDRT.Application

Dim crReport As CRAXDRT.Report

Set crReport = crApp.OpenReport(mPathRep & "\" & mReportSeleccionado)

crReport.Database.LogOnServer "pdsodbc.dll", mDSN, mDataBase, mUser, LCase(mPassWord)

crReport.EnableAsyncQuery = True

crReport.EnableSelectDistinctRecords = True

crReport.DiscardSavedData

Me.CR.ReportSource = crReport

For x = 1 To crReport.Database.Tables.Count

crReport.Database.Tables.Item(x).ConnectionProperties.DeleteAll

crReport.Database.Tables.Item(x).ConnectionProperties.Add "DSN", mDSN

crReport.Database.Tables.Item(x).ConnectionProperties.Add "Database", mDataBase

crReport.Database.Tables.Item(x).ConnectionProperties.Add "User ID", mUser

crReport.Database.Tables.Item(x).ConnectionProperties.Add "Password", mPassWord

crReport.Database.Tables.Item(x).ConnectionProperties.Add "UseDSNProperties", True

Next x

Me.CR.ViewReport

Me.CR.Zoom 100

[END]

Please, somebody can help me? I search a lot but nobody can help me.

Thanks for all and best regards,

[Former Member · Accepted solution]

Hi,

Thanks for your help. I test the modules.exe program and changed the DLLs files that was different, but I have the same problem when I use dynamic parameters.

Any ideas?

Thanks and best regards.

[former_member11696]

RDC does not support Dynamic parameters, old technology that was not updated since version 9

[Former Member]

I found you problem, while looking other,..

=> try it with

crReport.EnableAsyncQuery = True

=> setting after opening the report