Missing Power View button in Excel 2013

Excel 2013 --> File --> Options

Overlapping content following the Microsoft Report Viewer control

The trick to avoid this behavior is to use the parameter: SizeToReportContent, such that:


<rsweb:ReportViewer ID="ReportViewer_Main" runat="server" Height="1250px" Width="700px" SizeToReportContent="True">
.
.
.
</rsweb:ReportViewer>








Assembly=Microsoft.ReportViewer.WebForms
Version=11.0.0.0

Calling MS SQL Server user defined functions with default parameters

User Defined Function Call:

SELECT *
FROM udf_TestDef(1, DEFAULT)

Yes!! You have to insert the term default literary!

User Defined Function Sample:

CREATE FUNCTION [dbo].[udf_TestDef]
(
@Param INTEGER
@IsBigContainerPhoto BIT = 0
)
RETURNS TABLE
AS
RETURN
(
.
.
.