#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2010
    Posts
    7
    Rep Power
    0

    Unhappy Running & Sub Totals on Calculated Expressions in SQL


    Hi,

    I am wondering if someone would be able to help me solve a little challenge.
    I am familiar with Cross Join and Subreports to calculate cummulative totals. However, I have formulas/expressions in SELECT statement and I trying to calculate a subtotal for these formulas but I get an aggregate error in SQL.

    Can someone help please?

    Thanks,
    Ali
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by soultrain
    Can someone help please?
    yes, there are several of us here who can help, if you were to give us some more details

    Comments on this post

    • Vomster agrees : Show some code
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo