4 Replies Latest reply: Oct 22, 2012 4:05 PM by Gabriel Oluwaseye RSS

    mapping tables

    Anuradha Abeysuriya

      I have three tables contains,

       

      charges

      extra charges

      other charges

       

      these three tables has diffrent table structre and diffrent colums, so it difficult to union them in one table.

       

      these charges has date say charge date, extra charge date, other charge date.

       

      i have created calender tables uing all three tables.

       

       

      i need to display total charge

       

      charge+extra charge+other charge

       

       

      so there how to set a calender (date filter) ?

       

      i can use common date by renaming there,

       

      but i have use other filtters and if i do so when some one clik a filter the values are not correct.

       

      Please help