Print Report Only works when Pressed second time . NT 5 PR26

[britech]

Please see image. I have fought with this for 3 days and after an enormous number of iterations , I am now of the belief that there is a problem calling the Report on the first print. If I press the Print button a second time, without changing a single thing, the report prints fine.

Why must I print the Report twice to get rid of the  PAGE Cannot be Found, error.

I have built and rebuilt this report so many times, I'm about to tell the client they just have to Press the Print button twice.

Has anyone else seen this problem?  

Brian

NT5 PR26
6.3 9055

[attachment deleted by admin]

[Bruce]

Hi Brian,

first thing to try is one of the reports examples.
Just to make sure it's not something in your browser.

Second thing - if the app is tps based, zip & email to me so I can have a look.

cheers
Bruce

[britech]

Hi Bruce,
Unfortunately it's SQL based , but it happens in Both IE and FireFox.
I'll see if I can duplicate it in a smaller app and send it to you.
This only happens on Reports with long filters.

ie      Fil:field1 = LOC:Field1 and Fil:Date >= LOC:StartDate and Fil:Date <= LOC:EndDate

I can re-arrange  the 3 conditions forwards and backwards,

ie  Fil:Date <=LOC:EndDate and Fil:Field1 = LOC:Field1  and  Fil:Date  <= LOC:StartDate

and it will still work on the second pressing of PRINT


Now the weird part. If I only include two conditions in the filter (any Two) the Reports prints every time on JUST ONE click of the Print Button, and no Page CANNOT BE FOUND error on that first click.

After that Initial PRINT (and error) , the second, 3rd, 4th, attempt will always work, even as I'm changing the date filter parameters. It is only thet FIRST attempt with a 3 condition filter that it chokes.

It's almost as though it has to go through the Report Process once to capture the last part of a 3 part  filter because the order of the condition in the filter doesn't seem to matter, just that there are more than two conditions.

Brian

[britech]

Hi Bruce,

I modified the report in example Web13.app , to include a SQL table (orders) and applied a filter to it.
On the first Print, it says No Records.
If we hit Print the second time, we get the correct report with the correct filtered records.
I have sent the  app by way of email to your attention.
Thanks in advance.
Brian