|
|
-
|
|
In some situation it is required to have a page break in HTML rendering for better display. But this leads to the multiple excel sheets when we exports the report to excel file. Sometimes, users want to do some further analysis on the exported excel file and if data is exported to multiple sheets, u......
|
|
-
|
|
Many of us have started working on SQL 2008 or SQL 2008 R2 and as advised, we are using datetime2, date, time and DateTimeOffset datatypes. There are many benefits of using this over Datetime. But this post is not about that.
I have moved to my current project before six months and Initially, I wa......
|
|
-
|
|
After downloaded SQL Server Denali, I have started looking into doing some basic things. In Denali CTP1 SSMS is completely based on Visual Studio.
Clipboard Ring feature of Visual Studio is very useful. Now, with Denai we get the same feature. For more details for clipboard rings here.
With this......
|
|
-
|
|
As in previous post, we have added an average trend line to Column/Bar chart.
Now, suppose we want to change the colours of columns/bars such that, the columns below average should in different colour and columns having value above should be in other colour.
<span lang="EN-GB" style="line-height: ......
|
|
-
|
|
Before we directly jump to the topic, I would like to give a basic introduction of SELECT..INTO statement.
As, we know that, select into statement can be used to create new table with same table structure and to insert a base table rows in new table. We need to consider following things before usin......
|
|
-
|
|
While designing the reports, we need to set default date values in Date data type parameter. This question also appears many times in forums. So, I decided to create a comprehensive list of all such expressions.
Now, In expression editor we can use native VB functions for different date calculatio......
|
|
-
|
|
As we know, we can easily export SSRS reports to excel file. But, sometimes there is a user requirement to automatically refresh the data in the excel file when user opens the file again. Robert Bruckner has written this excellent post for doing this using inserting a image file into the World or E......
|
|