1

I am new to SQL Server Reporting Services and report designing; can anyone help me in this?

I have two questions:

  1. How can I create a column for users to input data? After that, I need to perform some operations on the data entered by the user, which I need to display in another column.

  2. How can I round a decimal to the nearest integer? For example, 6.03 to 6 and 6.52 to 7.

3

1) How to create a column to input user data and after that I need to perform some operations on data enter by the user which i need to display in another column

SSRS is not creating an application, just a report. It is not advisable to use SSRS to collect user input. A limited amount can be done using parameters but this is on a per report basis not per row as I think you're implying in the question. For example you could have a parameter to multiple values by a common factor and then display that result.

2)how to make round a decimal to nearest integer ex 6.03 to 6 and 6.52 to 7

Create an expression with the Round() function.

=Round(6.03)

this returns 6. Round also accepts a second value for number of decimal places. But instead of literal value, your fieldname would be in the parentheses:

=Round(myFieldName)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.