web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / "CRM_Fullname&quo...
Microsoft Dynamics CRM (Archived)

"CRM_Fullname" parameter is missing a value

(0) ShareShare
ReportReport
Posted on by Andy Davis 100

Hi there,

I have CRM 3.0 installed on Windows SBS2003 with SQL Server 2005 and reporting services.

The problem I have is that none of the CRM parameters are being evaluated when I run a report from inside of CRM.  They all return the error "CRM_Fullname" parameter is missing a value.  However, I can run all reports successfully directly from the Report Server website.  This is true of all users.

I have found various forum articles that describe this same problem and suggest that the domain of the CRM user (from dbo.systemuser) does not match the AD domain, but in my case they do match.  The CRM accounts and AD accounts match exactly.

One thing I would like to check is the authentication method set on the datasource.  How can I check this on the shared CRM datasource in CRM 3.0?

I would be grateful for any help on this as it is now driving me nuts.

Regards,
Andy

*This post is locked for comments

I have the same question (0)
  • Jocelyn Cote Profile Picture
    Jocelyn Cote 20 on at
    Re: "CRM_Fullname" parameter is missing a value

    I have the exact same problem, any solutions?

  • Boudewijn Snoeren Profile Picture
    Boudewijn Snoeren 1,272 on at
    Re: Re: "CRM_Fullname" parameter is missing a value

    have you tried:

     select fullname from FilteredSystemUser where systemuserid = dbo.fn_FindUserGuid()

    as a new dataset?

     

  • Dodd Profile Picture
    Dodd 385 on at
    Re: "CRM_Fullname" parameter is missing a value

    Have you modified these reports in any way? The CRM_FullName parameter is an "internal" parameter that interacts with the CRM Report Viewer. This is slightly different than the typical SRS Report Viewer, in that the CRM platform has code that will offer certain features that a standard SRS Report Viewer does not (such as "Context-Sensitive" reports that can be run against records selected from a grid view, Pre-filtered reports that work with a dialog similar to the Advanced Find where users can add/remove filter criteria prior to running the report).

    Often, when people modify OOTB CRM reports (especially if they were modified with VS 2005 and not VS 2003) these parameters will be listed in the Report Parameters dialog as both "Hidden" and "Internal". The way that CRM works with SRS Reports, these checkboxes do not need to be checked, as CRM responds to these parameters as internal because of the "CRM_" prefix (ie, "CRM_FullName" as opposed to FullName). When these checkboxes are checked, the proper value is not passed to this parameter and you will see that error.

    Another cause is if you have modified these OOTB reports and in the process, removed the UserInfo dataset from the report, but you still have a textbox field on the report that references this Parameter. typically, the only time OOTB reports use the CRM_FullName parameter is for the footer textboxes that displays the user that ran the report.

    If this is the case, you should just remove the footer textbox, or replace the SQL Dataset. The standard name of this dataset is UserInfo the SQL code is typically:

    SELECT FullName,
    UPPER(SystemUserId) As SystemUserId      
    FROM FilteredSystemUser  
    WHERE DomainName = SUSER_SNAME()

    If this does not resolve your issue, feel free to post the .rdl code. I could have a look and see if anything stands out...

  • Marcello Miorelli Profile Picture
    Marcello Miorelli 10 on at
    "CRM_Fullname" parameter is missing a value

    Thanks Dodd for the message.

    I had this very same problem, when I was attempting to view the reports from the SSRS 2005 report viewer.

    The way I sorted it out was by having my user added to the CRM 3.0. It automatically added me in some of the tables in the datasource (Microsoft CRM data is stored in a Microsoft SQL Server database named <organization>_MSCRM on the SQL server ) and after that no more problems with CRM_FullName.

    cheers

    marcelo

     

  • Andy Davis Profile Picture
    Andy Davis 100 on at
    Re: "CRM_Fullname" parameter is missing a value

    For anyone who reads this, my original problem is resolved.

    I have 2 instances of Reporting Services configured on my server, one on the Default Web Site and one on the CRM Web Site.  It turned out that the registry settings for CRM were pointing it to the reporting services on the default web site rather than the CRM web site.  Once I changed this it all worked.

     

    In the registry, under key:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

     

    The setting of

    SQLRSServerURL

     

    was pointing to the wrong site.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans