CRM 4 current user Report Builder Problem


  • I have a report that i built with sql report builder 2.0 and i am trying to run it in CRM where the only data that comes up in the report is the owner of the logged in users accounts.   I have the filteraccount and im not sure what the where clause should be so it only pulls the owners data who is running the report?  I am new to sql but have worked with crm for a long time and new to the sql report builder.  Right now it returns all the accounts for everyone but I want it to be owner specific.  I even tried to setup a parameter so the user could just select their name from a drop down before the report ran through crm but this gave me duplicate user names.  I need to figure this out as soon as possible.  I really apprecaite any help!  Thank yoU!
    • Verschoben JuergenBeckModerator Dienstag, 18. Mai 2010 21:52 Wrong Forum (Von:Microsoft Dynamics CRM)
    Dienstag, 18. Mai 2010 21:21


  • Hi,

    you can post your english crm questions here:

    Best regards,

    Jürgen Beck

    Dipl. Kfm./Wirtschaftsinformatik
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified CRM Developer
    Microsoft Certified Trainer

    ComBeck IT Services & Business Solutions
    Microsoft Gold Certified Partner
    Microsoft Small Business Specialist

    Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors
    Dienstag, 18. Mai 2010 21:50