Skip to main content
Answer

How to Get Opportunity Class Attributes in ReportDesigner for Sales Quote

  • June 5, 2024
  • 3 replies
  • 99 views

Hello,

I am amending our Sales Quote Template in ReportDesigner. I want to know how to get the Attributes from the Opportunity in the Attributes Tab (See first image)?

 

So, I have set up different Opportunity Classes that have different Attributes available. Once that Opportunity Class is selected on an Opportunity, those Attributes become available in the Attributes Tab. i want to be able to have the values available to pulled into the Sales Quote Template.

 

Please advise if any solutions.

Best answer by DipakNilkanth

Hi @bonnielemay ,

You need to join the CSAnswers table to the CSAttribute table and further join the CSAttribute to CSAttributeDetail by AttributeID to retrieve the attribute values.

3 replies

DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi @bonnielemay ,

You need to join the CSAnswers table to the CSAttribute table and further join the CSAttribute to CSAttributeDetail by AttributeID to retrieve the attribute values.


nhatnghetinh
Captain II
Forum|alt.badge.img+11

Hi @bonnielemay 

Please refer to the pictures below:

 

 

 

 

 

 

 

 

Best Regards,

NNT


  • Author
  • Freshman I
  • June 7, 2024

Hello @Dipak Nilkanth and @nhatnghetinh ,

 

Thank you for your prompt responses. I am currently working on other urgent items; however, I will be definitely trying this recommended solution.

Once I do, I will provide an update.