Skip to main content
J
jahnavimrudulak780947
May 12, 2021
Question

how to create column chart using a view

  • May 12, 2021
  • 2 replies
  • 0 views

Hi,
I have  a view created in DB already, the CDT, constant and Datastore were published. 
I tried to create a column chart using that view in a interface using Report Builder. I cannot see the table created from view in the dropdown of tables.
Can someone help!!

2 replies

csteward
csteward
May 12, 2021

Hi, few things to confirm:

1)  You are attempting to select the constant as the data source?  The Report Builder requires a constant, vs selecting the CDT or data store directly.

2)  Has the interface been closed/re-opened since the constant was created? 

In some configuration situations, data stores, site pages, the selectable lists do not refresh if the objects have been created since the form was last opened.  Not sure if that is the case here, but otherwise any data store constant should be available for selection.  

    mikes0011
    mikes0011
    Brainy
    May 12, 2021

    i'd also point out that the picker field for the constant in this case seems to work differently than pickers for constants in other parts of the system - here the constant name must be typed from the beginning, instead of being able to type any text contained in the name like can be done in most other places.

    Terms & ConditionsAccessibility statement