Skip to main content
Solved

Custom report


Henke
Byte
Forum|alt.badge.img+13

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

Best answer by Jagadeesh Nuthakki

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.

 

View original
Did this answer your question?

4 replies

Henke
Byte
Forum|alt.badge.img+13
  • Author
  • Byte
  • 124 replies
  • October 11, 2021

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


Mike Struening
Vaulter
Forum|alt.badge.img+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?


Forum|alt.badge.img+2

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.

 


Henke
Byte
Forum|alt.badge.img+13
  • Author
  • Byte
  • 124 replies
  • October 12, 2021

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings