Forum Discussion

showy123's avatar
showy123
Frequent Visitor
1 year ago
Solved

Table with expand function

I have the following requirement

I have different batch numbers and the corresponding storage bins. Now there are batches with one storage bin which is in one table (batch number, storage bin), one row. But there are also batches that are divided into several storage bins.

Now the goal should be a table in which batch numbers and storage bins are displayed. The batch numbers that have several storage bins should be able to be opened and closed. When they are collapsed, the column should show “***”. When expanded, all storage bins.

How can this be implemented?

 

Need Help
Show and Tell
Tips and Tricks
  • Rupak_bi's avatar
    Rupak_bi
    1 year ago

    HI showy123 

    here is your solution using matrix visual

    there is a small trick inside. the Bin is there in the row but here not visible. for that you need to manually hide that colum by dragging from the grid edge.

    if this solves your problem, Please accept as solution.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Your solution is so great Rupak_bi, it worked perfect!

    Hi, showy123 

     The solutions provided by Rupak_bi do work and are as follows:

    If you have already fixed the issue, you can mark the Rupak_bi reply as a solution.

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi showy123 

     

    As always, please post a sample data and your expected result from that. You can see your data and you basically know what you want to happen, at least visually, but the rest of us can't.

    • Rupak_bi's avatar
      Rupak_bi
      Super User
      1 year ago

      HI showy123 

      here is your solution using matrix visual

      there is a small trick inside. the Bin is there in the row but here not visible. for that you need to manually hide that colum by dragging from the grid edge.

      if this solves your problem, Please accept as solution.

      • showy123's avatar
        showy123
        Frequent Visitor
        1 year ago

        Thanks,

        i think this is the right way.
        I tested it in my report and geht the Errormsg: "Could not resolve the QueryDefinition. The query contains at least two expessions in its select clause with identical native reference name 'Bin'"

        My column Bin is string and i cant change it to int

  • Rupak_bi's avatar
    Rupak_bi
    Super User
    1 year ago

    Hi, showy123 ,
    Bin is string only in my example. The error you are getting because you may have renamed your existing columns and its getting duplicate. its a query related issue.  you need to implement the solution based on the columns you have in your table.