Formating Data Fields | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Formating Data Fields

Is there any way to do mixed formatting of fonts in data fields . For instance I would like to have my price fields have the cents raised with an underline? Also I would like the $ to be a bit smaller and raised about the int. portion of the price. I have considered using three fields for this, but when my integer portion of my price fluctuates between 2,3 and 4 places the formatting doesn’t line up nicely. Is there a way to float the positioning or would have to have multiple fields for each type and set visible according to the value?
Check whether thishttp://msdn2.microsoft.com/en-us/library/ms345242.aspx is any help and I’m sure you can set such expressions in the reports. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |