Tweaks in SQL Server Reporting Services


The above code is adopted from web site in the code snippet.

Next, you have to call this function in your table. You need to enter the following function call at the column in which you need to have your number in word.

=Code.ExpandPrice(Fields!Amount.Value,”.”)

Finally you will see following screen.



Display a Grid with Alternative Colours
In SSRS, there is no straightforward way to display a grid in alternative colours. (Displaying your girds in alternative colours will improve readability of your reports. In Excel 2007 you can do this very easily but not in SSRS)

By combining an expression in the background colour and the RowNumber function, you can add alternative colours to your reports.  RowNumber(Nothing) returns row number of the current record.  For the background property of the each text box, you need to give following expression.

=iif(RowNumber(Nothing) Mod 2, “LightBlue”, “SkyBlue”)

From the above function, the rows with even numbers will display in a light blue colour while odd row numbers will display in a sky blue colour as illustrated below:


Continues…

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

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 |