Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JamesFlowers

    creating groups based on a number passed to crystal reports by a parameter

    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...
  2. JamesFlowers

    MYSQLDUMP to XML

    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...
  3. JamesFlowers

    Export from MySQL to a XML using

    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 =...
  4. JamesFlowers

    How to suppress an entire &quot;row&quot; if one field is null?

    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...
  5. JamesFlowers

    Accountacy Period Groupings

    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
  6. JamesFlowers

    Accountacy Period Groupings

    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...
  7. JamesFlowers

    XML from PHP, how to apply the XSL

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

    XML from PHP, how to apply the XSL

    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...
  9. JamesFlowers

    Dropdown List from Database, how to pass result to second PHP page

    cheers James Flowers Crystal Consultant
  10. JamesFlowers

    Can style sheets call in html code for 'static items'

    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
  11. JamesFlowers

    Dropdown List from Database, how to pass result to second PHP page

    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...
  12. JamesFlowers

    Dropdown List from Database, how to pass result to second PHP page

    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...
  13. JamesFlowers

    Dropdown List from Database, how to pass result to second PHP page

    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
  14. JamesFlowers

    Dropdown List from Database, how to pass result to second PHP page

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

    Dropdown List from Database, how to pass result to second PHP page

    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
  16. JamesFlowers

    Dropdown List from Database, how to pass result to second PHP page

    ok , I dont mean to be rude , but my customerNames are unique...they are known in this table by a code. 'put the select in a form' What elements go here the SQL select or $dropdown? <form name="input" action="cust_detail.php" method="POST"> <input type="text" name="$dropdown"> <input...
  17. JamesFlowers

    Dropdown List from Database, how to pass result to second PHP page

    My Code (as below), connects to the DB , returns a list of customers from the table , how can I pass this to a second php page to read into a sql on that PHP to return the clients details? Many thanks James <?php $link = mysql_connect('*******') or die('Could not connect: ' . mysql_error())...
  18. JamesFlowers

    Is a count a valid SQL 'function' for PHP

    select country, count(customerNumber) Customers from customers group by country I am trying to devleop a PHP page to show the above data from a MySQL DB. each time I do a straight select , it works , but with the count, it crashes out. returning 'Parse error: syntax error, unexpected T_EXIT...
  19. JamesFlowers

    choosing max/min subtotals within a group

    hi, I have a grouping of customer that has a group within it of contract , in a contract there can be many lines. Each line contributes towards a subtotal per contract. We need to discover potential min/max revenue per customer based pn the highest and lowest value of a contract within that...
  20. JamesFlowers

    portioning days of a contract by years

    LB , undetermined at the moment , but as ever the 'design' committee are changing there minds , even after a spec doc was written for three years , so thats what I am going for at the moment , your formula worked superbly , many thanks James James Flowers Crystal Consultant

Part and Inventory Search

Back
Top