4 Replies Latest reply on Jan 31, 2013 12:43 PM by Chris Turnbull

    Custom sql Union All Issue

    Chris Turnbull

      Hi All,

       

      I have been following this http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-3/ to come to terms with Sub and Grand Totals and all is well until I try to use the Data.

       

      The Query Previews the results I expect but when I go back the the Workbook I do not have 2 Data sources as it says - just the original.  Has anyone else come across this issue?  

       

      I am using MS SQL 2008.

       

      Or am I looking i the wrong place.

       

      Thanks

       

      Chris