Results 1 to 2 of 2

Thread: Unique Account ID in reports

  1. #1
    Ryandbair is offline Junior Member
    Join Date
    Aug 2007
    Posts
    1

    Default Unique Account ID in reports

    I'm looking to make a report, but I need a unique account ID number in the report. In the report module, I did not see anything like this.

    I have however seen references to a GUID (per account I believe) in the database itself. Is there a way that I can access this from the report module?

    Thanks

  2. #2
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Unique Account ID in reports

    You don't specify which version of Sugar you are using, but in the Enterprise version, you could access that value by using the Enterprise Reporting module and using an SQL query that includes that column for the data source of your report.
    Regards,

    Angel Magaņa
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Call reports on contacts viewes on the account history
    By hheckner in forum General Discussion
    Replies: 1
    Last Post: 2006-10-18, 08:15 AM
  2. Replies: 0
    Last Post: 2006-08-28, 01:27 PM
  3. Account, Reports ...
    By Avihai in forum Help
    Replies: 0
    Last Post: 2006-06-21, 08:15 AM
  4. Showing Member Organizations of Account
    By Lennu in forum General Discussion
    Replies: 0
    Last Post: 2006-03-27, 12:31 PM
  5. Import contact on existing account
    By esolarc in forum Developer Help
    Replies: 1
    Last Post: 2006-03-22, 01:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •