Recent content by JamesFlowers

I have to create a report that has to be printed x times , but each time a 'new' report has to be printed , a different header is printed based on the number passed in by a paramter ie param =2 group 1 is called client copy (is easy bit if then else statement) group 2 is called customs copy...

Hi , I am currently in the middle of a ERP design , and we are using a MYSQL backend , with PHP. We have a requirement to provide XML outputs of the screens seen from certain screens so the data can be loaded into Excel and also into a clients system (they have specifed XML output). So we have...

Hi , I am trying to export from MySQL to a XML using code below , and it returns "Warning: SimpleXMLElement::addChild() [simplexmlelement.addchild]: unterminated entity reference on line 20" any ideas please? TIA <?php //Create Database connection $db =...

I would create two groups , create a formula , as PeterDimitrov's suggestion ISNULL(<emailfield>) OR <emailfield><>"" then group by this to show Smith Company John Smith 555-123-4567 President PresidentJohn@SmithCo.com 1/1/1999 Jacob Smith 555-123-4567 Sales Mgr...

I have mooted this point with our developers , but they want to do it in the CR as we have to pay for all alterations done on the db by the vendors :( James Flowers Crystal Consultant

hi I have a date formula made from if {condition}='OPEN' then {instr_date} else if {condition}='CLOSED' then {close_date) this gets me a single date in a report that a report is either opened or closed on. But when I go to group the dates , it has to be in line with our accountacy year...

The php.net pages are more about using XML as a datasource not an output. James Flowers Crystal Consultant

I have the code as below , but I cant work out how to apply the XSL file for formatting? Any ideas, Thanks. <?php header("Content-Type: text/xml"); //set the content type to xml?> <?php include 'dbconn.php'; // database Conn?> <?php include 'sql.php'; // SQL?> <?php $xmlBody = '<?xml...

cheers James Flowers Crystal Consultant

hi I am creating a site that uses a logo placed in the top left corner , and has a title bar. can this be called in as a code via the style sheet so I can have just one file with logo and title in the center, and bring it in ? thanks James James Flowers Crystal Consultant

select c.cust_id,c.customername , c.address, c.details , o.order, o.date, o.product, o.value from customer c , order o where c.cust_id =o.cust_id so the array that is created above Array ( [customername] => 293 is to be passed to the c.cust_id as a parameter which I can then place in a table...

This passes all customer details and format them using css and div tags as a display screen , and then use the customer number (which I have now been told there is one) to pull up there orders below that name xxxx address xxxx details xxxx order date product value xxxx xxxx xxxxxx xxxx...

Cool thanks that worked :) it is printing as Array ( [customername] => 293 ) how can this be utilised further , can you point to any examples on the web please? James James Flowers Crystal Consultant

and so what is %s then please? James Flowers Crystal Consultant

In the above somepage.php the ($_POST['user'])): is declared where is 'user' defined in the <form method> php file ? how is this variable passed to the sql statement in the somepage.php thanks James Flowers Crystal Consultant