I tried this using the non-embedded Crystal Reports and it appears to work fine. I haven't used the embedded CR, but I'm assuming it's the same, just the data access is different.
When you link the tables, be sure to link from F4801 to F0101 (not the other way around). Make the join a Left...
No problem, Clooney1. Hope you enjoyed your vacation. That return groove can get a little bumpy!
To answer your question, we used our existing BO Crystal Enterprise installation and a number of Crystal Reports licenses for report developers. The downside is that Crystal Enterprise resides on...
Thanks, synapsevampire, for your response. I'm glad I seem to be on the right track, anyway.
This report uses data from J D Edwards Enterprise One v8.11. The actual formulas I posted use this field:
CAST("F00165"."GDTXFT",varchar2(1000))
In the CR Field Explorer, this field is identified as...
Are you using the integrated Crystal Reports from PeopleSoft, or the Business Objects independent version and Crystal Enterprise? We have written hundreds of reports using numerous joins from Business Objects CE10 against PeopleSoft E1, with no effect on the application at all.
Could you...
Tech Info:
Crystal Reports 10
Oracle 9.2.06
Connectivity: native Oracle 9.0.1.1.1
I've read through all the posts regarding this issue but haven't found a solution. I am attempting to place a BLOB field from an ERP system into a Crystal Report.
I have a main report which includes a formula...
Thank you, lbass. This was an interesting idea I had to think through several times. However, I think I'm still not explaining the situation correctly.
The calculations I need to do on each order will give me the date the order will begin on a machine. Basically we need to calculate and...
Maybe I'm beginning to see the light. I can see that your solution would work fine, IF I can get the output from each line of the main report into the subreport. If I were only calculating the date for a single order in the main report, that could be used in the report footer subreport. But I...
Thanks, Turkbear. I was thinking that wouldn't work because the sort for the second report is completely different from the one in the first report. I really just need certain data that I can rearrange in the second report, combined with additional data from the Oracle db.
Maybe I'm...
I have one report that uses complicated calculations and a specific sort to come up with the date each upcoming shop floor order on a machine should begin, based on the cumulative time required for the preceding orders. I want to use these order numbers and begin dates as input to another...
We are using CE 8.5. A published report is on a recurring schedule and runs correctly. However, if we try to View that same report, the report ends halfway through and some of the data is missing on the last page.
I don't see any settings on the Page Server that could be increased. Does...
A co-worker is attempting to link tables from an Oracle database in Access 2000, using the Oracle ODBC driver. Once he selects the datasource, the tables list never appears, and Access seems to hang. He is using client and ODBC versions 9.2. I have versions 9.1 of both, and am able to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.