|
|
-
|
|
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......
|
|
-
|
|
SSRS engine logs the details of report execution log in ReportServer database and logs the and logs details of any error into log files.
Now, we have tool by which we can quickly analyze both logs, this can be downloaded fromhttp://www.microsoft.com/downloads/en/details.aspx?FamilyID=fd9031c2-2261-......
|
|
-
|
|
I hope you are aware of the t-sql quiz 2011. This has been started from 1st of this month. But, If you have not started taking part in this, I recommend we should start taking part in this.
There are many reasons for taking part in this, but some of them are
- <span style="font-fa......
|
|
-
|
|
As we know, we can write case expression in SQL in two ways.
As per BOL, defination of these two diffrent formats of CASE expression: - The simple CASE expression compares an expression to a set of simple expressions to determine the result.- The searched CASE expression evaluates a set of Boolea......
|
|
-
|
|
<p>When we setup new SSRS from configuration editor, many times initially we are not able to connect to SSRS report server or report manager URLs. We get login credential keeps appearing when access the Report Server site or Report manager blank page. I have seen this question frequently in forum a......
|
|
-
|
|
Time data type is newly added in SQL 2008, which allows us to store only time portion without storing date. Many of us have started using the time data type in designing system.
When we create a dataset which include Time field, this field’s data type becomes as Time Span in SSRS. We can di......
|
|
-
|
|
Yesterday morning when I was checking my mails, I received mail from support@microsoftcommunitycontributor.com with subject “Your online community contributions have been recognized by Microsoft”
I was pretty surprised to see this mail. Microsoft awarded me Microsoft Community Contribu......
|
|
-
|
|
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......
|
|
-
|
|
In SSRS, there is a report level property AutoRefresh. If we set this value, report will automatically refreshed after specified number of seconds in HTML rendering. The value for the AutoRefresh element must be between 0 and 2147483647.
When I was writing post on ConsumeContainerWhitespace, I ca......
|
|
-
|
|
Sometimes, we need to aggregate strings in SSRS designer. In situations, when we are using Report Model as data source this is very much needed.
There are many Aggregation functions available in SSRS, but to implement string concatenation/aggregation, we can’t directly use any of the provided......
|
|