EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB42574: Form Category used within an Free Form SQL attribute form is grayed out and cannot be changed in MicroStrategy Developer 9.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


KB42574: Form Category used within an Free Form SQL attribute form is grayed out and cannot be changed in MicroStrategy Developer 9.x

SYMPTOM:
 
Users attempt to change the Form category -> Category used: within an attribute form but notice it is grayed out.  There is no way to make the desired modification as seen below:
 

ka02R000000kbZRQAY_0EM440000002Cux.png

 
CAUSE:
 
This is by design whenever the attribute form is used within freeform SQL reports.  If that form category is used within a freeform SQL report, the category cannot be modified within the attribute editor because it would effect the freeform SQL reports definition as well.
 
ACTION:
 
In order to modify the form category used, the following steps can be used:
 
     1. Identify the freeform SQL reports linked to the form within the attribute editor and edit them

ka02R000000kbZRQAY_0EM440000002Cuv.png

 
     2. Navigate into the freeform SQL editor
     3. Remove the attribute form in which the form category used is needing to be modified

ka02R000000kbZRQAY_0EM440000002Cur.png

 
     4. Save and Close the freeform SQL report
     5. Edit the attribute and modify the form
     6. The form category used can now be modified since there are no freeform SQL reports linked to the form

ka02R000000kbZRQAY_0EM440000002Cut.png

 
      7. The attribute form desired can then be added back into the freeform SQL reports definition
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 14, 2017

Last Updated:

June 14, 2017