Thursday, 23 March 2017

web confir for sharepoint reports

<appSettings>

<!--SSAS Connection string-->

<!--add key="SSASConnection" value="Provider=MSOLAP;Data Source=CDTSOLAP937D.gemini.dev;Initial Catalog=WHSVC_IT_M_IMS_1;Roles=PHOENIX"/-->

<add key="SSASConnection" value="Provider=MSOLAP;Data Source=xxx;Initial Catalog=WHSVC_IT_M_IMS_1;Roles=PHOENIX"/>







<!--Report Default Details-->

<add key="ReportGroup" value="ITALYALD"/>

<add key="ReportDefaultName" value="Strade_Region"/>







<!--Report Server Details-->

<add key="ReportServerPath" value="http://report/_vti_bin/reportserver"/>

<add key="ReportFolder" value="?http://report/SSRS/Italy/IAM/"/>

<add key="ReportExtension" value=".rdl"/><!--If SharePoint integrated use .rdl else blank-->

<!--Show Reporting Toolbars-->

<add key="ReportShowToolbar" value="No"/>

<add key="ReportShowParameterToolbar" value="No"/>







<!--iframe size (e.g. 100%/1400px or "" for full screen) [common: 1200px / 1400px]-->

<add key="iFrameWidth" value="100%"/>

<add key="iFrameHeight" value="1400px"/>







<!--Debug settings (Show errors, etc at top of screen)-->

<add key="DebugShowErrors" value="Yes"/>

<add key="DebugShowParameters" value="No"/>

<add key="DebugShowUser" value="No"/>







<!--Wholesaler query to get the default wholesaler of user logged in-->

<add key="WholesalerQuery" value="WITH MEMBER [Measures].[ParameterCaption] AS [WHOLESALER].[Wholesaler].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [WHOLESALER].[Wholesaler].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [WHOLESALER].[Wholesaler].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,[Wholesaler].[Wholesaler].DefaultMember ON ROWS FROM [WHS SALES]"/>

<add key="WholesalerParameter" value="WID"/>

<add key="ManuafacturerParameter" value="M"/>

<add key="ProductTypeParameter" value="PT"/>

<add key="ProductParameter" value="P"/>

</appSettings>

<connectionStrings>

<!--Wrapper connection-->

<!--add name="SQLWrapperConfigDB" connectionString="Data Source=cdtssql2027d.gemini.dev;Initial Catalog=WebWrapperConfig;UID=WebConfigWrapper;Password=!@#456@1(" providerName="System.Data.SqlClient"/-->

<add name="SQLWrapperConfigDB" connectionString="Data Source=xxx;Initial Catalog=WebWrapperConfig;UID=user;Passwordxxx" providerName="System.Data.SqlClient"/>

</connectionStrings>

No comments:

Post a Comment