I have a complete annual report minus totals at end. I attempted to use another sql query to generate totals for 'Literal14.Text = GenerateTotal() (see attached) without success. I deleted it out. I attempted to create temp variable table (sql 2008) - but not sure I can delcare and insert into @temp ???) - - Tried but got sql unhandled exceptions.
Is there a way to use datarows, data columns, or any other technique to store the counts for each dataRow I defined for Jan- dec and then display at end?