SQL Reporting Notes

Error Logs:

C:\Program Files\Microsoft SQL Server\MSSQL.5\Reporting Services\LogFiles\

 

Formats: 

F

Number formats - the syntax is "type" of number, then the # of decimals.

N0 (zero)  - numbers w/no decimals.

C0 - currency without pennies

D0 - supposed to be decimal without decimals, but doesn't seem to work 

Pn - for percentages

tags: mssql, reports, syntax

Related Scribbles:
  • Reporting Software
  • SQL Server


  • ID: 941
    Author:
    leonard
    Date Updated:
    2010-06-28 19:48:35
    Date Created:
    2010-01-29 17:51:17

    Edit

    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> SQL Reporting Notes
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.