Search results for query: *

I am running CR 10 against an Informix database and am attempting to generate a cross-tab report that shows totals by category by month with a corresponding percentage value that the individual category represents. However, instead of the percent being based on the sum of the seven columns that...

Crytal 10 running on an Informix database...I am basically selecting header records based on several parameters but have one parameter looking for either ALL, Y or N from a column in a detail table that is outer joined to the master table via this select statement, "(if {?image status} = "ALL"...

CR10 running under an Informix DB. I need to select all purchase order supplements for a given vendor where at least one supplement was issued during a given date range. The primary supplement table has a supp_id and a po_id for each record. I built a report with the primary supplement table...

Crystal 10 against an Informix database... I have an inventory transaction table and a work order status table where I need to show the work order status at the time of the inventory transaction. This won't necessarily be a matching date as the work orders are statused totally separate from the...

CR10 running against an Informix database... What is the select statement syntax to have a report's printdate automatically be set to the last Saturday's date regardless of which day of the week it is run on? The report is currently taking the printdate - 42 and giving a six week chart rolling...

Running CR10 and have a number of charts showing data values by week. The default layout appears to use the week beginning date on the y-axis. How do I make this display the week ending date instead? Rw

I'm running CR10 and am trying to put a suppression formula on the detail section of the report. I open the section expert, click on the suppression formula box and enter the formula, click save and exit. But if I go back into section expert, the formula is no longer there? Anyone have a...

CR10 running on an informix database... I have the following parameter on my select... ( if {?disc_code}="ALL" then true else if {?disc_code}<>"ALL" then {ap_discrep_629.discrep_cde}={?disc_code} ) The primary table is an invoice table with this parameter being directed...

Can a bar chart be constructed to show both the record count value and the representative % value of that count against the total? I'm ruuning v10 against an Informix database and am trying to display a chart showing the number of PO's that were not received by their due date verses the number...

CR 10 against an Informix database... I have a simple report with one group showing a vendor sadbus classification. There are about 8 classifications reported. I need to show the po value percentage of each classification, but instead of against the grand total, the percentage is being based...

CR 10 against an Informix database. I have a stacked bar chart showing the percent values of requisition line items by category that were converted to purchase orders within a given time frame. They are either ON TIME or PAST DUE. I see where I can control the chart to show the bar value as...

Under CE10, can an email distribution be made that will send out portions of the report based by group where the groups are specifically email addresses?

Crystal 10 against an Informix database. I have a report grouping purchasing records by the expected delivery date so that the output is grouped by LESS THAN 30 DAYS, 30-60 DAYS, 60-90 DAYS, etc. The expected delivery date is subtracted from the data date to determine which group the record...

Informix 10 on an Informix Database. I have a vendor table with ten columns that are used to denote a special classification for the vendor. Each vendor record will have a "Y" in one of these columns with the rest being null. This is in lieu of having one column with ten potential values, but...

cr10 on Informix db. I have a purchase order table where I am selecting the po number and the status of the po which is either AA, CL or CC. I also have an invoice table where a final_paid field is either Y or N. I need to show the po status as is for each po except where it might be AA and...

I'm running CR10 on an Informix database and have a line chart showing the total count of purchase orders that were CLOSED and the total count of purchase orders COMPLETED over the last 5 weeks. I have a TopN = 5 and ORDER on the date set to EVERY WEEK but the order is not consistantly going...

Running CR10 against an Informix db. I have a report designed to print vendor specific information (group header level) and requisition information (report footer level) for one or more vendors with one or more requisitions included. The report is a REQUEST FOR QUOTES document and is printed...

I am running CR10 on an Informix database. I have developed two charts, one bar and one line graph. Each chart's x-axis is a time field (same field). The bar chart shows a count of purchase orders over a period of time and the line chart shows a cumulative value of the purchase orders over a...

CR 10 on an Informix database. I have developed 6 different graphs and on some, the order of the y axis is left to right and on others it is right to left. Each one has a TopN = 6 and sort is set to ascending order. How do I control them to make them all go left to right? Thanks. Randy

Running CR10 against an informix database. What is the formula that would take two different fields from two different tables like tablea.col1 and tableb.col1 and treat them as one field. I have 3 character and 1 date field that I need to combine in order to run a simple graph. Thanks. Randy