Automatically adding accordions?

(2 posts) (2 voices)

Tags:

No tags yet.

  1. loydb, Member

    Is there a way to automatically add accordions on a field? I want to have each Product ID have its own accordion (and for new accordions to automatically appear when I add new products). Query below (inNPS is passed in from another report).

    Thanks!

    select 'dbr.hdr', 'Product';
    select 'dbr.hdr', 'Comment';

    select
    p.product as "Product",
    c.comment as 'Comment',
    c.sentiment as 'Sentiment',
    from nps.relComments c
    join nps.products p on c.productID = p.ID
    join nps.relProductStats s on ( (c.customerID = s.customerID) and (c.productID = s.productID))
    where s.productNPS = inNPS
    order by s.productID;

  2. myDBR Team, Key Master

    An accordion is created from a separate report result set. If you want to create accordion per product, what you do is to create a separate result set for each product. To do this, use a cursor to loop through the products and create an accordion based on the data.

    --
    myDBR Team


Reply

You must log in to post.