cancel
Showing results for 
Search instead for 
Did you mean: 

RPT mostra janela de parâmetros na abertura

alair
Explorer
0 Kudos
402

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
Explorer
0 Kudos

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
Explorer
0 Kudos

... 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
Participant
0 Kudos

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
Community Manager
Community Manager

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

Kind regards,

--Jerry

Accepted Solutions (1)

Accepted Solutions (1)

ido_millet
Active Contributor
0 Kudos

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.

Answers (5)

Answers (5)

0 Kudos

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.

0 Kudos

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
Explorer
0 Kudos

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
Active Contributor
0 Kudos

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
Explorer
0 Kudos

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
Explorer
0 Kudos

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
0 Kudos

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.