Wednesday, 15 May 2013

Stadium 4 Release: 4.1.2280.5070

Stadium 4.1.2280.5070 is available for download from the Twenty57 website. Please remember to back up your install folder before doing an upgrade. I know many people have edited the css for their chosen theme but the install will overwrite all files (except the web.config file and the configuration folder) to update them with any changes we have made. You can also rename your theme folder to something specific and change the Theme name in your web.config file to point to your 'custom' theme. The upgrade will not overwrite your renamed folder so your changes will not be lost. You will need to merge in any of the changes we have made that you want to make use of. You will need to upgrade your SAP files by opening them in the Designer, clicking Save and then refreshing them on the UI.

It is a bumper release and includes the following features:
  • ExecuteSQLCommand - Parameter Source None renamed to OutputToVariable
  • DisplayEmptyDataText is now a string rather than a Boolean Value so you can set your own message. Default is No data to display
  • The following properties can now be configured at a Global level for the Data Grid: Appearance>DataGrid
    • Column Wrap: Default True
    • Font Size: Default Empty (set from css)
    • Page Size: Default 20
    • Display Empty Data Text: Default No data to display
  • Set the font for a textbox
  • Break Tags are allowed in a label. This is the only HTML allowed
  • The UserApplicationRoleAccessRight view has been updated to include all user information
  • New Task on Site Roles: Assign Users to Site Roles. If checked a user assigned to the Site Role will be able to assign other users to Site Roles. For all existing Site Roles it is checked
  • Required Field Validation for Details View Dropdown. See . There are 2 new properties
    • IsRequired: Default is False
    • IsRequiredInitialValue: Default Please Select
    • If IsRequired is set to True then the first value in the Dropdown will be the Initial Value. The user will need to select a different value otherwise they will get a 'Required Field' message on Save
    • Any Default Value is overwritten in IsRequired is set to True
  • DataGrid Column Visible Property - Specify Condition option
  • Grid Iterator - Option to Auto Generate columns
  • Global Format Conditions Application Explorer>FormatConditions
    • Set the Font properties on a global level
    • On the control you will still need to specify the conditions (since these are usually Page and parameter specific) and select the Global Format from the Dropdown.
    • If you select a Global Format Condition you will not be able to set the Font for that specific Control Format Condition
  • Audit Logging of Users, Applications and Roles add, edit and delete
  • Hide the Stadium Header text on the Admin pages and login or change its value. You need to add the below attributes to the appSettings section of your web.config file. If you don't add them we will continue to display 'Stadium'
    • <add key="HideHeaderText" value="false" />
    • <add key="HeaderText" value="Stadium" />
  • Changes to the Forest Theme shades
  • Editable White space between the menu and the controls. You will need to change the default value in the css file for your theme to change this
    • Class: .MenuContainer
    • Property: margin-bottom: 12px;
  •  Format Conditions on Grid and Details View new property ColourField. It allows you to set the colour based on a value from one of your fields
  • Remember panel position when page is refreshed
  • Image Viewer alters the size of the panel not the image
    • Image with set width (in px) : The size of the image will not change. Only outer panel is resized. Viewing large images will have scroll bars.
    • Image with width (in %) : The size of panel will depend on image. Zooming in/out will not cause panel to resize.
    • Default width : The size of panel will depend on image.
And now for the significant change, Stadium 4 has been Upgraded to Report Viewer 2012 (version 11). We have tested a wide range of reports but please test your reports and let me know if any are not working. Please take note of the following:
  • Update your web.config file to reference Report Viewer 11 instead of 9. There are 2 places to account for different versions of IIS
    • In the HttpHandlers section replace the existing Report Viewer attribute with this one:
      • <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
    • In the  Handlers section replace the existing Report Viewer attribute with this one
      • <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
  • Microsoft Report Viewer 2012 runtime is required (http://www.microsoft.com/en-us/download/details.aspx?id=35747)
  • If you don't have SQL Server 2012 or 2008 R2 running, you can download the stand-alone report authoring tool, Report Builder 3.0 (http://www.microsoft.com/en-us/download/details.aspx?id=6116). This is the report builder application for both of these versions of SQL
    • Existing 2005 and 2008 rdls can be opened in Report Builder 3.0. A backup is automatically created for you and when you save the report it upgrades the format
    • Shared data sources have to be created on a reporting services 2008 R2 or 2012 server instance to make use of them in the tool. You cannot link to a shared data source saved elsewhere
    • You can specify a data source within the report that only exists for that report
  • Some 2005 and 2008 rdls do run in Report Viewer 2012 in local mode without requiring an upgrade. Others will give an error and need to be upgraded as described above
  • If you are running your reports in a Reporting Services instance and only viewing them in Stadium, Reporting services should take care of rendering any version of the rdl; 2012, 2008 R2, 2008 or 2005. Reporting services has a built-in 2005 report renderer
  • We have tested viewing reports running in Reporting Services 2008, Reporting Services 2008 R2 and Reporting Services 2012 instances.
Thank you to Ryan for all the development work and to Dina for all the Stadium knowledge and expertise she brings to the feature discussions as well as all the testing done!