G
Guest
How would I output a row for the Computed sums? I just want to append it as
a row at the bottom of my gridview table.
a row at the bottom of my gridview table.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mark Rae
How would I output a row for the Computed sums? I just want to append it
as
a row at the bottom of my gridview table.
http://www.google.co.uk/search?sour...IH_en-GBGB220GB220&q=<asp:GridView+totals+row
G
Guest
Thanks for the google search, but that's the first thing I tried. I'm using
'Compute' in my query which generates a row for computed sums. I was hoping
to use these values as, due to security reasons, I'm not allowed to place
code blocks on or behind the page.
'Compute' in my query which generates a row for computed sums. I was hoping
to use these values as, due to security reasons, I'm not allowed to place
code blocks on or behind the page.
M
Mark Rae
due to security reasons, I'm not allowed to place code blocks on or behind
the page.
??? You can't possibly be serious...!
G
Guest
'Fraid so. Working in a SharePoint environment that won't let me put code
blocks on the page. I can only use asp.net controls. And even then, I'm
limited. Suck to be me. but my hands are tied. That's why I'm trying to do
it all with SQL and controls.
I'm trying to find what I can get away with as far as customization, but
it's a tedious process.
CG
blocks on the page. I can only use asp.net controls. And even then, I'm
limited. Suck to be me. but my hands are tied. That's why I'm trying to do
it all with SQL and controls.
I'm trying to find what I can get away with as far as customization, but
it's a tedious process.
CG
G
Guest
even something as simple as...
<ItemTemplate> <%# Eval("Nov") %> </ItemTemplate>
Breaks the page.
*sigh*
<ItemTemplate> <%# Eval("Nov") %> </ItemTemplate>
Breaks the page.
*sigh*
M
Mark Rae
'Fraid so. Working in a SharePoint environment that won't let me put code
blocks on the page. I can only use asp.net controls. And even then, I'm
limited. Suck to be me. but my hands are tied. That's why I'm trying to
do
it all with SQL and controls.
Time to find another job...
I just can't imagine that sort of environment - how can you ever get
anything done...?
G
Guest
Time to find another job...
You can't. but that doesn't stop them from asking for more.
I just can't imagine that sort of environment - how can you ever get
anything done...?
You can't. but that doesn't stop them from asking for more.
C
carion1
Dump all the data into a temp table (make sure you add an identity
column) and then throw in your summation. Pull it out ordering by the
identity column on the temp table. Thats a dirty solution but it will
work.
Derek
column) and then throw in your summation. Pull it out ordering by the
identity column on the temp table. Thats a dirty solution but it will
work.
Derek
M
Mark Rae
You can't. but that doesn't stop them from asking for more.
Why do you put up with it...?
J
JDC
You can't. but that doesn't stop them from asking for more.
Wow. I think Confucious said "First find people you can trust. And
then trust them". It must be horrible to be a developer in an
environment that doesn't trust developers.
Anyway, my solution would be similar to the "temp table" suggestion.
You'll probably have to do your summation it in SQL, so I'd suggest a
union query which would give you the total row at the bottom. Without
any code it's going to be hard to apply a different CSS class to style
the totals differently, but hey...
SELECT MyDate, ProductCode, Amount
FROM tb_sales
UNION ALL
SELECT NULL AS myDate, NULL AS ProductCode, SUM(Amount)
FROM tb_sales
Something like that, anyway.
HTH