I have created a report in Crystal 11. I have connected 2 different databases using a common field to connect them. The first set of tables pulls from the main database and they are working correctly. I am also trying to create a chart within the report that pulls information from the 2nd database. I have tried the sub report option and I still can not get it to work correctly. I don't know if this just can't be done or if I have placed the sub-report in the wrong place (report footer). I have also tried to add a new Group to the report and then add the chart in that area to pull from the second different databse but the information in the chart never appears corretly.
Can you build the chart in its own report so it shows what you want?
If so then we can work out the linking and placement in the main report.,
mlmcc