Merging Data Foundations together?

[nacarp]

I have 2 Data Foundations and Elements built off each. I wished to have Business Views with Elements from each Foundation but this is not allowed. Other than retyping, is there any method to move all the tables and links from one Foundation to the other?

I split the Foundations as they represent different Business Areas and Functionality - in order simplify the Linking Daigram - not the best decision now I guess - how do others go about linking 200+ tables together?

Thanks, nacarp

 

[Madawc]

A subreport would do it, a subreport can link to a completely different database. Use Edit > Subreport to pass across a data value.

THis will work but will take a long time if done at detail-section level. Each instance of the subreport will be a separate call to the server for data.

Subreports make a lot of work for computers, but save time for humans. You decide which is more important for your particular circumstances.
Where I work, we go to a lot of trouble to make our mainframe screens and reports run efficiently. We use Crystal mostly for investigations and management information, cases where it doesn't much matter if a job takes twice as long because the user can be doing something else in the meantime. For a big Crystal report that is run frequently, it would be worth going to some trouble to make it efficient. In other cases it makes sense to save programmer-time.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[nacarp]

Thanks Madawc, Yes I could do thsat, but like you said good for inefficient MAnagement Reports, but this is for Client Sites to Report for anything.

I thought about it and the easiet solution is to export my Views to XML, and then edit the two Foundations with care - if I duplicate table names, then I need to modifiy the aliases. Then Inport the XML back into Business View Manager - It's a hack, but should work.

Thanks