7 Replies Latest reply on Sep 14, 2016 6:06 AM by EddieLotter

    ColdFusion Report Building Grouping Output By Date

    j.a.c.i.

      I am building a report in cf report builder where there records outputed are grouped and sorted by date in the cf query

       

      I need to be able to display the date as the grouped heading on each page, if there is a change of date in results on the same page i am wanting the sub heading for the new grouped date to appear on the page as a sub heading.

       

      the output i am needing is the same as the output that would be generated from the following code in a cfm output

       

      <cfoutput query="queryname" group="TransactionDate">

      #TransationDate#<br>

           <cfoutput>

      #transationTime# , #transactiontype#, #transactionamount#

           </cfoutput>

      </cfoutput>

       

      When i try and generate similar output above in cf report builder i am not able to have the TransationDate appear as the subheading once the date changes

       

      the report simply outputs the rows containing

       

      #transationTime# , #transactiontype#, #transactionamount#

       

      however at the change of date there is no sub heading appearing to separate the transaction from one date to the next via a sub heading3

       

      Adise on how to solve this would be appreciated and or reference to any examples of a cfr file that does output its results in a grouped fashion within the one page as described above