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

    mapping tables

    Anuradha Abeysuriya

      I have three tables contains,



      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