1 Reply Latest reply: Mar 13, 2016 12:36 AM by Digvijay Singh RSS

    clicking text box the column should be enable

    naveen kumar

      suppose this is my data:

       

       

      PLACESHIPSTATUSQUANTITY            tm
      Load Portshipment10130,000.009.2
      Load Portshipment20130,000.008.7
      Load Portshipment30140,000.003.6

      Discharge      shipment1              01                  100                    1.5

      Discharge      shipment4              01                  500                    6.6

      Discharge      shipment5              01                  400                    4.5

      Plant            shipment1              01                  1000                    1.2

      Plant            shipment4              01                  1000                    5.3

      Plant            shipment6            01                  1000                      2.6



      for that data i created two text boxs by writing these expressions


                                                            loadport

                  sum of quantity        100000(text box1)........exp1:=sum({<PLACE={'LOAD PORT'},SHIP_STATUS={1}>}TOTALQTY_DAILY)


                          TM                    9.2(textbox2).......

      .exp2=sum({<PLACE={'LOAD PORT'},SHIP_STATUS={1}>}QTY_DAILY*TM)/sum({<PLACE={'LOAD PORT'},SHIP_STATUS={1}>} QTY_DAILY)


      i am trying to show breaks for each text box in a straight table i am showing the breakups for both quantity and tm

      i am succeed in showing quantity breaks by adding  all the dimension in straight table

      Dimension:PLACE,SHIP,QUANTITY,TM

       

      under quantity dimension :Enable conditional

                                      if(GetSelectedCount(PLACE)>0,QTY_DAILY,0)


      on textbox1:action--->select field--->  field

                                                                place

                                                                value

                                                                loadport



      over here i want to hide TM column when textbox 1 is clicked


      in the same way

      when i click textbox2: i need to show both QUANTITY AND TM column breakup values  .........