We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

ParametersLayout in 2016

Thread ID:

Created:

Updated:

Platform:

Replies:

142413 Feb 1,2019 12:50 PM UTC Feb 4,2019 10:06 AM UTC JavaScript 2
loading
Tags: ejReportDesigner
Andy Beaulieu
Asked On February 1, 2019 12:50 PM UTC

We are using build 16.4.0.48 of the Report Designer Control.

Our RDL is 2016 Schema, so it includes a ParametersLayout section.

If we use the Designer to add in a new Parameter using the Report Designer, and then save the report, it doesn't look like the Designer is adding to the ParametersLayout section.

So, when we try to save the modified RDL back to SSRS, it is complaining with "The parameter panel layout for this report contains more parameters than total cells available."

Below you can see an example - "ReportParameter1" was added in the designer, but wasn't added to the ReportParametersLayout

  <ReportParameters>
    <ReportParameter Name="ReportTimeStamp">
      <DataType>DateTime</DataType>
      <Nullable>true</Nullable>
      <Prompt>ReportTimeStamp</Prompt>
      <Hidden>true</Hidden>
    </ReportParameter>
    <ReportParameter Name="ConnectionString">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <Prompt>ConnectionString</Prompt>
      <Hidden>true</Hidden>
    </ReportParameter>
    <ReportParameter Name="ReportParameter1">
      <DataType>String</DataType>
      <Prompt>ReportParameter1</Prompt>
    </ReportParameter>
  </ReportParameters>
  <ReportParametersLayout>
    <GridLayoutDefinition>
      <NumberOfColumns>2</NumberOfColumns>
      <NumberOfRows>1</NumberOfRows>
      <CellDefinitions>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>ReportTimeStamp</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>ConnectionString</ParameterName>
        </CellDefinition>
      </CellDefinitions>
    </GridLayoutDefinition>
  </ReportParametersLayout>




Andy Beaulieu
Replied On February 3, 2019 02:29 PM UTC

I looked into this a bit more, and came to the conclusion that the Report Designer is happier with a 2010 schema instead of a 2016 schema...

I think this will actually work OK for us, since we probably don't need the most recent 2016 functionality in these particular RDL's.

So instead of:

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition"   ...

... we are going with:

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition"    ...

Mageshyadav M [Syncfusion]
Replied On February 4, 2019 10:06 AM UTC

Hi Andy, 
 
Please find the below response for your queries. 
 
Query 
Response 
I looked into this a bit more, and came to the conclusion that the Report Designer is happier with a 2010 schema instead of a 2016 schema... 
 
I think this will actually work OK for us, since we probably don't need the most recent 2016 functionality in these particular RDL's. 

So instead of:
 
 
 
... we are going with: 
 
 
Since SQL2010 schema version don’t have parameter layout features in MS SSRS server, so it is working properly in Report Designer. 
 
Currently we have below Parameter layout available in 2016 schema not loading in Report Designer issue which we will fix and fix changes will be available in next weekly nuget release which will rollout on February 12, 2019. 

Our RDL is 2016 Schema, so it includes a ParametersLayout section.
 
 
If we use the Designer to add in a new Parameter using the Report Designer, and then save the report, it doesn't look like the Designer is adding to the ParametersLayout section. 
 
So, when we try to save the modified RDL back to SSRS, it is complaining with "The parameter panel layout for this report contains more parameters than total cells available 
 
We were able to reproduce the mentioned parameter layout not updated properly issue in web report designer and we have confirmed that the issue is a defect and logged a defect report on this. You can keep track of this bug from the feedback portal below.  
  
  
The fix for this issue will be estimated to be available in next weekly nuget release which will rollout on February 12, 2019. 
  
If you have any more specification/precise replication procedure or a scenario to be tested you can add it as a comment in the portal.  
 
 
Regards, 
Mageshyadav.M 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;