Using Multiple Data Sources

[WHUXMAN]

I have an existing report the uses a stored procedure as it's primary source. I have a situation where I need to set up a separate data source (probably but not necessarily based on parameters from the first source) with the possibility of contitional using the additional information in a formula on a report.

Is this possible? It goes a bit beyond what I've done with Crystal in the past. Any pointers on how to approach this would be appreciated

Sincerely,

Wayne

 

[Turkbear]

Hi, A report can have multiple data sources, even different database types and connections--BUT, performance will be negatively impacted if the sources are too different.

In the situation you mentioned, you could use a table in the same datasource as the SP as long as there is some link that can be made between fields in the SP and in the table.

More detail on what you need to do would be helpful..





To Paraphrase:"The Help you get is proportional to the Help you give.."