vtiger Forum Index vtiger
The Honest Open Source CRM
 

Problem in reports
Click here to go to the original topic

 
       vtiger Forum Index -> Help - 5.0.3
Previous topic :: Next topic  
Author Message
nigel_r



Joined: 26 Jul 2005
Posts: 59
Location: Lancashire, UK

Posted: Thu Jun 07, 2007 9:04 am    Post subject: Problem in reports  

Hi,

I am having a problem creating Trouble Ticket Reports.

When I create a report the advanced filters are not being saved, so that the report returns all information, rather than filtering.

All the other settings such as Selected Fields, Grouping, and Standard Filters are saved.

This feature is working in the online demo.

I am logged in as admin in vtiger I have done a chmod -R 777 * on the html folder so it is not a rights issue.

This is running on CentOS 5

Any help or ideas appreciated !!

Thanks

Nigel
Back to top  
tamilmani



Joined: 04 Jun 2007
Posts: 28

Posted: Thu Jun 07, 2007 1:24 pm    Post subject: Problem in reports  

Hi,

Kindly give me the fields,conditions that you have specified in Advance Filter while creating Report.
It will be useful to debug the issue

Thanks,
R.Tamil mani.
Back to top  
Faraday G



Joined: 01 Jun 2007
Posts: 26

Posted: Fri Jun 08, 2007 2:13 am    Post subject: Problem in reports  

I also have CentOS 5 and have a similar problem to this I think.

http://forums.vtiger.com/viewtopic.php?t=14884

Just that when I try to create filters for any page, it doesnt work. I go back into the filter and the entry boxes are all blank.

I thought that CentOS would have have been one of the big Distros that VTiger was tested on. Its RHEL5. Probably one of (if not, the best) free distros around.
Back to top  
nigel_r



Joined: 26 Jul 2005
Posts: 59
Location: Lancashire, UK

Posted: Fri Jun 08, 2007 2:24 pm    Post subject: Re: Problem in reports  

Sorry for the late reply been out earning a living :(

Please see PDF for screen dumps of procedure followed and results.

Thanks

Nigel
Back to top  
nigel_r



Joined: 26 Jul 2005
Posts: 59
Location: Lancashire, UK

Posted: Thu Jun 14, 2007 10:47 am    Post subject: Re: Problem in reports  

Hi,

I managed to talk our php programmer into looking at this yesterday, and was advised that the issue appears to be caused by depreciated code being used to post the filter field input back to the database.

A quick 'n' dirty fix is to add the following 4 lines at the top of /var/www/html/index.php after the <?php line

extract($_POST);
extract($_GET);
extract($_REQUEST);
$HTTP_POST_VARS = $_POST;

see also post at http://forums.vtiger.com/viewtopic.php?p=48722



Nigel
Back to top  
 
       vtiger Forum Index -> Help - 5.0.3
Page 1 of 1


Powered by phpBB Search Engine Indexer
Powered by phpBB 2.0.15 © 2001, 2002 phpBB Group