I have written a query and currently have a job that runs and sends an email using sp_send_dbmail in a formatted table if certain conditions are met. I use style sheets to control the format and this works fine for all columns returned using the style for td but I have a need to control the format of individual columns of data only, i.e. control the text alignment, data type, color, etc. of the value column data independently of the column header. I would like to format the individual columns below to a currency if possible and right justify them. Even if I can not format to currency, if i could format to a number format with a comma separated value (XX,XXX) I can concatenate the $ sign. I have attached a snippet of the table output as well as the code.
FYI- there is another table below the summary table shown here but I did not send it. Much similar in nature, I just need guidance on getting the style sheet embedded to work.
I found during my search on the web a query written almost identical to mine with the same issue and the response was as follows:
Note: create a css classes for each td above.
> CAST
> (( SELECT
> [td/@class]='anyclassname1', td = [Column Name 1], "*"='',
> [td/@class]='anyclassname2', td = [Column Name 2], "*"='', etc.
I have tried this and substituted [td/@class]='text-align: right', and can not get it to work.
Any help would be greatly appreciated.
> [td/@class]='anyclassname1', td = [Column Name 1], "*"='',
> [td/@class]='anyclassname2', td = [Column Name 2], "*"='', etc.
the classes are: anyclassname1 & anyclassname2
My CSS knowledge is rudimentary at best, but once you nominate a class, then the class itself should contain the wanted alignment
Katie Vaughan
ASKER
Thanks for your help. I am in the same boat with you on CSS knowledge as well. Could you advise as to where I would nominate the class in the query to refer back to it? I am truly at a complete loss here on how to do this.
Thanks!
PortletPaul
> #box-table
box-table is a class name. Now look back at your question. You will see box-table toward the top of your code there.
So you already have some class names
In html the table tag should look something like
<table class="box-table">
Then elements auch as <td> are controlled by the box-table td already defind.
Can you capture the generated @tableSummary result and provide it?
In a code block please.
> [td/@class]='anyclassname2
the classes are: anyclassname1 & anyclassname2
My CSS knowledge is rudimentary at best, but once you nominate a class, then the class itself should contain the wanted alignment