jana Posted October 9, 2006 Share Posted October 9, 2006 How to generate reports by getting the data from mysql? any idea Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/ Share on other sites More sharing options...
AndyB Posted October 9, 2006 Share Posted October 9, 2006 The question is too non-specific for anything other than a general answer.1. Retrieve the information you want to display (SELECT query, etc.)2. Loop through the retrieved information and display it as you see fit Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106173 Share on other sites More sharing options...
brown2005 Posted October 9, 2006 Share Posted October 9, 2006 can u post the table structure and what sort of report u want? Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106174 Share on other sites More sharing options...
jana Posted October 9, 2006 Author Share Posted October 9, 2006 i hav a table emp_master as emp_idemp_nametittlesexdept_idactiveand i want a report in a a4 paper who are all active. Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106198 Share on other sites More sharing options...
AndyB Posted October 9, 2006 Share Posted October 9, 2006 [code]$query = "SELECT * from emp_master WHERE active = 'something that means active'";[/code]And how your report will look when printed depends on your printer settings, i.e. nothing to do with php. Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106202 Share on other sites More sharing options...
jana Posted October 10, 2006 Author Share Posted October 10, 2006 can i integrate crystal reports with php and mysql? Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106633 Share on other sites More sharing options...
php_coder_dvo Posted October 10, 2006 Share Posted October 10, 2006 [quote author=jana link=topic=110938.msg449643#msg449643 date=1160456306]can i integrate crystal reports with php and mysql?[/quote]No.... I dont think so, why not format your page in a descent view... Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106649 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.