RPT mostra janela de parâmetros na abertura

[alair]

Título Original: RPT gerado a partir de uma aplicação Delphi mostra janela Diálogo de Parâmetros quando abre um viewer utilizando SDK .Net 64-bits

Possuo uma aplicação criada em Delphi que utiliza o Crystal Reports para gerar os relatórios salvando os mesmos no formato "RPT com Dados" e quando tento abrir o RPT gerado utilizando uma aplicação criada com o SDK .Net 64-bits para visualizar o relatório é mostrada a janela de Diálogo dos Parâmetros.

Esse problema não ocorre com a versão 32-bits.

Por favor, poderiam me ajudar a resolver esse problema?

-----------------------------------------------------------

Original Tittle: "RPT generated from a Delphi application shows Parameter Dialog window when opening a viewer using 64-bit .Net SDK"

I have an application created in Delphi that uses Crystal Reports to generate the reports saving them in the format "RPT with Data" and when I try to open the RPT generated using an application created with the 64-bit .Net SDK to view the report a Parameter Dialog window is shown.

This problem does not occur with the 32-bit version.

Please could you help me solve this problem?

[alair]

Seguem um print do código, outro da execução 64-bits solicitando os parâmetros...

Here is a printout of the code, another of the 64-bit execution requesting the parameters...

[alair]

... e um da execução 32-bits com o mesmo RPT sem solicitar os parâmetros.

... and one of the 32-bit execution with the same RPT without requesting the parameters.

[P2005388338]

Hi Alair

may I draw your attention to the fact that the attachment "runtime-viewer-32-bits-withoutdialogparameters.png" contains names of real companies like "THC **********" among other companies.

Regards

Abdu

[jerryjanda]

We removed the image reported for sharing private company information. Please see the comment from drasri.

Kind regards,

--Jerry

[ido_millet · Accepted solution]

If the issue is not 64-bit data connectivity, the next suspect is a UFL.
If the report uses a 32-bit User Function Library (UFL), the 64-bit runtime would choke on any formula that uses the 32-bit UFL and the saved data would be discarded.

[former_member11696]

No it's not, both use common dll's so don't mix them.

Check the Viewer Properties, ReUseParameter... should be set to false.

Change your project to X64 first.

[former_member11696]

You are mixing version, Once you upgrade to SP 32 you will see only CR for VS SP 32 installed.

Note: EXE is for your development PC, x86 and x32 is for deploying to your app server.

Likely cause is you are mixing version.

Clean up your PC, too many mixed versions installed.

[alair]

Hi Don.

Isn't it possible to coexist the 32-bit and 64-bit version of different runtimes on the same machine?

In my tests, if the 32-bit and 64-bit runtimes are of the same version, the error occurs as you mentioned, but if they are of different versions, the applications work.

[ido_millet]

The parameter dialog is probably due to having dynamic parameters that are failing to connect to the data source.
Make sure the machine has the correct 64bit data source driver.

The out of memory issue is probably a different issue.
Test the effect of resizing the image outside Crystal -- not inside Crystal.

[alair]

Hi Ido, how are you?

In both the main report and the subreports, the parameters are static.

The problem is in the 64-bit runtime.

In the 32-bit version, it opens the RPT with data normally without displaying the parameter window.

[alair]

Olá Don, como vai?

Obrigado pelo retorno, porém, o problema da janela de parâmetros não ocorre usando a versão do Runtime 32-bits.

Testei a compilação de um visualizador de 64-bit pro Crystal usando várias versões dos Runtimes disponíveis no site da SAP e sempre apresenta a tela de diálogo dos parâmetros na abertura de alguns RPT salvos com dados.

Essa é a lista do que tem de Crystal instalado no computador:

• Crystal Reports XI Release 2 - 11.5.10.1263
• Crystal Reports XI R2 Service Pack 6 - 11.5.12.1838
• Crystal Reports XI Release 2 .NET 2005 Server - 11.5.0.0
• SAP Crystal Reports runtime engine for .NET Framework (32-bit) - 13.0.25.3158
• SAP Crystal Reports runtime engine for .NET Framework (64-bit) - 13.0.31.4010
• Visualizador do SAP Crystal Reports 2020 SP1 - 14.3.1.3701

Se tento abrir o RPT gerado pelo Visualizador do SAP, mostra a mensagem de que o RPT não foi salvo com dados.

Se tento abrir o RPT gerado pela aplicação compilada em 64-bit, apresenta a janela de parâmetros.

Se tento abrir o RPT gerado pela aplicação compilada em 32-bit, abre normalmente. Porém, se o RPT tiver muitas páginas, mais de 60 e utilizar alguma imagem no cabeçalho de 32x32 pixels, ocorre erro de memória insuficiente.

A configuração do computador onde estou testando é :

• Core i7 16Gb RAM 240Gb SSD + 1Tb HDD e GPU NVidia Windows 10 Pro 21H1
• Visual Studio 2019

------------------------

Hi Don, how are you?

Thanks for the feedback, however, the parameter window problem does not occur using the 32-bit Runtime version.

I have tested compiling a 64-bit pro Crystal viewer using several versions of the Runtimes available on the SAP website and it always shows the parameters dialog screen when opening some RPT saved with data.

This is the list of what Crystal is installed on your computer:

• Crystal Reports XI Release 2 - 11.5.10.1263
• Crystal Reports XI R2 Service Pack 6 - 11.5.12.1838
• Crystal Reports XI Release 2 .NET 2005 Server - 11.5.0.0
• SAP Crystal Reports runtime engine for .NET Framework (32-bit) - 13.0.25.3158
• SAP Crystal Reports runtime engine for .NET Framework (64-bit) - 13.0.31.4010
• SAP Crystal Reports 2020 SP1 viewer - 14.3.1.3701

If I try to open the RPT generated from the SAP Viewer, it displays the message that the RPT has not been saved with data.

If I try to open the RPT generated by the 64-bit compiled application, it displays the parameters window.

If I try to open the RPT generated by the 32-bit compiled application, it opens normally. However, if the RPT has many pages, more than 60 and uses some image in the header of 32x32 pixels, it gets an insufficient memory error.

The configuration of the computer where I am testing is :

• Core i7 16Gb RAM 240Gb SSD + 1Tb HDD and NVidia GPU Windows 10 Pro 21H1
• Visual Studio 2019

[former_member11696]

What SP are you using?

Get SP 32 from here:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

At some point, I forget which SP it was, you now must log onto the DB before setting the Parameters.

If the report is based on a Stored procedure that's a must.

And if the log on fails or there are missing parameters it will prompt you for them.

Or if you are using an old SP tht used Flash to handle CR Parameters then due to flash being deprecated and likely removed it can cause the parameter UI to fail, we ow use HTML5 to prompt.