Search results for query: *

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

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

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

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

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())...

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

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

hi, I have a set of data that has a start_date end_date Value_of_Contract I am looking to place the length of the reports in days in each yearly buucket and then assign that percentage of days in the year to the value. eg 31/06/2012 to 30/09/2013 Val =1000000 how many days in 2011 , 2012...

hi. I have a recordset that needs to suppress data based upon a line in the database. Normally, I would group by the description. but in this case the data is entered in by hand as below; This quote is for the labour listed below. null Engineering Eng Rate 0 Engineering...

Hi, I have a dataset that has a part number and a date part date 1 01/01/2005 1 01/02/2005 1 01/03/2005 this date is the "phase in" date, and I want to constrct a "phase out" date using the next line date-1 to create the range and adding sysdate as the last date...

I have a range of dates in a database with {startdate} - {enddate} and I want to find out any of the intervening dates within this range within greater date range that is passed by a CR eg 10/7/2004 - 12/12/2004. Is this possible? TIA James James Flowers Crystal Consultant

Hi, I am trying to extract to a cross tab, the amount of months left on a project, and pass to that cross tab a set figure for each month. months left figure 3 3.7 5 34.7 7 23.0 I think I want to create an array to show 1 2 3 3.7 3.7 3.7 1 2...

I have a timesheet looking like this Start End Hours Saturday 22:00 06:00 8.00 Sunday 01:00 08:00 7:00 Monday 10:00 17:30 9.00 I am trying to extrapolte from these ranges if a time epriod enters a specfic time range eg 00:00 to 04:00 and then 04:00 to...

Using 8.5 I have a set of data that shows calls answered over a period of time (months) and the percentage of those calls fixed. What we need to see is the number of calls as a bar chart and percentage fixed as a line on the same chart. We can get them to be both line graphs (but this is...

In the string below I have a number &quot;242&quot; InfoService.QuickReportStart(SalNumberToStrX(242,0)||'@CONSIGNMENTID='||hWndForm.frmConsignment.ecmbnConsignmentId.i_sMyValue) I am trying to get this number on its own to link it to another field. I cant substring as there might be a...

Hello all, I am trying to run a CR from within an ERP system, we want the Report to accept a parameter(s), and then print direct to a label printer without having to actually see the report run. I know I can schedule reports in Enterprise et al, but is there a &quot;direct print&quot; option...

Hi, I am creating a macro to automatically save the workbook to a file with the sysdate and time. Here is the code ActiveWorkbook.SaveAs Filename:= _ &quot;C:\Documents and Settings\james_f\Desktop\Product List Requests Sheet.xls&quot;, _ FileFormat:=xlNormal...

Hi, Im a total XML newbie and I have been given a sheet of generated XML from a Crystal Report that needs to be put on the web. Are there any programs that anyone knows of that will &quot;read&quot; a XML document and create a stylesheet from this? Many Regards James Flowers James Flowers...