Parameter value is not a valid value

Parameter value is not a valid value

Posted by: naiyin on 4 September 2024, 9:43 pm EST

• 

  naiyin

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 September 2024, 9:43 pm EST - Updated 4 September 2024, 9:48 pm EST

  How do you tell or debug to find out what parameter value is not valid value?

  For me, there is no way to tell, but from my understanding, all values are valid for me.

  

  1751×459 107 KB

• 

  katyayny.raghuvanshi

  

  • Post Options:
  • Link
    Copy

  Posted 5 September 2024, 6:15 am EST

  Hi James,

  It would be difficult for us to comment on the exact cause of the issue without actually looking into your report. Could you please try providing us with your sample and runnable report along with sample data replicating the issue so that we can investigate the same at our end and get back to you accordingly?

• 

  naiyin

  • Post Options:
  • Link
    Copy

  Posted 10 September 2024, 6:35 pm EST - Updated 10 September 2024, 6:42 pm EST

  Here are all the Parameters that I’m using in my report
  
  The tool is not able to tell me which parameter has an issue, but just simply throwing the Parameter value is not a valid value exception.

  All the input parameters should be nullable
  
  However, it requires at least one of them to run the report

  <ReportParameters>
  		<ReportParameter Name="invoiceId">
  			<AllowBlank>true</AllowBlank>
  			<DataType>String</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>invoiceId</Prompt>
  		</ReportParameter>
  		<ReportParameter Name="allUnprinted">
  			<DataType>Boolean</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>allUnprinted</Prompt>
  		</ReportParameter>
  		<ReportParameter Name="issuanceStart">
  			<DataType>DateTime</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>issuanceStart</Prompt>
  		</ReportParameter>
  		<ReportParameter Name="issuanceEnd">
  			<DataType>DateTime</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>issuanceEnd</Prompt>
  		</ReportParameter>
  		<ReportParameter Name="invoiceNo">
  			<DataType>String</DataType>
  			<Prompt>invoiceNo</Prompt>
  			<MultiValue>true</MultiValue>
  			<Hidden>true</Hidden>
  			<ValidValues>
  				<DataSetReference>
  					<DataSetName>InvoiceNumbers</DataSetName>
  					<LabelField>InvoiceNo</LabelField>
  					<ValueField>InvoiceNo</ValueField>
  				</DataSetReference>
  			</ValidValues>
  			<DefaultValue>
  				<DataSetReference>
  					<DataSetName>InvoiceNumbers</DataSetName>
  					<LabelField>InvoiceNo</LabelField>
  					<ValueField>InvoiceNo</ValueField>
  				</DataSetReference>
  			</DefaultValue>
  		</ReportParameter>
  		<ReportParameter Name="initials">
  			<AllowBlank>true</AllowBlank>
  			<DataType>String</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>initials</Prompt>
  		</ReportParameter>
  		<ReportParameter Name="billToClientNo">
  			<AllowBlank>true</AllowBlank>
  			<DataType>String</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>billToClientNo</Prompt>
  		</ReportParameter>
  		<ReportParameter Name="operation">
  			<DataType>Integer</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>operation</Prompt>
  		</ReportParameter>
  		<ReportParameter Name="feesAdvanced">
  			<DataType>Float</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>feesAdvanced</Prompt>
  		</ReportParameter>
  		<ReportParameter Name="startInvoice">
  			<AllowBlank>true</AllowBlank>
  			<DataType>String</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>startInvoice</Prompt>
  		</ReportParameter>
  		<ReportParameter Name="endInvoice">
  			<AllowBlank>true</AllowBlank>
  			<DataType>String</DataType>
  			<Nullable>true</Nullable>
  			<Prompt>endInvoice</Prompt>
  		</ReportParameter>
  	</ReportParameters>

• 

  katyayny.raghuvanshi

  

  • Post Options:
  • Link
    Copy

  Posted 11 September 2024, 2:08 am EST

  Hi James,

  The report seems to be working as expected using the parameters shared by you. Please refer to the attached sample report. If the issue persists, please share with us your sample report with sample data replicating the issue so that we can investigate it further.

  Attachment: ParamReport.zip