Search results for query: *

I started a new thread which is a bit more relevant now: http://www.tek-tips.com/viewthread.cfm?qid=1283203&page=1

Hi, This thread follows on from http://www.tek-tips.com/viewthread.cfm?qid=1282217&page=1 Does anyone know if it is possible to add a report to a print job using the CRPE API? I have a program which opens a report something like: short jobhandle = PEOpenPrintJob(report_one.c_str()); and...

That's the way I created my master report and how I got the results mentioned above.

Do you mean combine disparate reports into one report? That's the same as a subreport within crystal." I do want to combine many reports into one print job. Currently the user can select which reports they want to print through a print dialog and this leads to anywhere between 1 and 18 print...

synapsevampire, Thanks for your suggestions, I understand what you said before now. I do have a bit of a time problem though, I need to get something produced pretty quickly and I am no expert with DB's or Crystal Reports. Perhaps a different approach then. We are also using the CRPE API...

Hi synapsevampire, Just to clarify, I have 20 subreports, each of which use data from two databases (Oracle, Access) so each one has the necessary links to these databases. I tried what you suggested, insert the main report as a subreport in itself. I observed the same problem. Can...

Hi Ian, Thanks for your comments. The reports are unlinked, we have about 20 reports for our application. What we want to do is combine them all into one report so that they can be printed as one document/print job. Therefore, each report is unrelated to one another, be want to able to combine...

Hi, I am using Crystal Reports 8.5. I am creating a report based on report files that already exist. I am using data from two databases, one Oracle and one Access (through OLEDB). When I insert a subreport from a file, I find that all the fields from Access are missing from the subreport, but...

synapsevampire, I have not tried to use an Access query simply because I have the reports working now and I have other project commitments, but I think it is a good idea if others have a similar situation and are looking for a solution. As regards Oracle Turkbear, we did consider creating a...

Exactly. The thing is, I don't have much choice, I didn't design the system ;-) We have a "main" database in Oracle. The Access database simply contains a data dump to be used for reporting.

Thank you very much satinsilhouette for the advice! I have played around with it a bit and I have found a solution. I have introduced two "dummy" fields, one in each table called ID. In my program I simply pass these fields a NULL value. I can now link the two tables in CR8.5 visual linking...

Hi all, I have a report (CR 8.5) which used to use two tables that were stored as paradox files. These have been replaced with an Access database. The two tables are totally unrelated and therefore there are no links between them. The report uses fields from both tables. When I go to...