Solved

Custom report

  • 11 October 2021
  • 4 replies
  • 73 views

Userlevel 4
Badge +12

Hey,

I’m trying to change a cloned report of webreport “Backup Job Summary”.

I’ve cloned it and make some alterations.
Im trying to add default values for the client names in the Input Section,but it fail when report is run with “Conversion failed when converting the nvarchar value 'NaN' to data type int.”

I suppose that it’s the client name shown in the dropdown list that I should add but that gives an error.

According to documentation thats really all thats needed.

Anyone know what to put in there?

 

//Henke

icon

Best answer by Jagadeesh Nuthakki 11 October 2021, 20:00

View original

4 replies

Userlevel 4
Badge +12

Woops! That was posted in wrong category I guess….

Userlevel 7
Badge +23

Hey @Henke , I moved this to Tech Q&A for you (and can move elsewhere if you want, just ask)!

Based on the SQL error, you are trying to use a value to an integer.

I found some stuff on stack overflow:

https://stackoverflow.com/questions/21655110/conversion-failed-when-converting-the-nvarchar-value-to-data-type-int/21655162

and this link explains the actual issue better:

https://www.codeproject.com/Questions/359712/Conversion-failed-when-converting-the-nvarchar-val

With that said, the query wants a number and not a string.  Have you tried replacing that with a client ID?

Badge +1

Henke,

 

Value should be in id’s  instead of names. 

Ex: would be 

It basically depends on the value field mentioned in the input definition as highlighted below.

 

Userlevel 4
Badge +12

@Mike Struening@Jagadeesh Nuthakki Thanks for the clarification.
I guess what put me off was that the default value is “ALL” from the beginning.
 

I’ve made the change and it’s working.

 

BR

Henke

Reply