1 (edited by jori 04/09/2011 03:42:52 pm)

Topic: Report in Excel does not start

When choosing destination excel instead of PDF/Printer, Excel doesn't pops up to show report, nothing happens? Please, indicate where to check for problems? I've been using IIS 7.5 on Windows 7 now I'm on Wampserver 2.1

2 (edited by jori 04/09/2011 09:07:36 pm)

Re: Report in Excel does not start

I think I discovered bug in v2.3.3. Something wrong in reporting folder, because I copied it from v2.3.2 to 2.3.3 and excel reporting works again, I got offered popup to save xls file.

Re: Report in Excel does not start

I think problem is in this file reports_classes.inc

Re: Report in Excel does not start

Yes you are right. We will  have a look into this.

/Joe

Re: Report in Excel does not start

Hello again. This has now been fixed. HG repository updated. Will be included in 2.3.4.

You can change the following in /reporting/includes/excel_report.inc:

Add Line 698
 
     function End($email=0, $subject=null, $myrow=null, $doctype = 0)
     {
Line 698->        global $path_to_root;
        ++$this->y;
         for ($i = 0; $i < $this->numcols; $i++)
             $this->sheet->writeBlank($this->y, $i, $this->formatFooter);
---
         }
         closedir($d);
             }
Delete line 718
Line 718->        meta_forward($_SERVER['PHP_SELF'], "xls=1&filename=$this->filename&unique=$this->unique_name");
And add instead line 718
Line 718->        meta_forward($path_to_root.'/reporting/prn_redirect.php', "xls=1&filename=$this->filename&unique=$this->unique_name");
         exit();
     }
 }

/Joe

Re: Report in Excel does not start

Thanks Joe. Did the workbooks I sent you with Georgian COA worked?

Re: Report in Excel does not start

I will have a look at it today.

/Joe