mone_willo
Posts: 6
|
| Posted: 04/08/2008, 2:15 PM |
|
Hello ,
I have a web app which features customized screens that generate reports . It appears that codecharge 2.0.5 was used to develop these report screens....the problem is... I encounter an error whenever I try to generate reports with huge/long/large outputs...the browser just hangs for hours , sometimes the output is shown onscreen but the print window hangs both in Mozilla Firefox 2.0.0.13 and in IE.
Can someone please shed some light on this issue ?
Thanks. I would really appreciate your help.
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 04/08/2008, 9:38 PM |
|
mone_willo
We need some more information......
What database are you using??
How many records are you querying??
Have you tested your query in the database to see if it is working correctly??
Has this report ever worked correctly??
Have you considered upgrading to the newest version of CCS??
|
|
|
|
mone_willo
Posts: 6
|
| Posted: 04/09/2008, 5:47 AM |
|
hello mambo
What database are you using?? ans: mysql
How many records are you querying?? ans: over 200 records, this query is a Join statement with resulting records comin from varied db tables.
Have you tested your query in the database to see if it is working correctly?? ans: yes it works...infact the result output onscreen..it just takes about 20 min to do so. the problem is the browser hangs when trying to print the report.
Has this report ever worked correctly?? ans: no never been able to print this report as the browser hangs when trying to print .
Have you considered upgrading to the newest version of CCS?? ans: I would be interested if this will resolve the problem..could you enlighten me please?
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 04/09/2008, 4:28 PM |
|
mone_willo
What version of MySQL are you using?
Did you say that the output screen takes 20 minutes?? If this is true then we need to look more at your tables (assuming that they have indexes) and how your query is written. Is it possible to get more information on the tables involved in the query as well as the query iteself. 20 minutes for 200 records is wwwwaaaaaayyyyyyy to long. Are you outputting the records in a pdf file or as a screen output?
|
|
|
|
mone_willo
Posts: 6
|
| Posted: 04/11/2008, 7:04 AM |
|
yes mamboBrown the report takes over 20 min to generate an output .... I sent u a PM ..i'm awaiting your reply. Note the report outputs onscreen .
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 04/11/2008, 8:11 AM |
|
mone_willo
I sent a reply to your pm. I look forward to hearing from you. Hopefully, I can help you out.
|
|
|
|
mone_willo
Posts: 6
|
| Posted: 04/11/2008, 9:00 AM |
|
mamboBrown, i PM'ed u again . I sure hope you can help us out. Thnx
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 04/11/2008, 9:36 AM |
|
I sent a reply.
|
|
|
|
mone_willo
Posts: 6
|
| Posted: 04/11/2008, 10:03 AM |
|
hello mamboBrown, just wanted to know if u got my reply... wanted to know what browser you used to test app?
and also did you try printing..if so did you encounter any problems such as the browser print window hangs or print takes long (hrs) to start?
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 04/11/2008, 1:42 PM |
|
mone_willo
I got your reply. I had to step out for a few moments. You should have my reply.
|
|
|
|
mone_willo
Posts: 6
|
| Posted: 04/14/2008, 12:02 PM |
|
Hello mambobrown ..any luck ?
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 04/15/2008, 7:03 PM |
|
mone_willo
I'm still looking into it...I will get back to you as soon as I can.
|
|
|
|
