all groups > sql server reporting services > april 2006 >
You're in the

sql server reporting services

group:

Report Model on tables without primary key


Report Model on tables without primary key Dan Varozza
4/28/2006 8:50:02 AM
sql server reporting services:
I am trying to create a report model on some tables that do not have a
primary key. The wizard keeps failing with the message "Table does not have a
RE: Report Model on tables without primary key yongli
5/9/2006 8:49:01 PM
You could define logic primary key in your dsv.

[quoted text, click to view]
RE: Report Model on tables without primary key Dan Varozza
5/22/2006 3:17:01 PM
WHen I run the DSV wizard it tells me that "no foreign keys were found. You
can create logical relationships on matching columns."

Then it gives me the choice to "Create logical relationships by matching
columns" and 3 Foreign Key Matches to choose from:

"Same as Primary key"
or
"Same name as destination table name"
or
"Destination table name + primary key name"

I have tried all 3 of the choices above and still the wizard fails with the
same error. "Table does not have a primary key".

Any ideas?
[quoted text, click to view]
AddThis Social Bookmark Button