Is there anything in the reports table for what was created?
If so, can you share the entry here?
The report builder realm may be lagging behind other application changes, so it would be curious to know.
Also, please check the server log if there might be some clue there as well.
I trust that you are well. Your response is appreciated.
This is the structure and content of the reports table. I have included the code, as I am unable to display the table in an image due to its size. I also attached the defaults.php for easy reference.
Code:
-- --------------------------------------------------------
-- Host: localhost
-- Server version: 10.4.6-MariaDB - mariadb.org binary distribution
-- Server OS: Win64
-- HeidiSQL Version: 10.2.0.5690
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- Dumping database structure for weberpdemo
CREATE DATABASE IF NOT EXISTS `weberpdemo` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `weberpdemo`;
-- Dumping structure for table weberpdemo.reports
CREATE TABLE IF NOT EXISTS `reports` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`reportname` varchar(30) NOT NULL DEFAULT '',
`reporttype` char(3) NOT NULL DEFAULT 'rpt',
`groupname` varchar(9) NOT NULL DEFAULT 'misc',
`defaultreport` enum('1','0') NOT NULL DEFAULT '0',
`papersize` varchar(15) NOT NULL DEFAULT 'A4,210,297',
`paperorientation` enum('P','L') NOT NULL DEFAULT 'P',
`margintop` int(3) NOT NULL DEFAULT 10,
`marginbottom` int(3) NOT NULL DEFAULT 10,
`marginleft` int(3) NOT NULL DEFAULT 10,
`marginright` int(3) NOT NULL DEFAULT 10,
`coynamefont` varchar(20) NOT NULL DEFAULT 'Helvetica',
`coynamefontsize` int(3) NOT NULL DEFAULT 12,
`coynamefontcolor` varchar(11) NOT NULL DEFAULT '0,0,0',
`coynamealign` enum('L','C','R') NOT NULL DEFAULT 'C',
`coynameshow` enum('1','0') NOT NULL DEFAULT '1',
`title1desc` varchar(50) NOT NULL DEFAULT '%reportname%',
`title1font` varchar(20) NOT NULL DEFAULT 'Helvetica',
`title1fontsize` int(3) NOT NULL DEFAULT 10,
`title1fontcolor` varchar(11) NOT NULL DEFAULT '0,0,0',
`title1fontalign` enum('L','C','R') NOT NULL DEFAULT 'C',
`title1show` enum('1','0') NOT NULL DEFAULT '1',
`title2desc` varchar(50) NOT NULL DEFAULT 'Report Generated %date%',
`title2font` varchar(20) NOT NULL DEFAULT 'Helvetica',
`title2fontsize` int(3) NOT NULL DEFAULT 10,
`title2fontcolor` varchar(11) NOT NULL DEFAULT '0,0,0',
`title2fontalign` enum('L','C','R') NOT NULL DEFAULT 'C',
`title2show` enum('1','0') NOT NULL DEFAULT '1',
`filterfont` varchar(10) NOT NULL DEFAULT 'Helvetica',
`filterfontsize` int(3) NOT NULL DEFAULT 8,
`filterfontcolor` varchar(11) NOT NULL DEFAULT '0,0,0',
`filterfontalign` enum('L','C','R') NOT NULL DEFAULT 'L',
`datafont` varchar(10) NOT NULL DEFAULT 'Helvetica',
`datafontsize` int(3) NOT NULL DEFAULT 10,
`datafontcolor` varchar(10) NOT NULL DEFAULT 'black',
`datafontalign` enum('L','C','R') NOT NULL DEFAULT 'L',
`totalsfont` varchar(10) NOT NULL DEFAULT 'Helvetica',
`totalsfontsize` int(3) NOT NULL DEFAULT 10,
`totalsfontcolor` varchar(11) NOT NULL DEFAULT '0,0,0',
`totalsfontalign` enum('L','C','R') NOT NULL DEFAULT 'L',
`col1width` int(3) NOT NULL DEFAULT 25,
`col2width` int(3) NOT NULL DEFAULT 25,
`col3width` int(3) NOT NULL DEFAULT 25,
`col4width` int(3) NOT NULL DEFAULT 25,
`col5width` int(3) NOT NULL DEFAULT 25,
`col6width` int(3) NOT NULL DEFAULT 25,
`col7width` int(3) NOT NULL DEFAULT 25,
`col8width` int(3) NOT NULL DEFAULT 25,
`col9width` int(3) NOT NULL DEFAULT 25,
`col10width` int(3) NOT NULL DEFAULT 25,
`col11width` int(3) NOT NULL DEFAULT 25,
`col12width` int(3) NOT NULL DEFAULT 25,
`col13width` int(3) NOT NULL DEFAULT 25,
`col14width` int(3) NOT NULL DEFAULT 25,
`col15width` int(3) NOT NULL DEFAULT 25,
`col16width` int(3) NOT NULL DEFAULT 25,
`col17width` int(3) NOT NULL DEFAULT 25,
`col18width` int(3) NOT NULL DEFAULT 25,
`col19width` int(3) NOT NULL DEFAULT 25,
`col20width` int(3) NOT NULL DEFAULT 25,
`table1` varchar(25) NOT NULL DEFAULT '',
`table2` varchar(25) DEFAULT NULL,
`table2criteria` varchar(75) DEFAULT NULL,
`table3` varchar(25) DEFAULT NULL,
`table3criteria` varchar(75) DEFAULT NULL,
`table4` varchar(25) DEFAULT NULL,
`table4criteria` varchar(75) DEFAULT NULL,
`table5` varchar(25) DEFAULT NULL,
`table5criteria` varchar(75) DEFAULT NULL,
`table6` varchar(25) DEFAULT NULL,
`table6criteria` varchar(75) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`reportname`,`groupname`)
) ENGINE=MyISAM AUTO_INCREMENT=151 DEFAULT CHARSET=utf8;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Is there anything in the reports table for what was created?
If so, can you share the entry here?
The report builder realm may be lagging behind other application changes, so it would be curious to know.
Also, please check the server log if there might be some clue there as well.
Ok, it looks like (some) things have changed (almost 2 years, based on the date of the first post), so the report builder realm is a little out-of-whack. Some references remain intact, but a couple of others are not.
(there is a code comment about it, but no change(s) have been done)
I do not have your saved report, so it won't work for me, but...
Which menu would you like your supplier list appear?
From the Main Menu, whenever you click one of the left side options, note that the URL for the ending portion looks like this: http://localhost/webERPgit/index.php?Application=stock
So in the reports table, the groupname column needs to match the portion after the Application= portion.
So, in the reports table, groupname column, change inv to stock to appear on the Inventory menu, if that's where you want it to appear, or change the utils to Utilities to appear at the Utilities menu option instead. You will have to logout/login to see if that changed because loading the report options is a one-time read as long as the session is active.
Since you have 2 entries for the SupplierList, changing both (one for stock, the other for Utilities) should make the entry available in both menus.
If it works, the item should appear at the bottom of the 2nd column of the related menu option group.
The suggestion offered did not resolve the issue. I cannot get the report to display on any Application - page. There is no error raised. It is just not visible.
Thanks again, for the help.
Regards,
(10-04-2019, 01:08 PM)TurboPT Wrote: Ok, it looks like (some) things have changed (almost 2 years, based on the date of the first post), so the report builder realm is a little out-of-whack. Some references remain intact, but a couple of others are not.
(there is a code comment about it, but no change(s) have been done)
I do not have your saved report, so it won't work for me, but...
Which menu would you like your supplier list appear?
From the Main Menu, whenever you click one of the left side options, note that the URL for the ending portion looks like this: http://localhost/webERPgit/index.php?Application=stock
So in the reports table, the groupname column needs to match the portion after the Application= portion.
So, in the reports table, groupname column, change inv to stock to appear on the Inventory menu, if that's where you want it to appear, or change the utils to Utilities to appear at the Utilities menu option instead. You will have to logout/login to see if that changed because loading the report options is a one-time read as long as the session is active.
Since you have 2 entries for the SupplierList, changing both (one for stock, the other for Utilities) should make the entry available in both menus.
If it works, the item should appear at the bottom of the 2nd column of the related menu option group.
1. First things first: previously, where I said to:
(10-04-2019, 01:08 PM)TurboPT Wrote: ... in the reports table, groupname column, change inv to stock to appear on the Inventory menu, if that's where you want it to appear, or change the utils to Utilities to appear at the Utilities menu option instead.
Scratch that, reverse and change the groupname stock back to inv, and Utilities back to utils.
2. Try the attached script below.
NOTE that after copy, do logout and login, the session handling creates the reports listing once, after login.
3. Since you have 2 entries for the SupplierList, changing both (one for inv, the other for utils) should make the entry available at both menus. If it works, the item should appear at the bottom of the 2nd column of the related menu option group. (I used your entries to check that the link(s) appear on the menu, as shown in the 2 attached images)
Let me know if this update helps.
If not, we can add one other line in the file (temporarily) to ensure that the relative session item is clobbered, but that should happen at logout.