Liveware Publishing Support Forum

I need to join to a table in another database. It looks as if there is a mechanism for doing this in the "Related Tables" dialog when creating the Join. There is a Databases dropdown that I would guess is the place that other databases would be listed. However it is always empty. Is this not functioning. If not how do I do this "very basic" task.

Are you using SQL Server?__There is currently a bug that prevents the database dropdown list from populating.__The workaround is to create a User SQL report where you write the SELECT statement that does the table joins.__Alternatively you could create a View in SQL Server that does the joins and then report on that view.____We are working on solving this one and will post an update to the web site once we have a fix.____Kathleen__R&R Support__