I have to create a report where I have to bring some data which are not exist in the database. Let say I have a field called country where I have 20 records. But for some reason we need 24 countries in the report. But we can not keep that in the database table right now because we don't have any busines with them. But in future we may do business with them. Is there any way I can bring them in Crystal. If I add them in my query then there is a possibility of duplicate record in future.
If any one has any clue let me know. The final output will be in text format.
I am using Oracle9i & CR10.
If any one has any clue let me know. The final output will be in text format.
I am using Oracle9i & CR10.