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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

How to export opportunity detail view form

(0) ShareShare
ReportReport
Posted on by 270

Hi,

       In MS CRM 2011, we have export option for opportunities list view but i want to export opportunity detail view.     

Let me know how to export opportunity detail view as word doc, pdf file .

 

Thanks in advance.

Deshmukh

 

 

 

*This post is locked for comments

I have the same question (0)
  • GL-23071537-0 Profile Picture
    on at

    Hi Deshmukh,

    When you say Detail View--what are you referring to? When you export to Excel, you can chose to add columns to what you are exporting, and you can add all the columns from the Opportunity.  Does that resolve your question?

  • Deshmukh Profile Picture
    270 on at

    Hi  Gretchen,

        I am looking out for a solution to export the opportunity form data in word or pdf format.

    As shown in below screenshot I have to export all the data(label + value) to the format as shown in next screenshot.

    screenshot for opportunity form :

     

     

    screenshot for opportunity template:

     

     

     

    Regard's,

    Deshmukh

     

  • Suggested answer
    GL-23071537-0 Profile Picture
    on at

    Hi Deshmukh,

    Have you considered using a Word Mail Merge Template that merges the Opportunity information into Word?  

    You can also create a custom SSRS report that you could export to Word or PDF.

  • Deshmukh Profile Picture
    270 on at

    Hi Gretchen,


                        Thanks for a solution. I am using Word Mail Merge Template to merge the Opportunity information into Word but I am not able to add more than 62 data fields in one template.

     Could you please help me???


    Regards,

    Deshmukh


  • Suggested answer
    GL-23071537-0 Profile Picture
    on at

    Hi there,

    THe maximim is 62 fields, so you may need to go with a custom report if you need to export more columns than that.

    www.harris-tech.com/.../Suppressing-Address-2-Field-in-Microsoft-Dynamics-CRM-2011-Mail-Merge

  • Deshmukh Profile Picture
    270 on at

    Hi Gretchen,

     

                        I am going with SSRS report.  I have problem with fetchXml query. I am trying to get record for single opportunity record but its getting the result for all opportunity records.

    Can I, using the parameters, specify to SSRS to generate the report where opportunityId == current report opportunityid ?

     

    Please check the fetchXml code -

    <DataSets>
        <DataSet Name="DataSet1">
          <Query>
            <DataSourceName>DataSource1</DataSourceName>
            <CommandText>&lt;fetch distinct="false" mapping="logical"&gt;
                        &lt;entity name="opportunity" enableprefiltering="1" prefilterparametername="CRM_OpportunityFilter"&gt;
                        &lt;attribute name="name" /&gt;
                        &lt;attribute name="estimatedvalue" /&gt;
                        &lt;attribute name="opportunityid" /&gt;
                        &lt;/entity&gt;&lt;/fetch&gt;</CommandText>       
          <QueryParameters>
                <QueryParameter Name="CRM_OpportunityFilter">
                <Value>=Parameters!CRM_OpportunityFilter.Value</Value>
                </QueryParameter>
        </QueryParameters>
          </Query>
          <Fields>
            <Field Name="name">
              <DataField>name</DataField>
              <rd:TypeName>System.String</rd:TypeName>
            </Field>
            <Field Name="estimatedvalue">
              <DataField>estimatedvalue</DataField>
              <rd:TypeName>System.String</rd:TypeName>
            </Field>
            <Field Name="estimatedvalueValue">
              <DataField>estimatedvalueValue</DataField>
              <rd:TypeName>System.Decimal</rd:TypeName>
            </Field>
            <Field Name="opportunitycustomeridcontactcontactid_emailaddress1">
              <DataField>opportunitycustomeridcontactcontactid_emailaddress1</DataField>
              <rd:TypeName>System.String</rd:TypeName>
            </Field>
            <Field Name="opportunityid">
              <DataField>opportunityid</DataField>
              <rd:TypeName>System.String</rd:TypeName>
            </Field>
          </Fields>
        </DataSet>
      </DataSets>
      <ReportParameters>
        <ReportParameter Name="CRM_OpportunityFilter">
          <DataType>String</DataType>     
          <Prompt>Opportunity Filter</Prompt>
        </ReportParameter>
      </ReportParameters>

     

     

    Regards,

    Deshmukh

  • Suggested answer
    GL-23071537-0 Profile Picture
    on at

    Hi Deshmukh,

    You need to use pre-filtering on your report so that you can run it from the Opportunity and it passes the unique opportunity ID to the report.  Here are some resources on that.

    www.powerobjects.com/.../crm-2011-reporting-options-on-line-and-on-premise

    www.powerobjects.com/.../microsoft-dynamics-crm-pre-filtering-for-crm-reporting

    www.powerobjects.com/.../crm-custom-reports-issues-with-pre-filtering-and-non-searchable-primary-key-for-an-entity

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans