I have 2 database in SQL Server , in the first I have the Budget information and in the second I have the sales data. In the sales database I have multiples tables, one for Customer, One for products, one for sites and one Fact Table for sales details In the Budget database I have the Fact table for Budget Is possible combine thgis 2 database in only one Report Model Best regards

Please check this out - http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/c68e6c50-cc32-47ef-a64e-6df14b0f1538

dear Shahfaisal: I check te link, but when I run the build process send me the next message The table property of the entity "F_PREFIN" refers to the table "dbo_F_PREFIN", whish is not in the primary sata source The F_PREFIN Entity not appears how result of the "Add new report model" step, I create this entity manually How solve this? Best regards

dear Shahfaisal: I resolve this The problem was that he was selected the second data source when I created the named query, and then the table not contain the database path Best Regards Jaime