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 ...
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.

showy123's avatar
showy123
Frequent Visitor
1 year ago

  • 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