Post reply

MS CRM 3.0 and Reporting Services problem

  • March 29, 2007 at 3:14 pm

    #172847

    CRM highly recommends using thier filtered views for reporting but when I use the filtered views and generate the report no data is displayed.  I use Windows NT Integrated security in my data source as the book suggests...

    If I run the query in sql analyzer, I can see the data but not when I generate the report in reporting services I cannot.

    Any help would be greatly appreciated!!

     

  • March 29, 2007 at 5:20 pm

    #697778

    When connecting to Query Analyser are you authenticating using Windows-integrated authentication? When you say Reporting Services doesn't see the data, is it that the report doesn't generate any data or that the dataset itself doesn't return any data (and hence you'll have no report fields)? Perhaps you could also try changing the data source to use a defined username/password, which can be an AD username/password if qualified (user@domain.intranet or old-style domain\user).

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply