August 30, 2012 at 2:22 pm
Hi,
I am trying to create a report model in 2008 to join two tables from different database on the same server.
I have no problem to bring in the tables. But I got error message that complaining one table is invalid object when I try to generate the Report Model. It seems that the Report Model can only accept table from one data source.
Hope someone has seen this before and have solution for it.
Thanks in advance.
August 30, 2012 at 2:25 pm
I don't have a solution for you but an easy workaround is to create a view in one of the databases that is basically a 'passthrough' to the table in the other database, allowing you to use the view from the same source as the other table. It'll get you going until someone can help with the real issue, I haven't worked with Report Models past the basics of 'this is a report model'. Most of my work is direct reporting.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply