locked
SQL server with Crystal report RRS feed

  • Question

  • Dear: 

       i have one ready crystal report file programmed with another body and its working fine with SQL 2008 data base , i want to change some thing on crystal report but i found some table or view in crystal report never exisit in the Data base.

    and i did not find any trigers or function in the data base but i found some stored procudure when i search inside his design i dont found any create view or table like the table/view name which i found inside crystal report

    please note: the database working also with SQL express edition

    Monday, April 11, 2011 6:48 PM

Answers

  • Hi Abdullfattah,
    There may be two reasons why you could not see those objects in your database. Those objects might be system objects or you don't have appropriate permissions on those objects. Therefore, I would recommend you check the following:
    1) To check the system tables, views and functions, switch to related system object node in the Management Studio Object Explorer. Such as for system tables, you can go to < table > -< system table >
    2) Connect to your database using a higher permission login account to see whether they exist under Management Studio Object Explorer, or just run some queries such as SELECT against those objects.
    Hope this helps.

    Best Regards,
    Peja Tao

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Peja Tao Tuesday, April 19, 2011 8:26 AM
    • Marked as answer by Alex Feng (SQL) Friday, April 22, 2011 8:58 AM
    Wednesday, April 13, 2011 8:11 AM