May 31, 2015 at 10:08 pm
Hi Friends
First of all thank you for accepting me on this forum.
I have a scenario to bold the total row coming from view.
SalesDateBrandNameLeadTypeLeadsSalesCR%
01-Jun-2015XYZLive811012.35 %
01-Jun-2015DEFOutbound41261.46 %
01-Jun-2015XYZDEFTotal493163.25 %
May 31, 2015 at 10:26 pm
"I have a scenario to bold the total row coming from view."
Where are you trying to do this? If you're doing it in SSRS, it's pretty easy. But then you would add a tablix to your report surface and add a totals row and bold it.
If you're trying to this in SSMS, then I don't think it's possible. SSMS really isn't a presentation layer, like SSRS is, and formatting like that belongs in the presentation layer,
May 31, 2015 at 10:31 pm
Thanks for responding. I am doing this report via SSIS package and written a stored proc to trigger HTML email.
May 31, 2015 at 10:43 pm
Oh, if you're doing this as an HTML file, you can use the last-child pseudoclass to format the last row of a table.
May 31, 2015 at 10:49 pm
How do I code using SQL in stored proc. SOrry i am not a advanced user for sql.
June 1, 2015 at 8:48 pm
it does not display bold at the end, even i coded the nth child in tr tag.
June 1, 2015 at 9:03 pm
the answer was here the whole time... all you had to do was search for it.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply