Recent content by koolskins

Thanks lbass. That's just what I needed.

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

Thanks, that seems to have fixed the problem. RW

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

Thanks guys. The combined select and group select statement gave me exactly what I needed. As always, really appreciate the assistance. Have a nice day. Rw

The work order status date isn't necessarily the maximum date. An inventory item might have been updated on 2/21/07, but the work order statuses change on a completely different event driven cycle so that the work order may have had different statuses on 1/21/07, 2/07/07, 2/28/07, etc. In this...

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

Crystal 10 against an Informix database... I have an inventory table with return transactions by date and a workorder status table where the workorder status is maintained by date. I am trying to show what the workorder status was at the time of the inventory transaction??? inventory...

Thanks guys. You got me pointed in the right direction. Much appreciated. R.

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

Thanks. Rw

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

No, just one detail section. It's not just the formula either, if I check the suppress box, it does the same thing; disappears as soon as I save it. The report will refresh with the suppression formula, but if I refresh it again, it reverts back to the original format. R

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