4 Replies Latest reply: Oct 3, 2013 1:53 PM by 4580c5d6-9859-4afe-a76d-060e7f61cad2 RSS

    Info of All day for a month in one row

    4580c5d6-9859-4afe-a76d-060e7f61cad2

      Hi All,

       

      I have some parameters out of which two parameter are Year & month. With help of this year & month I have to make report for all days in the month in one row.

       

      Eg. Some what like below

       

                     Day 1    Day 2  Day 3 Day 4  Day 5   Day 6 …….. Day 30

      Credit      1153      51       45      8256    7896    49               45

      Avalaible 1153       51       30      8256    7896    48               0

      Balance    0           0        15      0         0          1                45

       

      I'm using data source as SQL query. As the sql will pull around 30 or 31 rows of information and I have to print the values in one row and as Excel output. How this can be achieved ?