I am displaying a "Billing By Location" grid....
It provides a rundown of $$ by month bu location.
The last line show the total for each column.
Is it possible to BOLD the "TOTAL" line.... using runner or ????
Love the program.....
Page 1 of 1
[SOLVED] Format Question Format the "Total Line"
#2
Posted 29 March 2003 - 08:32 PM
You can do this if you have some unique value in your last line that identifies this line. For example if you have a word Total in some column of the last row it can be used to highlight this row.
I know it sounds vague. If you can show me you real page on the Web with actual data if I can give you more clear idea how to achieve this.
Sergey Kornilov
I know it sounds vague. If you can show me you real page on the Web with actual data if I can give you more clear idea how to achieve this.
Sergey Kornilov
Best regards,
Sergey Kornilov
Sergey Kornilov
#3
Posted 30 March 2003 - 09:13 PM
here is a link to a sample:
http://www.cms-repor.../BILLINGLOC.asp
all of the "grids" end with "Total Billed"
I do all the subtotaling in access prior to the upload.
Gotta say love the program.... and it's saved me a lot of time over front page.....
http://www.cms-repor.../BILLINGLOC.asp
all of the "grids" end with "Total Billed"
I do all the subtotaling in access prior to the upload.
Gotta say love the program.... and it's saved me a lot of time over front page.....
#4
Posted 31 March 2003 - 05:07 PM
Here is what you can do:
1. Add this code to include/style.css file
2. In your BILLINGLOC.asp file find Sub loopRs(rsData,nPageSize).
This is subroutine that displays actual data.
Modify it the following way (add line of code that is bolded):
I hope it helps.
Sergey Kornilov
1. Add this code to include/style.css file
Quote
.totalline
{
COLOR: #333333;
BACKGROUND-COLOR: #FFFFFF;
FONT-WEIGHT: bold;
}
{
COLOR: #333333;
BACKGROUND-COLOR: #FFFFFF;
FONT-WEIGHT: bold;
}
2. In your BILLINGLOC.asp file find Sub loopRs(rsData,nPageSize).
This is subroutine that displays actual data.
Modify it the following way (add line of code that is bolded):
Quote
DO UNTIL rsData.eof OR iNumberOfRows>=nPageSize
' To insure that every other one is shaded
If iShadeTheDetail = 0 then
sShadeClass = "class=shade"
iShadeTheDetail = 1
Else
sShadeClass = ""
iShadeTheDetail = 0
End If
if rsData("Location") = "TOTAL BILLED" then sShadeClass = "class=totalline"
' To insure that every other one is shaded
If iShadeTheDetail = 0 then
sShadeClass = "class=shade"
iShadeTheDetail = 1
Else
sShadeClass = ""
iShadeTheDetail = 0
End If
if rsData("Location") = "TOTAL BILLED" then sShadeClass = "class=totalline"
I hope it helps.
Sergey Kornilov
Best regards,
Sergey Kornilov
Sergey Kornilov
Page 1 of 1