The purpose of this is to check the Excel file structure is correct before it is amended. The validation of the subscription, checks the Excel file is in the correct format and the information in the subscription is correct

 

Parameter Validation

 

Notes:

 

1.Parameters values when backed up will be exported in double quotes eg. exporting the value hello world will be saved as "hello world"

2.Multivalued parameters must be in quotes for example if a multivalue is 1,2 this must be stored in the Excel cell as "1","2". If this does not happen it will be flagged as an error. The reason they need to be quoted is the individual item could have a comma in it and would be impossible to know if it was the same value or a new value.

3.Single value items do not need to be quoted this is optional.

 

 

 

Identifying Parameter Errors

 

Report             : /SALES/Demo Report

Restore Excel file : Z:\SALES\Demo Report.xls

===================================================================

------------------------------------

Worksheet : Report Server FileShare

------------------------------------

Schema Validation : Passed

Parameter check   : Failed

******************

 

 ----------------

 Error in Row : 8

 ----------------

 Parameter: DefaultPrm invalid value

 

 

  1 of 1 row(s) failed validation

 

 

In this example here you can identify row 8 has an issue, the Excel file is called z:\sales\Demo Report.xls and the parameter with an issue is DefaultPrm

 

 

Rendering Extension Validation

 

In addition to checking the parameter values for a subscription the rendering extension is also checked. If an incorrect rendering extension is entered it will identify the row in the excel file where the error is for example:

 

report             : /SALES/Demo Report

Restore Excel file : Z:\SALES\Demo Report.xls

===================================================================

------------------------------------

Worksheet : Report Server FileShare

------------------------------------

Schema Validation : Passed

Parameter check   : Failed

******************

 

 ----------------

 Error in Row : 8

 ----------------

 Invalid rendering extension 'xmlx' Valid rendering extensions are: XML, CSV, ATOM, PDF, RGDI, HTML4.0, MHTML, EXCEL, RPL, IMAGE, WORD

 

 

  1 of 8 row(s) failed validation

 

 

 

In the above example you can see an incorrect rendering extension xmlx, it even shows what the valid extensions are