Xailer2 with FastReport

[Pedro Sousa e Faro]

Hi
Since we convert our Xailer 1.99 App to Xailer 2.0 , we have been
experienced a small problem with our Report Generator(fastReport).
In the report designer , the First Time we preview the report we see the
data . The second Time we preview the report , it shows no data.
"Fast Report " support said's that the problem could be that queries may
be " not unidirectional".
The same reports/FR version works fine in Xailer 1.99
Anyone has experienced this problem ?.
Best regards.
Pedro Faro

[Bingen Ugaldebere]

Have you upgraded your FastReport, you need a new version to run with
Xailer 2.0.
Actually last version is 4.9.13
Regards

[Bingen Ugaldebere]

Have you upgraded your FastReport, you need a new version to run with
Xailer 2.0.
Actually last version is 4.9.13
Regards

[Pedro Sousa e Faro]

Hi Bingen
We actually use FR 4.9.13 , and works ok in Xailer 1.9 and have the problem
in Xailer 2.
The answer of FR support :
Any query(cursor) at any SQL-servers is unidirectional.
Client-side datasets caches data and makes possible bidirectional
operation like Skip(-1), GoTop() around its cache.
But for best perfomance, in any other langs (Delphi, C etc)
datasets has property "Unidirectional". If .T., datasets cache
contain only one current record.
In general, all looks like that :GoTop() do not work at your
dataset in Xailer2.
Regards
Pedro
"Bingen Ugaldebere" <bingen@bisoft.com> escreveu na mensagem
news:4b7bb62d$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Have you upgraded your FastReport, you need a new version to run with
> Xailer 2.0.
>
> Actually last version is 4.9.13
>
> Regards
>

[Pedro Sousa e Faro]

Hi Bingen
We actually use FR 4.9.13 , and works ok in Xailer 1.9 and have the problem
in Xailer 2.
The answer of FR support :
Any query(cursor) at any SQL-servers is unidirectional.
Client-side datasets caches data and makes possible bidirectional
operation like Skip(-1), GoTop() around its cache.
But for best perfomance, in any other langs (Delphi, C etc)
datasets has property "Unidirectional". If .T., datasets cache
contain only one current record.
In general, all looks like that :GoTop() do not work at your
dataset in Xailer2.
Regards
Pedro
"Bingen Ugaldebere" <bingen@bisoft.com> escreveu na mensagem
news:4b7bb62d$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Have you upgraded your FastReport, you need a new version to run with
> Xailer 2.0.
>
> Actually last version is 4.9.13
>
> Regards
>

[ignacio]

Pedro,
If you are using ADO, check the property nCursorType. I suggest you use a
adOpenStatic value.
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
noticias:[email=4b7b209d@svctag-j7w3v3j....]4b7b209d@svctag-j7w3v3j....[/email]
> Hi
>
> Since we convert our Xailer 1.99 App to Xailer 2.0 , we have been
> experienced a small problem with our Report Generator(fastReport).
>
> In the report designer , the First Time we preview the report we see the
> data . The second Time we preview the report , it shows no data.
>
> "Fast Report " support said's that the problem could be that queries
> may be " not unidirectional".
>
> The same reports/FR version works fine in Xailer 1.99
>
>
> Anyone has experienced this problem ?.
>
> Best regards.
> Pedro Faro
>
>
>

[ignacio]

Pedro,
If you are using ADO, check the property nCursorType. I suggest you use a
adOpenStatic value.
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
noticias:[email=4b7b209d@svctag-j7w3v3j....]4b7b209d@svctag-j7w3v3j....[/email]
> Hi
>
> Since we convert our Xailer 1.99 App to Xailer 2.0 , we have been
> experienced a small problem with our Report Generator(fastReport).
>
> In the report designer , the First Time we preview the report we see the
> data . The second Time we preview the report , it shows no data.
>
> "Fast Report " support said's that the problem could be that queries
> may be " not unidirectional".
>
> The same reports/FR version works fine in Xailer 1.99
>
>
> Anyone has experienced this problem ?.
>
> Best regards.
> Pedro Faro
>
>
>

[Pedro Sousa e Faro]

Hi Ignacio,
Yes. I use ADO.
I never change this value, i think it's the default.
The problem with FR is related with a possible change from 1.99 to 2.x in
Datasets with codeBlocks.
Regards.
Pedro Faro.
"Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> escreveu na
mensagem news:4b7c0839$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Pedro,
>
> If you are using ADO, check the property nCursorType. I suggest you use a
> adOpenStatic value.
>
> Regards,
>
> --
> Ignacio Ortiz de Zúñiga
> [Equipo de Xailer/Xailer team]
> http://www.xailer.com
> http://www.xailer.info
>
> "Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
> noticias:[email=4b7b209d@svctag-j7w3v3j....]4b7b209d@svctag-j7w3v3j....[/email]
>> Hi
>>
>> Since we convert our Xailer 1.99 App to Xailer 2.0 , we have been
>> experienced a small problem with our Report Generator(fastReport).
>>
>> In the report designer , the First Time we preview the report we see the
>> data . The second Time we preview the report , it shows no data.
>>
>> "Fast Report " support said's that the problem could be that queries
>> may be " not unidirectional".
>>
>> The same reports/FR version works fine in Xailer 1.99
>>
>>
>> Anyone has experienced this problem ?.
>>
>> Best regards.
>> Pedro Faro
>>
>>
>>
>

[Pedro Sousa e Faro]

Hi Ignacio,
Yes. I use ADO.
I never change this value, i think it's the default.
The problem with FR is related with a possible change from 1.99 to 2.x in
Datasets with codeBlocks.
Regards.
Pedro Faro.
"Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> escreveu na
mensagem news:4b7c0839$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Pedro,
>
> If you are using ADO, check the property nCursorType. I suggest you use a
> adOpenStatic value.
>
> Regards,
>
> --
> Ignacio Ortiz de Zúñiga
> [Equipo de Xailer/Xailer team]
> http://www.xailer.com
> http://www.xailer.info
>
> "Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
> noticias:[email=4b7b209d@svctag-j7w3v3j....]4b7b209d@svctag-j7w3v3j....[/email]
>> Hi
>>
>> Since we convert our Xailer 1.99 App to Xailer 2.0 , we have been
>> experienced a small problem with our Report Generator(fastReport).
>>
>> In the report designer , the First Time we preview the report we see the
>> data . The second Time we preview the report , it shows no data.
>>
>> "Fast Report " support said's that the problem could be that queries
>> may be " not unidirectional".
>>
>> The same reports/FR version works fine in Xailer 1.99
>>
>>
>> Anyone has experienced this problem ?.
>>
>> Best regards.
>> Pedro Faro
>>
>>
>>
>

[ignacio]

Pedro,
Try to isolate the problem with a sample without using FR. TIA.
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
noticias:4b7c5db4$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Hi Ignacio,
>
> Yes. I use ADO.
> I never change this value, i think it's the default.
>
> The problem with FR is related with a possible change from 1.99 to 2.x in
> Datasets with codeBlocks.
>
> Regards.
> Pedro Faro.
>
>
> "Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> escreveu na
> mensagem news:4b7c0839$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>> Pedro,
>>
>> If you are using ADO, check the property nCursorType. I suggest you use a
>> adOpenStatic value.
>>
>> Regards,
>>
>> --
>> Ignacio Ortiz de Zúñiga
>> [Equipo de Xailer/Xailer team]
>> http://www.xailer.com
>> http://www.xailer.info
>>
>> "Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
>> noticias:[email=4b7b209d@svctag-j7w3v3j....]4b7b209d@svctag-j7w3v3j....[/email]
>>> Hi
>>>
>>> Since we convert our Xailer 1.99 App to Xailer 2.0 , we have been
>>> experienced a small problem with our Report Generator(fastReport).
>>>
>>> In the report designer , the First Time we preview the report we see the
>>> data . The second Time we preview the report , it shows no data.
>>>
>>> "Fast Report " support said's that the problem could be that queries
>>> may be " not unidirectional".
>>>
>>> The same reports/FR version works fine in Xailer 1.99
>>>
>>>
>>> Anyone has experienced this problem ?.
>>>
>>> Best regards.
>>> Pedro Faro
>>>
>>>
>>>
>>
>
>

[ignacio]

Pedro,
Try to isolate the problem with a sample without using FR. TIA.
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
noticias:4b7c5db4$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Hi Ignacio,
>
> Yes. I use ADO.
> I never change this value, i think it's the default.
>
> The problem with FR is related with a possible change from 1.99 to 2.x in
> Datasets with codeBlocks.
>
> Regards.
> Pedro Faro.
>
>
> "Ignacio Ortiz de Zúñiga" <NoNameToAvoidSpam@xailer.com> escreveu na
> mensagem news:4b7c0839$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>> Pedro,
>>
>> If you are using ADO, check the property nCursorType. I suggest you use a
>> adOpenStatic value.
>>
>> Regards,
>>
>> --
>> Ignacio Ortiz de Zúñiga
>> [Equipo de Xailer/Xailer team]
>> http://www.xailer.com
>> http://www.xailer.info
>>
>> "Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
>> noticias:[email=4b7b209d@svctag-j7w3v3j....]4b7b209d@svctag-j7w3v3j....[/email]
>>> Hi
>>>
>>> Since we convert our Xailer 1.99 App to Xailer 2.0 , we have been
>>> experienced a small problem with our Report Generator(fastReport).
>>>
>>> In the report designer , the First Time we preview the report we see the
>>> data . The second Time we preview the report , it shows no data.
>>>
>>> "Fast Report " support said's that the problem could be that queries
>>> may be " not unidirectional".
>>>
>>> The same reports/FR version works fine in Xailer 1.99
>>>
>>>
>>> Anyone has experienced this problem ?.
>>>
>>> Best regards.
>>> Pedro Faro
>>>
>>>
>>>
>>
>
>