开发者

Crystal Reports 9 and Sql Server Synonyms?

We use a variety of Schemas in our SQL Server 2005 installations. Crystal Reports works with those properl开发者_JAVA技巧y but I have a third party app that won't render the Crystal Reports that use different Schemas (no clue why). Is it possible to get Crystal to recognize a table that is addressed by a Synonym? If so how?


It looks like Crystal Reports shows only tables, views and stored procedures in the Database Expert. One way to access a synonym is by creating a command. Double-click on "Add Command" in the Database Expert and enter a SELECT query to load data from the synonym.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜