Results 1 to 3 of 3

Thread: Reports data for drop downs / lists does not display WHEN SCHEDULED

  1. #1
    Thyssen is offline Sugar Community Member
    Join Date
    Oct 2007
    Posts
    38

    Default Reports data for drop downs / lists does not display WHEN SCHEDULED

    We have reports that work just fine when you view them on the sugar intranet site. The minute you schedule a report, it creates an email with a pdf attached to the email. When you open that email and then open the pdf, it shows the report, however, instead of the data in the field (for drop downs / lists) it does not display the data it just displays stuff like: order_type_list, instead of the actual values in the database. This is for any drop down list field that is on the report. It is supposed to display the value selected in the drop down list. Instead it is displaying the field name / label name like " "competitors_list", for a field called competitors in the report. Where it should be displaying the actual competitors. Again this only happens with lists / drop down selections. The rest of the report (Textboxes) displays just fine.

    We are running on a SQL Server 2005 backend, PHP 5.2.5, SugarCRM 5.1.0a, IIS 6
    Last edited by Thyssen; 2008-10-28 at 01:43 PM.

  2. #2
    richarddixonfl is offline Sugar Community Member
    Join Date
    Mar 2008
    Posts
    10

    Default Re: Reports data for drop downs / lists does not display WHEN SCHEDULED

    I am having similar issues with the dropdowns not showing what is in the dropdown list and rather just showing the name of the list it in the field. Also seems that some dropdowns do not show the correct value for what is in the database upon edit/detail view, it reverts back to default value so that if you had edited the record not knowing what the dropdown value was, when you save, it reverts back to the default value..hope that made sense. but check for that as well in yours..
    Sugar Pro Ver 5.1.0b IIS6 PHP5 MSSQL 2005
    Last edited by richarddixonfl; 2008-11-18 at 07:52 PM. Reason: correction

  3. #3
    Thyssen is offline Sugar Community Member
    Join Date
    Oct 2007
    Posts
    38

    Default Re: Reports data for drop downs / lists does not display WHEN SCHEDULED

    Quote Originally Posted by richarddixonfl
    I am having similar issues with the dropdowns not showing what is in the dropdown list and rather just showing the name of the list it in the field. Also seems that some dropdowns do not show the correct value for what is in the database upon edit/detail view, it reverts back to default value so that if you had edited the record not knowing what the dropdown value was, when you save, it reverts back to the default value..hope that made sense. but check for that as well in yours..
    Sugar Pro Ver 5.1.0b IIS6 PHP5 MSSQL 2005
    Sugar has filed this as a bug. Here are the details: http://bugs.sugarcrm.com/?bug_number=26173
    I filed it about 2 weeks ago.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Target Lists - Contacts - Select from Reports
    By george_bbch in forum Marketing/Campaign Management
    Replies: 8
    Last Post: 2011-06-08, 03:40 PM
  2. Data from drop down lists not merging
    By DN667 in forum Help
    Replies: 1
    Last Post: 2009-02-04, 11:18 AM
  3. Shortcuts - reports - lists - views
    By Grahama in forum Help
    Replies: 0
    Last Post: 2005-10-20, 08:33 PM
  4. Replies: 2
    Last Post: 2005-10-20, 07:05 AM

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
  •