I don't think that answered all of the question.
Part of the answer lies in your TNSNAMES.ORA file. Change THAT file's entry for your database to point to the correct HOST for the new database. That's where the SERVER ("host") is changed.
Dave,
I just thought of the same thing.
HOWEVER, my data subset selection is user input parameters in Crystal Reports, and I don't think that the COMMAND (manual input of queries) allows parameters to be carried in. If no parameters are allowed, it might not work because of the Group /...
K,
Thanks. I tried that, but unfortunately it is negated by a user-input date range record selection applicable for both headers and details.
Oracle 9
Crystal Reports 9.2
Never heard of a Crystal "sub-query." And this is already a sub-report. And I can't insert a sub-report...
Well, the first pass at this was OK. Now can we try it with an Oracle database?
I have 2 tables linked one to the other. Let's call them Header and Detail linked on OrderID.
It is POSSIBLE to have a Header with NO Detail as follows:
Header 1
Detail a
Detail b
Header 2
Header...
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.