Search results for query: *

We recently went thru an ERP upgrade that forced us to upgrade all of our existing CR8.5 reports to CR10. Many of these reports are exported to Excel for further manipulation. With CR8.5 we had the ability to select a specific Excel version - and the export worked fine. However with...

Thanks for the reply - some additional info: MaxOnHand (formula field) captures the maximum inventory for an item (aggregate by part by date). This field will not change from date to date within a part - only across parts. SumNeedQty (formula field) determines the amount of inventory needed...

I'm using Crystal 8.5 against an Oracle database and have never done anything with subtotals other than display them. Now I need to use some comparision logic to compare the sum of one field at the date level (group) vs the max of another field at the date level. The comparison will be used...

In addition to your point about displaying A after the subreports are run - it should be pointed out that in the case where we would not want to display A if the calculation results a particular way - we ALSO would not want to display B,C, OR D in that case as well. It is a clear case of...

One MAJOR clarification - the subreports B,C,D called by main report A are run after the data in A is displayed. Being that as the case - will the previous suggestions still apply? Thanks in advance!

To clarify - all of the subreports are currently stemming from the main report. So A calls B,C,D. This is done because B,C,D are all pulled from different tables. How does the supression know to do suppress after vs before? Thanks in advance.

thanks for the reply - but you lost me on how to suppress in main report. Is there more than one detail section in the main report to pull this off?

Crystal Reports 8.5 on Oracle Table A has inventory and is main table of report Table B,C,D are accessed via subreports and display information about what is needed vs what is scheduled. Subreports B,C,D all drive to a total per subreport that is displayed in the main report. HOWEVER - to...

Does the functionality of MINUS only use the 1st table as the reference point? what if there are rows in the 2nd table that are not in the 1st table? Does MINUS not care about those rows? I'm hoping to give this a try this AM to see if it gets me close to where I need to be.

I'm using Crystal 8.5 against an Oracle database. I'm trying to improve the integrity of two like tables in our system - but in order to do so need to look for occurrences between two tables where there is not a match on part number. In other words Table A has Part A Part B Part C...

The question posed was against three different data sets which can all be joined by part number and cost center. Main Data Set: Inventory 1st Join Table: Schedule 2nd Join Table: Messages If there is a record in either join table (or both) then the inventory record should be shown...

I'm using Crystal 8.5 against an Oracle DB and am wondering what the best way is to accomplish the following is Pull inventory for items that either a) have a schedule against them b) have messages against them (MRP) then show the schedules and/or MRP messages a) and b) are independent of...